Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Azure SQL and SQL Server 2022 - Intelligent Database Futures

PASS Data Community Summit via YouTube

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

Reviews

Start your review of Azure SQL and SQL Server 2022 - Intelligent Database Futures

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.