SQL Server 2016 and SQL Server 2017 both work–but if you are a IT Professional you want to be armed with all the right diagnostics to react to a mission critical problem or tune the engine to the needs for your business. Dev-Ops also requires the right tools to build and tune queries for maximum performance. SQL Server 2016 and 2017 have all the diagnostics you need just built-in to the product. There is also intelligence built-into the engine based on these diagnostics to automate, learn, and adapt. In this demo-filled session, you'll see the wide variety of these built-in diagnostics and performance tools, and you will learn why SQL Server diagnostics are the best in the industry, built-in, and spans all platforms across SQL Server, Azure, and Linux.

You will learn:

• About the features in AQP (Adaptive Query Processing)
• About Auto Tuning
• About Diagnostics