Author Archives: Glenn Berry

SQL Server Diagnostic Information Queries for June 2016

This month, I have several improvements in the SQL Server 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. One new feature is a series of six dashes after each … Continue reading

Posted in Diagnostic Queries, SQL Server 2012, SQL Server 2014, SQL Server 2016 | Tagged | Leave a comment

Processor Tall Tales From Best Buy

I was recently doing some shopping at my local Best Buy, and I wandered through the computer section to see what they were currently selling (as I periodically like to do). While I was standing in the laptop area, a … Continue reading

Posted in Intel, Laptops | Tagged | Leave a comment

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