YoVDO

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

Offered By: Microsoft via YouTube

Tags

Azure SQL Courses Relational Databases Courses Intelligent Query Processing Courses

Course Description

Overview

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.

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

Related Courses

Data Analysis: Essential Skills
Microsoft via edX
Data Science Core
Microsoft via edX
Microsoft Azure Solutions (Exam 70-533) – 9 Course Bundle
Udemy
Azure Architect Technologies
Udemy
Azure PowerShell Playbook: Azure SQL
Pluralsight