Building a Desktop Workstation for SQL Server Development and Testing (August 2016)

Back in March of 2014, I wrote a fairly long blog post called Building a Workstation for SQL Server 2014 Development and Testing, with an updated version in September of 2015, both of which still generate quite a bit of hits and e-mail. Since it is now about twelve months later, I thought it was […]

SQL Server 2014 Service Pack 2 CU1 is Available

On August 25, 2016, Microsoft released SQL Server 2014 Service Pack 2 CU1, which is build 12.0.5511.0. This cumulative update has 45 hotfixes in the public fix list. If you are running SQL Server 2014, this is the branch and build that you should try to be on as soon as you can do your […]

Speaking at 24 Hours of PASS on September 7, 2016

I will be presenting Dr. DMV: How to Use DMVs to Diagnose Performance Problems during the 24 Hours of PASS Preview Edition at 8AM Mountain Time (UTC –6) on September 7, 2016. Here is the abstract: SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL […]

SQL Server 2014 SP1 CU8 Available

Microsoft has released SQL Server 2014 Service Pack 1 Cumulative Update 8, which is Build 12.0.4468. This CU has 38 hotfixes in the public fix list. Since the SQL Server 2014 RTM branch is no longer a “supported service pack”, there is no corresponding CU for that branch. The hotfix below seems interesting, although Microsoft […]

SQL Server Diagnostic Information Queries for August 2016

This month, I have a new AlwaysOn AG query for SQL Server 2016 and several new improvements in the SQL Server 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets.  I have gotten quite a bit of interest about making a special version of these […]