What's new in SQL Server 2022

A first look at SQL Server 2022—the latest Azure-enabled database and data integration innovations. See what it means for your hybrid workloads, including first-time bi-directional high availability and disaster recovery between Azure SQL Managed Instance and SQL Server, Azure Synapse Link integration with SQL for ETL free near real-time reporting and analytics over your operational data, and new next-generation built-in query intelligence with parameter sensitive plan optimization. Bob Ward, SQL engineering leader, joins Jeremy Chapman to share the focus on this round of updates.

► QUICK LINKS:
00:00 - Introduction
00:38 - Overview of updates
02:19 - Disaster recovery
04:26 - Failover and restore example
06:16 - Azure Synapse integration
09:04 - Built-in query intelligence
10:19 - See it in action
12:52 - Wrap up

► Link References:
► Unfamiliar with Microsoft Mechanics?
We are 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:

#MSIgnite #SQLServer #Azure

[jefffuhr]

@9:09 *Bob Ward* says, "You know, Jeremy, as a longtime SQL professional..." Now THAT's an understatement!!! :-) Thanks for all you do, Mr. Ward.

[andreysamykin]

I believe "restore a single table from backup" feature will be the best, if/when it's implemented.

[saxonydevops]

Thanks for this Release and the Performance improvements. Very awesome!!!

[SheikhSadiKhan]

Can't wait to start exploring!! Awesome work!!

[EionRobb]

How many of those features are available to SQL Standard vs SQL Enterprise?

[brettshearerme]

Good to do engine improvements - I've got a easy improvement to improve the engine, but can't seem to get any traction.
Can we please allow constraints to relax without having to table scan

Existing Constraint - Color in ('RED', 'GREEN')
New constraint - Color in ('Red', 'GREEN', 'BLUE')

Why can't this be instant?

[tabs]

Absolutely love the dual cached plans. That's going to solve so many issues! Although watching this has given me career anxiety; 64% of our environment is running on versions earlier than 2016 😭.

[srikanthamjala]

I loved the DR part and is excellent feature for Business Continuity ; also, restoring versionless database back to on-prem is nice. Thanks for the video :)

[WindowsXP_YT]

Windows Server 2022 and SQL Server 2022 are still unreleased

[ThePaulkunze]

Does the Query Intelligence only work with stored procedures or do parameterized queries benefit as well?

[smibrahim]

If it is the case then for different parameters if it caches more plans and may face memory issue and need to wait till first release . .

[turkeyturkey]

Are there any plans in updating SSMS UI? It’s a bit dated in 2022, as not much had changed in years.

[cloudsqlbites]

Thanks for this release with improvements and awesome presentation Bob. PSP optimization will be a game changer for many of us. The failover and restore feature relatable to SQL DB geo-replication except for the hybrid model.

[SQLwithManoj]

Super excited to explore SQL Server 2022 !!!

[The_Channel_Of_Chad]

Wow! Super excited to see the Engine Improvements.