Microsoft CSS

Fragmentation may cause corruption

Let me start this off by saying that I chose the title of this blog post very carefully.  You'll note that it says "fragmentation may cause corruption" not that it will cause corruption, so before you go saying "Denny says that if you have any fragmentation of the database it'll become...

If you change the default instances port number, you may not be able to connect

Something that some companies like to do is to change the port number that the default instance is listening under as a security precaution.  However this has a habit of stopping anyone from connecting to the default instance without knowing the port number. This is because the default instance...

SQL Server Standard Edition getting Lock Pages in Memory

Microsoft SQL Server 2005 and 2008 Standard edition will be getting the Lock Pages in Memory feature that SQL Server Enterprise Edition has had starting in SQL Server 2005.  This was announced by Bob Ward via the

SQL 2008 Clusters require treaking to make SQL Dumpter work

If you don't already read the CSS teams blog, I suggest that you do.  A little while ago they posted a blog post about how the

Installing SQL Server 2005 SP3 or SQL Server 2008 on XP Prep SP3 can cause Bug Check

The SQL Server CSS team has just posted a