SQL Server 2022 updates for query performance and database failover

Improve hybrid workloads with updates to SQL Server 2022, now generally available. Link local SQL Servers to Azure SQL Managed Instances for bidirectional disaster recovery, achieve massive speedups with differential snapshot-based backup and restore, as well as anywhere management of your SQL Servers with Azure Arc-enabled SQL provisioning, and new pay-as-you-go licensing. For raw performance, we'll demonstrate intelligent Degree of Parallelism feedback where SQL optimizes the thread count of queries automatically.

Bob Ward, Principal Architect for Microsoft SQL Server, joins Jeremy Chapman to share improvements to query performance, Azure integration, and costs for both licensing and compute, local or in the cloud.

► QUICK LINKS:

00:00 - Introduction

01:01 - Backup and disaster recovery

02:31 - Failover between SQL Server and Managed Instance

05:24 - Snapshot backups

07:57 - Restore a snapshot backup

08:59 - SQL Server management: Pay-as-you-go

10:40 - SQL Server performance: Query optimizations

13:21 - Wrap up

► Link References:

Start a free version of SQL Server 2022 at https://aka.ms/getsqlserver2022

Check out our free online workshop at https://aka.ms/sql2022workshop

► Unfamiliar with Microsoft Mechanics?

As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.

• Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries

• Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog

• Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast

► Keep getting this insider knowledge, join us on social:

• Follow us on Twitter: https://twitter.com/MSFTMechanics

• Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/

• Enjoy us on Instagram: https://www.instagram.com/msftmechanics/

• Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics