Wayne Sheffield - Intelligent Query Processing

Session Abstract:
SQL Server has evolved many times over the years. SQL Server 2019 introduces "Intelligent Query Processing", greatly enhancing the "Adaptive Query Processing" which was introduced in SQL Server 2017. Intelligent Query Processing allows your queries to operate more efficiently (resulting in better query performance) - without needing to make changes to the code or the application.

In this session we will explore all of the Intelligent Query Processing features in SQL Server 2019. Time permitting, we will go into other changes in recent versions of SQL Server (such as execution plan changes and new Dynamic Management Objects) that will help improve your efficiency at troubleshooting and tuning SQL Server.

Coming away from this session, you will have plenty of reasons to want to upgrade to SQL Server 2019 immediately!

Speaker Bio:
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne