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.