Intelligent Database Futures in Azure SQL and SQL Server 2022 - Data Exposed Live

Overview

Explore the latest advancements in Azure SQL DB and SQL Server's Intelligent Query Processing in this comprehensive Data Exposed Live episode. Dive into groundbreaking query performance enhancements designed to improve critical parallel workloads at scale while adapting to evolving data landscapes. Learn about Query Store's default activation and hints, Parameter-sensitive Plan optimization, Memory Grant Feedback persistence and percentile, Cardinality Estimation Feedback, and Degree of Parallelism Feedback. Watch demonstrations of PSP Optimization and CE Feedback, and discover new features like Query Compilation Replay and Approximate QP. Gain valuable insights from experts Anna Hoffman and Pedro Lopes on Microsoft's mission to enhance database performance and efficiency.

Syllabus

Stream begins.
Introductions.
Query Store ON by default.
Query Store hints.
Intelligent Database Query Processing.
Parameter-sensitive Plan (PSP).
Demo: PSP Optimization.
Memory Grant Feedback - Persistence and Percentile.
Cardinality Estimation (CE) Feedback.
Demo: CE Feedback.
Degree of Parallelism (DOP) Feedback.
Query Compilation Replay.
Approximate QP.
Learn More.