SQL Server Diagnostic Information Queries for November 2017

This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I often make additional minor updates to the queries periodically during the month, so if you are in doubt, downloading the latest version is always a good idea. Rather than having a separate […]

Presenting Two Sessions at the PASS Summit 2017 in Seattle

I’ll be presenting two sessions at the PASS Summit 2017 in Seattle, WA. There will be a half-day session called Migrating to SQL Server 2017 on Wednesday, November 1 in Room 6A, starting at 3:15PM, and then a regular session called Improving SQL Server Performance on Thursday, November 2 in Room 612, starting at 4:45PM. […]

SQL Server 2017 CU1 is Available

On October 24, 2017, Microsoft released SQL Server 2017 Cumulative Update 1, which is Build 14.0.3006.16. This CU has 68 hot fixes by my count, which is a fairly high count. This shows that Microsoft has been busy fixing issues that have shown up since the RTM build. I think this is a good thing. […]

Windows Server Servicing Model Changes

Microsoft has announced some changes to the release schedule and servicing model for Windows Server. The new Semi-Annual Channel is a twice-per-year feature update release with an 18 month servicing timeline (meaning that Mainstream support ends 18 months after that Semi-Annual Channel release becomes available). The current release in this channel is Windows Server, version […]

SQL Server Diagnostic Information Queries for October 2017

This month, I have added a set of diagnostic queries for Azure SQL Database. These are very much a work in progress, and they will be changing (and hopefully improving) quite a bit over the next few months There are more minor updates to the all of the versions of the queries, primarily in the […]