Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Automate the Pain Away with SQL Server 2019

PASS Data Community Summit via YouTube

Overview

Discover how to leverage SQL Server 2019's advanced features to automate performance tuning in this comprehensive conference talk. Explore the evolution of SQL Server workload optimization, from traditional methods using dynamic management views and execution plan cache to modern approaches. Learn about key improvements introduced in recent versions, including Columnstore indexes, the updated cardinality estimator, and Query Store. Dive deep into SQL Server 2019's cutting-edge capabilities such as Intelligent Query Processing, Scalar UDF enhancements, and other performance-boosting tools. Gain practical insights on harnessing these features to automate performance improvements, allowing you to focus on addressing complex pain points that require manual intervention. Walk away equipped with the knowledge to streamline your database management processes and significantly enhance SQL Server performance.

Syllabus

Automate the Pain Away with SQL Server 2019 | John Sterrett | Performance

Taught by

PASS Data Community Summit

Reviews

Start your review of Automate the Pain Away with SQL Server 2019

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.