SQL Server Diagnostic Information Queries for January 2016

As I discussed yesterday,  I have done some fairly significant reorganization work for the SQL Server 2016, SQL Server 2014, and SQL Server 2012 versions of these queries this month. I have also made some very minor changes to the SQL Server 2008 R2 and older versions of these queries. Rather than having a separate […]

SQL Server 2014 Service Pack 1 Cumulative Update 4

On December 21, 2015, Microsoft released SQL Server 2014 Service Pack 1 Cumulative Update 4, which is Build 12.0.4436.0. This CU has 34 hotfixes in the public fix list, which is still a fairly substantial number of fixes. This shows that Microsoft has been busy fixing quite a few issues to further improve SQL Server […]

SQL Server Diagnostic Query Reorganization

After much thought, and some procrastination, I have decided to implement a fairly significant reorganization of my SQL Server Diagnostic Information Queries, starting with the SQL Server 2016 version for January 2016. I use these queries on a daily basis during my consulting work at SQLskills.com, and I have been planning on making some changes […]

Upgrading a SATA III SSD

Back in April of 2012, I built an Intel Z77 workstation that used a 512GB OCZ Vertex 4 SATA III SSD, plugged into a SATA III port for it’s Windows 7 boot drive. Back then, this was arguably the fastest consumer SSD available, with an MSRP of $699.99. This drive has soldiered on for over […]

Windows Server 2016 Technical Preview 4

Microsoft recently (Nov 19, 2015) released Windows Server 2016 Technical Preview 4, which is the fourth pre-release version of Windows Server 2016. You can download it here. According to Mary Jo Foley, Windows Server 2016 is due for release in the second half of 2016. It looks like Windows Server 2016 will be moving to […]

SQL Server Diagnostic Information Queries for December 2015

This month, I revised several queries, mainly based on suggestions from readers. The SQL Server 2016 version will continue to be improved with more SQL Server 2016-specific queries and new columns in existing queries over the next few months as I discover interesting new things in SQL Server 2016. I am also continuing to add […]