Monthly Archives: February 2011

Windows Instant File Initialization and SQL Server

One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right, which enables Windows Instant File Initialization. On a Windows Server 2003 or newer operating system, using SQL Server 2005 or … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 16 Comments

Service Pack 1 for Windows Server 2008 R2 and Windows 7

Microsoft’s Brandon LeBlanc announced the upcoming availability of Service Pack 1 for Windows Server 2008 R2 and Windows 7 on “The Windows Blog”. It will be available for download on MSDN and TechNet on February 16, and on Windows Update … Continue reading

Posted in Windows 7, Windows Server 2008 R2 | Tagged | Leave a comment

Promoted to MSDB Rockstar Blogger

I just found out this morning that I was promoted from TempDB to MSDB on Thomas LaRock’s (blog|Twitter) Rockstar blogger rankings. It is very nice to get some public recognition for your efforts, so I really appreciate this. It is … Continue reading

Posted in Microsoft Training, Teaching | Tagged , | Leave a comment

Five DMV Queries That Will Make You a Superhero in 2011!

Way back in January, 2008, I wrote a blog post called  “Five DMV Queries That Will Make You A Superhero!” which continues to get lots of hits three years later. I thought it was time to update this with a … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 10 Comments

February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries

Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information Queries and the SQL Server 2008 Diagnostic Information Queries. To go with them are the matching blank results spreadsheets for … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 5 Comments