AI, Data and Machine Learning

TH16 SQL Server 2017 - Intelligence Built-in

09/20/2018

1:15pm - 2:30pm

Level: Intermediate

Scott Klein

CTO

Cloud and Devices

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