Microsoft has been working hard to keep your databases fast and tuned. The latest version of Sql Server takes advantage of data science more than ever and that trend is going to continue. Three pillars of change are Adaptive Query Processing, Database Automatic Tuning and Intelligent Query Diagnostics. This session will give high level overview of these features and then will focus on performance monitoring intelligence available in Azure Sql DB/DW and standalone version of Sql Server. That covers Query Store and smart tools built on top of it like Automatic Tuning, Automatic Index Management and more. In addition I will show how to consume Query Store's raw data for trending / baselining / anomaly detection (timeseries analysis/RNNs in R/python).
*** PLEASE ENSURE THAT IF YOU ARE UNABLE TO ATTEND, YOU CANCEL YOUR SPACE AND FREE IT UP FOR SOMEONE ELSE ***
Janusz Rokicki is Microsoft Data Platform Expert and certified Azure Solutions Architect with over 12 years experience working in the City of London in the Financial Services Industry (retail and investment banking, multi-asset class trading systems). He has passion for secure, high-performance, maintainable data-driven applications that can be deployed with confidence on-premises and in-cloud. With educational background in intelligent sensor networks and machine learning he is always in search of automation and optimisation opportunities.