SQL Server 2022 updates for query performance and database failover

<p>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.</p> <p>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.</p> <p>► QUICK LINKS:</p> <p>00:00 - Introduction</p> <p>01:01 - Backup and disaster recovery</p> <p>02:31 - Failover between SQL Server and Managed Instance</p> <p>05:24 - Snapshot backups</p> <p>07:57 - Restore a snapshot backup</p> <p>08:59 - SQL Server management: Pay-as-you-go</p> <p>10:40 - SQL Server performance: Query optimizations</p> <p>13:21 - Wrap up</p> <p>► Link References:</p> <p>Start a free version of SQL Server 2022 at <a href= "https://aka.ms/getsqlserver2022">https://aka.ms/getsqlserver2022</a></p> <p>Check out our free online workshop at <a href= "https://aka.ms/sql2022workshop">https://aka.ms/sql2022workshop</a></p> <p>► Unfamiliar with Microsoft Mechanics?</p> <p>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.</p> <p>• Subscribe to our YouTube: <a href= "https://www.youtube.com/c/MicrosoftMechanicsSeries">https://www.youtube.com/c/MicrosoftMechanicsSeries</a></p> <p>• Talk with other IT Pros, join us on the Microsoft Tech Community: <a href= "https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog"> https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog</a></p> <p>• Watch or lis