The Most Addictive Python and SQL Courses
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
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