What's new in SQL Server 2022

No video

What's new in SQL Server 2022

Рет қаралды 66,744

Күн бұрын

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/SQLServ...
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 KZfaq: www.youtube.co...
Join us on the Microsoft Tech Community: techcommunity....
Watch or listen via podcast here: microsoftmecha...
► Keep getting this insider knowledge, join us on social:
Follow us on Twitter: / msftmechanics
Follow us on LinkedIn: / microsoft-mechanics
#MSIgnite #SQLServer #Azure

Пікірлер: 21

@jefffuhr2393 Ай бұрын

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

@andreysamykin1143 2 жыл бұрын

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

@tabs5375 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

Super excited to explore SQL Server 2022 !!!

@doxxy4113 2 жыл бұрын

It's Bob Ward!

@saxonydevops1357 2 жыл бұрын

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

@The_Channel_Of_Chad 2 жыл бұрын

Wow! Super excited to see the Engine Improvements.

@EionRobb 2 жыл бұрын

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

@bankyiie 2 жыл бұрын

You just echoed my thoughts out loud

@SheikhSadiKhan 2 жыл бұрын

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

@smibrahim84 2 жыл бұрын

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 2 жыл бұрын

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

@ThePaulkunze 2 жыл бұрын

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

@bobward436 2 жыл бұрын

With both

@DanielMaenle 2 жыл бұрын

This is exciting!

@brettshearerme 2 жыл бұрын

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?