Author Archives: Glenn Berry

Analyzing I/O Subsystem Performance at PASS 2014

On November 5, 2014, I had the pleasure of presenting Analyzing I/O Subsystem Performance at the PASS 2014 Summit in Seattle. I was in room 6C, coming on after Conor Cunningham’s presentation on Query Store. People seemed to like the … Continue reading

Posted in PASS, Storage Subsystems, Teaching | Leave a comment

Are Electric Cars Practical?

Elon Musk unveiled the new Tesla Model S P85D last Thursday at a big event at Hawthorne Airport in California. In my opinion, this was one of the better public events for Tesla that Elon Musk has done (at least … Continue reading

Posted in Automobiles, Electric Cars, Tesla | Tagged | Leave a comment

New Types of Azure Virtual Machines

Microsoft has announced a new set of VM sizes for Azure Virtual Machines, known as the D-series, that have faster vCPUs (compared to their older A-series Azure VMs) and local, temporary SSDs. These local SSDs are touted as being good … Continue reading

Posted in Azure Virtual Machines | Tagged , | Leave a comment

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 , | 6 Comments

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 | 4 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