’ll focus on the issues that you need to follow to make sure that you have done everything that you could do to optimize the data access codes you have written or you are going to write in future. The Database Administrators (DBA) also has great roles to play in optimizing and tuning the database performance. But, optimization scopes that fall into a DBA’s area are out of scope for these articles.
2009-12-29
5,922 reads
Many experienced DBAs understand the issues with matching up users and logins in a restored database. But what do you do when the database is read only? New author Tychang Chen brings us a technique that can help.
2009-12-28
14,167 reads
Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.
2009-12-28
2,590 reads
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
2009-12-28
1,523 reads
Can you generate repeating digits in a Fibonacci series?
2009-12-28
2,168 reads
Importing data into SQL Server is one of the strengths of the platform. However it can require a bit of work for a DBA to make this an automated process. New author David Jansen brings us a technique for importing Sharepoint and IIS logs into SQL Server for later analysis.
2009-12-24
3,932 reads
2009-12-24
742 reads
Learn how to get started working with SQL Azure and migrating SQL Server databases to SQL Azure.
2009-12-24
3,433 reads
Glenn Barry (blog, twitter) posted a note about MySpace using Fusion-IO PCi-E cards to replace hard drives in their systems....
2009-12-24
1,917 reads
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
2009-12-24
1,592 reads
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers