This deep dive session will explore how to leverage maximum benefit from SQL Server's Intelligent Query Processing suite of features. We'll also cover how these features work with Query Store, and how to configure Query Store to work well for you (including on secondary replicas). Finally, we'll discuss what database compatibility level really means and how it affects your query performance.