PART II - Data security enhancements in SQL Server 2005

In the previous edition (Data security enhancements in SQL Server 2005) , we talked about data encryption/decryption in general.   In this installment, let’s talk about key maintenance. It is important to ensure that we can decrypt our data, even in case of user mistake or corruption.   For this, we need to protect our…


Tools of the Trade: Part I – Universal Data Link Files

The other day I was working on an issue with one of our customers.    I had been having him run several different tests using a few of the tools that we use on the SQL Developer team on a daily basis.  After about the third or fourth diagnostic we ran, he asked me something…


SQL Server 2000/2005 and DST changes

Background   In August of 2005 the United States Congress passed the Energy Policy Act, which changes the dates of both the start and end of daylight saving time (DST).   When this law goes into effect in 2007, DST will start three weeks earlier (2:00 A.M. on the second Sunday in March) and will…


How can I limit the number of reboots when applying hotfixes and the like to SQL Server and OS?

Avoiding reboots after applying a Service Pack or a hotfix to SQL is a big concern to our customers.   In SQL 2005, we have made several enhancements to help you avoid a reboot after applying Service Packs and hotfixes.   To learn about these enhancements, read our MSDN article here.   Happy reading!  …


MSDTC and SQL Server on a cluster

Through this blog, we will try to address commonly asked questions about MSDTC and SQL Server on a cluster. All this information is available in BOL and KB articles, but we will summarize it here for your convenience.   Do I need to install MSDTC on my SQL Server 2005 cluster?Before installing SQL Server 2005…


SQL Server and Network Attached Storage (NAS)

Through this blog, we will address some of the commonly asked customer questions on SQL Server and Network Attached Storage (NAS).   Support for NAS database files with SQL ServerYou can configure SQL Server to store a database on a networked server or NAS storage server. You need to enable trace flag 1807 before you…


SQL Server databases are not supported on compressed volumes

It is important to understand that SQL Server database on compressed volumes are not supported. This blog will help you understand the differences between SQL 2000 and SQL 2005 w.r.t compressed drives.   SQL 2000 In SQL Server 2000, you could create a new database with its .mdf and .ldf files located on NTFS or…


Why is a SPID blocking itself in sysprocesses? How is it possible?

After you apply SQL 2000 Service Pack 4, you might observe that a SPID is blocking itself, as reported in the output of sysprocesses.   If your custom scripts/applications monitor blocking by relying on the output of sysprocesses column, they will start reporting extensive blocking on your server.   However, there is more to it…


FAQ - Configuring Log Shipping in SQL Server

Through this blog, we will try to address common customer questions on log shipping in SQL 2005.   Can log shipping be configured between SQL 2000 and SQL 2005?You cannot configure log shipping between SQL 2005 (as primary/secondary) and SQL 2000 (secondary/primary).|To demonstrate this, let’s try to configure log shipping as below:   o        SQL…


My database file is marked with automatic growth of XXXX% (e.g. 12800%). What’s going on?

You might run into a situation wherein the value of the auto-growth increment of your database files (.mdf, .ndf or .ldf) shows a very large value – e.g. 12800%   This happens if you:   Create the database by using a percentage value for the automatic growth increment of the database file (e.g 10%). Then…