Intelligent Database Futures in Azure SQL and SQL Server 2022 - Data Exposed Live
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.