Posts by John Sterrett

Automate the Pain Away with SQL Server 2019

The way you tune your SQL Server workloads is changing.  In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events.  In SQL Server 2012 we were introduced to Columnstore indexes; In SQL 2014 the cardinality estimator changed. With SQL Server 2016 we were given query store…
Read More