Automatic Plan Correction is Enterprise Edition Only Feature in SQL Server 2017

One interesting and useful new feature in SQL Server 2017 is Automatic plan correction. This feature, which relies on having Query Store enabled for your database, will look for query plan choice regressions where there has been a significant regression based on CPU time for a given query. This feature essentially automates the usage of […]

New Intel Desktop Processor Families

Intel formally announced its 9th generation Core mainstream desktop processors on October 8, 2018 at its Fall Launch Event in New York. So far, they have announced three members of this family. The prices below are the MSRP prices. Actual street prices are a currently little higher, especially for the Core i9-9900K. Supply is also […]

SQL Server Diagnostic Information Queries for October 2018

This month, I have just made some minor improvements to most of the query sets. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This works for SQL Server 2008 through SQL Server 2017, for on-premises and […]

PASS Summit 2018

I will be presenting Migrating to SQL Server 2017 at the PASS Summit 2018 in Seattle, WA. I’m actually presenting a half-day session on Friday, November 9, 2018 in Room 6E. Here is the abstract: How do you design and implement a safe and successful migration from an older version of SQL Server to SQL […]

SQLSaturday Oregon

I will be delivering a full day pre-con session called Migrating to SQL Server 2017 on November 2, 2018 in Portland, OR. Here is the abstract: How do you design and implement a safe and successful migration from an older version of SQL Server to SQL Server 2017 with no data loss and virtually no […]

Autogrow All Files Feature in SSMS 18.0 Preview 4

One of the small improvements in SSMS 18.0 Preview 4 is the addition of an “Autogrow All Files” checkbox in the Database Properties dialog on Filegroups page as shown in Figure 1. This is another nice change that will hopefully make it easier for more people to enable this setting because the tooling actually makes […]