Hugo Kornelis
Information & Communications Technology
SQL Server Azure SQL Azure SQL Database Azure SQL DB SQL SQL Server DBA performance tuning Indexing
Zeewolde, Flevoland, Netherlands
Query processing in SQL Server 2022 - Inteligent++ ?
Microsoft has done a lot of work since SQL Server 2016 to make performance tuning easier. Query Store, Adaptive Query Processing, Intelligent Query Processing, and Automatic Tuning have been released in the past years. And now "NextGen Intelligent Query Processing" has been announced for SQL Server 2022. But what does this mean? What can you expect? And most important question: will ALL queries now always finish fast, or are your tuning skills still relevant?
Hugo Kornelis
I make SQL Server fast (.com)
Hugo Kornelis is an established SQL Server communiity expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016 / 2019 - now).
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.