Previous blogs on

By Cindy Gross on Monday, March 09, 2009 12:15:56 AM

Want to provide feedback on any Microsoft product? Want access to the latest CTPs (sometimes known as betas)?

SPNs: What They Are and How SQL Server 2000/2005 Uses Them for Kerberos Authentication

By Cindy Gross on Sunday, March 08, 2009 10:59:50 PM

SPNs: What They Are and How SQL Server 2000/2005 Uses Them


· Overview

· Vocabulary

· When SQL Server Uses an SPN

· What a valid SQL Server SPN Looks Like

· Define a Valid SQL or OLAP SPN

· How to Check an SPN

· SPN Ownership

· Prerequisites

· How to Set an SPN

· Troubleshooting

· SQL 2008

· References

How to open a file in SSMS without opening a new window

By Cindy Gross on Wednesday, January 28, 2009 9:26:51 PM

When you choose to open a file in SQL Server Management Studio (SSMS) it opens a new query window. Sometimes you would prefer to open the file in an existing window to add it to other code or to avoid entering the connection information again.

Disk Alignment for SQL Server

By Cindy Gross on Wednesday, January 28, 2009 9:25:40 PM

This is the best description I’ve seen of how to do disk alignment. It’s not really specific to SQL Server, it applies to any Windows server.

SQL Server 2005 SP3 + SP3 CU1 are available!

By Cindy Gross on Monday, December 15, 2008 6:52:49 PM

SQL Server 2005 service pack 3 (SP3) is now available! There’s also a new version of the feature pack and of BOL.

· SP3 itself contains all fixes from SP2 based CU1-CU9 but it does not include most CU10 or CU11 fixes due to the timing of when the CTP (beta) of SP3 started. This pure SP3 version is 9.00.4035. If you want to have al

New book from Kalen Delaney!

By Cindy Gross on Wednesday, October 22, 2008 12:48:10 PM

Kalen's new book is ready for pre-ordering!

Microsoft® SQL Server® 2008 Internals

How to change the collation of a SQL Server 2005 database

By Cindy Gross on Wednesday, September 10, 2008 9:03:40 PM

Sometimes you need to change the collation of a database after you have created it and populated it with objects and data. So how do you change the collation?

SQL Injection attacks

By Cindy Gross on Tuesday, June 24, 2008 5:09:22 PM

This year SQL injection attacks are being stepped up and even automated against SQL Server. While SQL injection attacks can occur against any DBMS, my blog will only address SQL Server.

How to estimate disk space needed for SQL Server

By Cindy Gross on Tuesday, June 24, 2008 8:44:58 AM

So how do you estimate the amount of disk space needed for a server that runs SQL Server? My assumption in answering this is that you already know approximately how big the data/indexes/logs will be but need to know how much total disk space to request on the server. The information below is for SQL Server itself, not for Analysis Services or Reporting Services. My answer is really a list of questions, because once you answer the questions for your environment you'll have a good idea of how much space you need. This is an art, not a science, so there is no one right answer.

T-SQL Debugger

By Cindy Gross on Monday, June 23, 2008 4:18:30 PM

Many people have asked where the TSQL debugger is for SQL Server 2005.

SQL Server 2008 RC0

By Cindy Gross on Thursday, June 12, 2008 11:09:45 AM

SQL Server 2008 release candidate 0 (RC0) is now available for public download. Use the links below to download SQL Server, Books Online, the Feature Pack, and more.

Where to find SQL Server hotfixes, service packs, and cumulative updates

By Cindy Gross on Tuesday, May 13, 2008 10:43:06 AM

Finding out which build is the latest or what fixes are included in a particular build can be difficult. These links should make that job easier.

How to test connectivity from a UDL

By Cindy Gross on Wednesday, April 30, 2008 2:31:16 PM

A Universal Data Link (UDL) can be very useful in troubleshooting SQL Server and Analysis Services connectivity issues.

SQL Server Memory - Lock Pages in Memory

By Cindy Gross on Monday, April 28, 2008 6:53:33 AM

Microsoft has recently revised the documentation on the below message due to our recent history with troubleshooting the warning:
A significant part of sql server process memory has been paged out.

SQL Server 2005 Service Broker References

By Cindy Gross on Monday, April 14, 2008 12:04:41 PM

Have you heard about the new Service Broker functionality in SQL Server but don't know where to start with installing, understanding, or troubleshooting it? These links will help you get started.

Should new installations of SQL Server be on 64bit or 32bit?

By Cindy Gross on Wednesday, April 09, 2008 8:03:11 AM

The switch from 32-bit to 64-bit systems can seem overwhelming. I have summarized the major changes and differences to help make your transition a bit smoother.