The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Sign in to Subscribe

Meeting Details

Automate the Pain Away with SQL Server 2019 by John Sterrett

Thu, Apr 04 2019 18:00 UTC

Automate the Pain Away with SQL Server 2019

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.


John Sterrett

John Sterrett is an MCSE: Data Platform, Principal Consultant and the Founder of Procure SQL LLC. John has presented at many community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and the founder of the HADR Virtual Chapter.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids