SQL Server 2022 | Faster Querying & Cloud 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:

► 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.

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

#SQLServer #AzureSQL #HybridWorkloads #AzureIntegration

[DanielWillen]

You'd get way more revenue if you had a cost limit cap on the number of cores per server. Say you had a 32 core server, you would pay only for the first 24. This would incentivise companies to invest in SQL server, knowing they will get massive performance at lower cost, where as a company might not *need* the 32 cores it's a more bearable alternative to the thousands of dollars per month that would cost.

[darksheepvids]

Hi, just a question about the backup, you suspend IO, so during those few seconds nothing can read or write to the database ? Do I understand this correctly ?