Author Archives: Glenn Berry

SQL Server Diagnostic Information Queries for September 2014

I revised a number of the queries this month in all five versions of the script. I have also added several new queries to the SQL Server 2012 and SQL Server 2014 versions of the script. Here are the current … Continue reading

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | Leave a comment

Tesla Model S Road Trip Results

I recently drove my red Tesla Model S P85 from Parker, CO to Kansas City, MO, which ended up being a round trip distance of about 1240 miles. This was my longest road trip ever in the Tesla, and it … Continue reading

Posted in Tesla | Tagged , | 5 Comments

Tesla Road Trip to SQLSaturday #300 in Kansas City

I am going to be driving my red Tesla Model S P85 from Parker, Colorado to SQLSaturday #300 in Kansas City (which is happening on September 13, 2014). I will actually be leaving on Thursday morning, and driving to Topeka, … Continue reading

Posted in SQLSaturday, Teaching | Tagged | 3 Comments

SQL Server Diagnostic Information Queries for April 2014

I made some small improvements to a few of the queries this month. I plan to add several more SQL Server 2014 specific queries over the next couple of months, along with a lot more comments on how to interpret … Continue reading

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | 1 Comment

SQL Server Diagnostic Information Queries for March 2014

I made a couple of changes in the order of the queries this month and made some other small improvements to a few queries. Rather than having a separate blog post for each version, I’ll just put the links for … Continue reading

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | Leave a comment

SQL Server 2008 R2 SP2 CU11

On February 17, 2014, Microsoft released SQL Server 2008 R2 SP2 CU11, which is Build 10.50.4302. This cumulative update has twelve hotfixes in the public fix list. If you are running SQL Server 2008 R2, the only supported Service Pack … Continue reading

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

Scaling SQL Server 2014 Pre-Con in Copenhagen

I will be travelling to Copenhagen, Denmark to deliver a full day pre-con for SQLSaturday #275 on Friday, March 28, 2014. This is a revised and expanded version of the pre-con I delivered at the 2013 PASS Summit, with a … Continue reading

Posted in SQL Server 2014, SQLSaturday, Teaching | Tagged | Leave a comment