Starting with SQL Server 2017, Microsoft introduced automatic tuning features that provide insight into potential query performance problems, recommend solutions, and automatically fix those identified problems. With each new version of SQL Server, they are building in more and more of these offerings. It's important to understand where automatic tuning helps, what problems it still doesn't solve, and how DBAs who have been query tuning for years should approach it and incorporate it into their toolbox. In this session, we dive into what is offered with the traditional on-prem installs as well as what Azure offers in the cloud. Throughout the session we will examine each of these features, touching on what they are, how they are used, and how to implement them. We will conclude with diving into Intelligent Query Processing and how it can help you obtain the maximum performance from your queries with minimal effort. Join me as we take performance tuning to the next level.