Introducing SQL Server 2022

Introducing SQL Server 2022

Today we have announced the next major release of SQL Server 2022, now in private preview. SQL Server 2022 has built-in Azure enablement and innovations in security, performance, availability, data virtualization, and enhancements to the T-SQL language.

No alt text provided for this image

SQL Server has been creating capabilities for a hybrid data platform for years including SQL Server on Azure Arc-enabled servers. Now SQL Server 2022 takes this to the next level with:

  • Seamless and managed disaster recovery using Azure SQL Managed Instance
  • Near real-time analytics with Synapse link
  • Visibility and access controls with Azure Purview integration

Every SQL Server release has always created innovations in the “meat and potatoes” of SQL Server: security, performance, and availability. SQL Server 2022 keeps that tradition going with features like:

  • SQL Server Ledger
  • Built-in query intelligence
  • Multi-write replication with automatic conflict resolution

Built-in query intelligence includes new updates to the popular Query Store feature of SQL Server including:

  • Query Store now on by default for new databases
  • Query Store is now supported on read replicas allowing performance analytics on your read workloads
  • Query Store hints to easily shape query plans with no code changes

In addition, the next generation of Intelligent Query Processing (IQP) includes solutions to some of the most common problems you face today, all with no code changes required including:

  • Parameter Sensitive Plan optimization to allow multiple plans in cache for the same stored procedure or parameterized SQL statement.
  • MAXDOP and CE model feedback using the Query store to create a feedback cycle to automatically adapt and resolve problems with common query patterns.
  • New enhancements to memory grant feedback include persistence and new algorithms to smoothly handle memory grant fluctuations.

And there is more...

We have other new capabilities in the database engine including security enhancements, scalability improvements, and improvements to backups with better compression using Intel QuickAssist Technology and cross-platform snapshot backups.

We have new extensions to the T-SQL language to support data virtualization and backup/restore with S3 compatible storage systems. Furthermore, T-SQL will support new JSON functions and time-series capabilities.

SQL Server 2022 is here and we want your feedback. If you want to work directly with the engineering team sign-up for the private preview at?EAP Signup You can learn more about SQL Server 2022 at https://aka.ms/sqlserver2022.

In addition, I invite you to watch me with the famous Microsoft Mechanics team at https://aka.ms/SQLMechanics22.

No alt text provided for this image

Our journey with SQL Server 2022 is just starting. We look forward to giving you more details and updates as we move forward in 2022.

Bob Ward, Principal Architect, Microsoft

Yuri Gorelik

SQL Server DBA at ControlUp

3 年

Hi Bob, Does Big Data Cluster have the 2022 version as well?

回复
Thorir Hardarson

Senior Consultant at Crayon AS

3 年

Hi all, Does anybody know if SQL 2022 supports mirroring or not?

回复
Will Rayer

Business System Analyst at Jersey Post

3 年

Any progress with removing the "readonly" requirement when passing table-valued types to stored procedures? I have been waiting for this for over 10 years ??

回复
Puskar K C

Data Analyst @ University of Canberra | SQL, Python, R, Data Architecture, Statistics, Power Apps

3 年

Great news.

回复
Ziad Salem

MS Azure | Data Enthusiastic | Consulting

3 年
回复

要查看或添加评论,请登录

Bob Ward的更多文章

  • Announcing SQL Server 2025

    Announcing SQL Server 2025

    Today we are announcing SQL Server 2025 now available in private preview. SQL Server 2025 is an Enterprise AI-ready…

    86 条评论
  • The latest announcements for Microsoft and SQL

    The latest announcements for Microsoft and SQL

    We have had so many announcements for Microsoft and SQL over the last few weeks from SQLBits and The Microsoft Fabric…

    6 条评论
  • Announcing SQL Server 2022 General Availability

    Announcing SQL Server 2022 General Availability

    Today we are excited to announce the General Availability of SQL Server 2022, a hybrid data platform powered by…

    11 条评论
  • SQL Server 2022 Release Candidate is now available

    SQL Server 2022 Release Candidate is now available

    The first Release Candidate (RC0) of SQL Server 2022 is now available at https://aks.ms/getsqlserver2022.

    9 条评论
  • SQL Server 2022 CTP 2.1 is now available

    SQL Server 2022 CTP 2.1 is now available

    We released the first public preview for SQL Server, Community Technology Preview (CTP) 2.0, this past May of 2022.

    10 条评论
  • SQL Server 2022 Public Preview is here!

    SQL Server 2022 Public Preview is here!

    Last November we launched the private preview of SQL Server 2022 exciting the industry and the community that SQL…

    5 条评论
  • Learn Azure SQL: Putting it all together

    Learn Azure SQL: Putting it all together

    In my last post on Learn Azure SQL, I talked about the heart of the content for the topics Security, Performance, and…

    1 条评论
  • Learn Azure SQL: Security, Performance, and Availability

    Learn Azure SQL: Security, Performance, and Availability

    In my last post on #learnazuresql I describe the first two modules of the Azure Learning content Anna Hoffman and I…

    2 条评论
  • Learn Azure SQL: Introduction, Deploy, and Configure

    Learn Azure SQL: Introduction, Deploy, and Configure

    In my last post, I described how and why we built content, training, and labs to learn Azure SQL. In this post, I want…

  • Learn Azure SQL: How and Why

    Learn Azure SQL: How and Why

    In my first post on Azure SQL, I described why Azure is the best cloud for SQL Server. I described a new set of…

    2 条评论

社区洞察

其他会员也浏览了