SQL Server Diagnostic Information Queries for October 2015

This month, I spent some time adding columns for the new SERVERPROPERTY options, along with adding more comments and links to the scripts. 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 […]

SQL Server 2014 SP1 Cumulative Update 3 Released

On October 19, 2015, Microsoft released SQL Server 2014 Service Pack 1 Cumulative Update 3 (Build 12.0.4425.19). This CU has 36 updates in the public fix list. If you are on the Service Pack 1 branch of SQL Server 2014 (which is where you should be by now, in my opinion), then you should be […]

Building a Z170 Desktop System with a Core i7-6700K Skylake Processor

Back when I started at SQLskills in May of 2012, I built myself a pretty nice Z77 chipset system with an Intel Core i7-3770K Ivy Bridge processor and 32GB of RAM, running Windows 7 Enterprise Edition. This system uses an ASUS P8Z77-V Deluxe motherboard, with one 512GB OCZ Vertex 4 SSD. It was about the […]