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:
Learn more about SQL Server 2022 at aka.ms/SQLServer2022
Apply to join our private preview, and try it out at aka.ms/EAPSignUp
► 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.
Subscribe to our RUclips: ruclips.net/user/MicrosoftMe...
Join us on the Microsoft Tech Community: techcommunity.microsoft.com/t...
Watch or listen via podcast here: microsoftmechanics.libsyn.com...
► Keep getting this insider knowledge, join us on social:
Follow us on Twitter: / msftmechanics
Follow us on LinkedIn: / microsoft-mechanics
#MSIgnite #SQLServer #Azure

[@andreysamykin1143]

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

[@tabs5375]

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

[@srikanthamjala3009]

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 :)

[@cloudsqlbites8886]

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.

[@The_Channel_Of_Chad]

Wow! Super excited to see the Engine Improvements.

[@saxonydevops1357]

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

[@SQLwithManoj]

Super excited to explore SQL Server 2022 !!!

[@SheikhSadiKhan]

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

[@doxxy4113]

It's Bob Ward!

[@DanielMaenle]

This is exciting!

[@EionRobb]

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

[@bankyiie]

You just echoed my thoughts out loud

[@uYahbonaEmbo]

keen to try it out

[@ThePaulkunze]

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

[@bobward436]

With both

[@sirajudeenmuhammedibrahim6799]

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

[@bobward436]

we have logic here not to cause too many plans to be cached

[@turkeyturkey3942]

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

[@brettshearerme]

Good to do engine improvements - I've got a reallllly 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?

[@WindowsXP_YT]

Windows Server 2022 and SQL Server 2022 are still unreleased