Monthly Archives: December 2011

SQL Server 2008 Diagnostic Information Queries (December 2011)

Here is a fresh set of diagnostic information queries for SQL Server 2008 and 2008 R2 for December 2011. Some of the queries (which are labeled) will only work with SQL Server 2008 R2 Service Pack 1 or later. Most … Continue reading

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

SQL Server 2008 R2 RTM Cumulative Update 11

On December 19, 2011, Microsoft released SQL Server 2008 R2 RTM Cumulative Update 11 (CU11), which is Build 10.50.1807.0. I count 22 fixes in this Cumulative Update. This CU is only for the SQL Server 2008 R2 RTM branch, so … Continue reading

Posted in Microsoft, SQL Server 2008 R2 | Tagged | Leave a comment

SQL Server 2008 R2 SP1 Cumulative Update 4

On December 19, 2011, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 4 (CU4), which is Build 10.50.2796. I count 52 fixes in the fix list for this Cumulative Update, which is an unusually high number for a CU. … Continue reading

Posted in Microsoft, SQL Server 2008 R2 | Tagged | 2 Comments

SQL Server 2012 Diagnostic Information Queries (December 2011)

Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. These queries are meant to be used with … Continue reading

Posted in SQL Server 2012, SQL Server Denali | Tagged , | 3 Comments

CPU-Z 1.59 Released

One of my favorite free tools for getting some processor and memory specific information from a Windows computer (whether is is a laptop or a database server), is CPU-Z.  It gives you a lot of very useful, accurate information about … Continue reading

Posted in Computer Hardware, Processors | Tagged | 2 Comments

Scaling SQL Server – SQL Saturday #104 Precon

I will be presenting a day long preconference session on Scaling SQL Server for SQLSaturday #104 on Friday, January 6, 2012 from 8:00 AM to 5:00 PM (MT) in Colorado Springs, CO. This will be a revised and expanded version … Continue reading

Posted in Computer Hardware, PASS, Processors, SQL Server 2008 R2, SQL Server 2012, Teaching | Tagged | 1 Comment