Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Tips and Tr... » SQL Best Practices   (RSS)
Friday, February 16, 2007 11:50 AM

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
Posted by sqlblog | 1 Comments
Friday, February 16, 2007 11:21 AM

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
Posted by sqlblog | 4 Comments
Monday, January 29, 2007 10:39 AM

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.
Posted by sqlblog | 1 Comments
Wednesday, December 06, 2006 3:16 PM

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,
Posted by sqlblog | 1 Comments
Friday, October 06, 2006 12:46 PM

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
Posted by sqlblog | 4 Comments
Tuesday, October 03, 2006 9:54 PM

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 Server You can configure SQL Server to store a database on a networked server or
Posted by sqlblog | 1 Comments
Monday, October 02, 2006 8:53 PM

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
Posted by sqlblog | 6 Comments
Thursday, September 21, 2006 10:42 PM

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
Posted by sqlblog | 1 Comments
Tuesday, September 19, 2006 11:20 PM

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).|
Posted by sqlblog | 4 Comments
Monday, September 18, 2006 2:06 PM

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
Posted by sqlblog | 1 Comments
Monday, September 18, 2006 1:32 PM

Why is my transaction log file growing rapidly? How do I stop it from eating up all my disk space?

This is a very common scenario and generates quite a few calls for us. SCENARIO Transaction log file is growing rapidly and has consumed all the disk space on your drive. You don’t have any free disk space left and can no longer perform data modification
Posted by sqlblog | 1 Comments
Monday, September 18, 2006 9:44 AM

Installing SQL 2005 using the 2 CDs

Another area where we get quite a few support calls. Lets address this today. SQL 2005 Media When you order SQL 2005 media, you receive either a DVD or 2 CDs. Installing from DVD Installing from DVD is pretty straightforward. Pop in the DVD in your drive
Posted by sqlblog | 3 Comments
Sunday, September 17, 2006 4:40 PM

How to change the startup accounts for SQL Server services?

Typically, you would set the startup accounts for SQL Server services (SQL Server, SQL Agent etc) during the startup. However, there are times when you might want to change it after installation. Many DBAs are so used to Services.msc console that they
Posted by sqlblog | 1 Comments
 
Page view tracker