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 to allow us to get more insight into our performance pains. SQL Server 2017 gave us Automatic Tuning and Adaptive Query Processing to help automate performance improvements. Today, we will focus on SQL 2019 features including, Intelligent Query Processing, Scalar UDF, and more. After this session, you will be able to harness the ability to improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.

The following two tabs change content below.

John Sterrett

Latest posts by John Sterrett (see all)

Previous Post
Marketing for SQL Consultants and Business Owners
Next Post
Scrape Reddit for Testing Data using SQL Server & Python

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.