@SQLBalls walks us through understanding how to test Intelligent Query Processing, specifically Self-Healing Persistent Memory Grant Feedback from @sqlserver 2022 now a part of @AzureSQL !
Bob Ward's SQL 2022 Workshop
https://aka.ms/sql2022workshop
Get started with Storage Explorer
https://learn.microsoft.com/en-us/azu...
Quickstart: Import a .bacpac file to a database in Azure SQL Database or Azure SQL Managed Instance
https://learn.microsoft.com/en-us/azu...
Serverless compute tier for Azure SQL Database
https://learn.microsoft.com/en-us/azu...
Import a BACPAC File to Create a New User Database
https://learn.microsoft.com/en-us/sql...
Chapters
00:00 Introduction
00:48 Download World Wide Importers from GitHub
01:16 Use Azure Storage Explorer to upload Bacpac to Azure
01:52 Import Bacpac and provision Azure SQL Serverless
02:50 Import BacBac via SSMS
03:34 Validate Import via SSMS
03:53 Get Bob Ward's Class https://aka.ms/sql2022workshop
04:27 Demo Automatic performance healing with Memory Grant Feedback Persistence
07:45 Let's Keep the Coversation Going!
Watch video No-Code PERFORMANCE GAINS with Intelligent Query Processing in Azure SQL & SQL Server!! online without registration, duration hours minute second in high quality. This video was added by user Tales From The Field 10 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 183 once and liked it 12 people.