Overview
Explore the future of intelligent databases in this conference talk from the PASS Data Community Summit. Delve into the groundbreaking query performance enhancements introduced by Azure SQL DB and SQL Server under the Intelligent Query Processing family. Discover Microsoft's mission to improve critical parallel workloads at scale while adapting to the ever-changing world of data. Learn about upcoming features in the intelligent database landscape, including Query Store, Secondary Replicas, Parameter Sensitive Plans, ESP Optimization, Dispatcher Plan, Query Variants, and Visual Representation. Witness demonstrations of Force Unforced Plan, Memory Grant Feedback, Persistence, Velocity oscillation, and Cardinality Estimation C Feedback. Gain insights into the history of intelligent databases and their evolution towards more efficient and adaptive systems.
Syllabus
Introduction
History of Intelligent Database
Query Store
Secondary Replicas
Parameter Sensitive Plans
ESP Optimization
Dispatcher Plan
Query Variants
Visual Representation
Demo
Force Unforced Plan
Memory Grant Feedback
Persistence
Velocity oscillation
Demonstration
Cardinality Estimation
C Feedback
Taught by
PASS Data Community Summit