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)?
Create an account on http://connect.microsoft.com/ and you can file bugs or wishes and vote on what other people have submitted. You can also find CTPs and evaluation editions of various products. For example, to get the CTP of SQL Server 2008 SP1 go to http://connect.microsoft.com/SQLServer. From the same page you can access the SQL Server feedback section as well as the SQL Server discussion forums. Please vote on your favorite bugs/requests/wishes as this increases the chance they will change for a future version of SQL Server.
By Cindy Gross on Sunday, March 08, 2009 10:59:50 PM
SPNs: What They Are and How SQL Server 2000/2005 Uses Them
· 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
· How to Set an SPN
· SQL 2008
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.
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.
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
By Cindy Gross on Wednesday, October 22, 2008 12:48:10 PM
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?
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.
By Cindy Gross on Tuesday, June 24, 2008 8:44:58 AM
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.
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.
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.
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.
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.
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.
By Cindy Gross on Wednesday, April 09, 2008 8:03:11 AM