Azure SQL & SQL Server 2022: Intelligent Database Futures | Data Exposed Live

Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale while remaining adaptive to the constantly changing world of data! Learn more in this episode of Data Expose Live with Anna Hoffman and Pedro Lopes.

0:00 Stream begins
0:23 Introductions
3:06 Query Store ON by default
5:36 Query Store hints
16:41 Intelligent Database Query Processing
20:30 Parameter-sensitive Plan (PSP)
32:50 Demo: PSP Optimization
40:34 Memory Grant Feedback - Persistence and Percentile
45:45 Cardinality Estimation (CE) Feedback
50:56 Demo: CE Feedback
56:46 Degree of Parallelism (DOP) Feedback
59:42 Query Compilation Replay
1:00:48 Approximate QP
1:01:39 Learn More

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer #SQLServer2022