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

Introduction to Databases
Meta via Coursera
Intro to Relational Databases
Udacity
Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam
Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera
Web Application Development: Basic Concepts
University of New Mexico via Coursera