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

Microsoft

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

Microsoft via YouTube

Start learning Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → DataCamp Ad

AI Engineer - Learn how to integrate AI into software applications

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course examines intelligent query processing in Azure SQL Database and SQL Server 2022, including Query Store hints, parameter-sensitive plan optimization, memory grant feedback, cardinality estimation feedback, and degree-of-parallelism feedback. Demonstrations show how adaptive features improve query performance and support query compilation replay and approximate query processing.

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.

Taught by

Microsoft Developer

Tags

Reviews

Start your review of Intelligent Database Futures in Azure SQL and SQL Server 2022 - Data Exposed Live

Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.