What's new in SQL Server 2022 (16.x) Preview

SQL server in this release made and improved features that are extremely important to continue having a better experience, security and flexibility using it. This release is community technology preview (CTP) 2.0. CTP 2.0 is the first public preview release. Previous releases (CTP 1.x) were available to select participants in the early adopter program (EAP).

This release:

• Is available as Evaluation Edition. It's available for a 180 day trial period, and includes all of the capabilities of Enterprise Edition.

• On Azure Virtual Machines, it's available as Developer Edition. It's available for a 180 day trial period via a SQL Server on Azure Virtual Machines marketplace image.

• For SQL Server 2022 Preview on Linux, see Release notes for SQL Server 2022 (16.x) Preview on Linux.

• Doesn't include support from Microsoft, except for select EAP customers.

Before, the features were improving and adapting in much cases from users experiences and feed backs. Always is good to hear what the customers/user are looking and what is the better for us.

Author: Microsoft

Features:

I did a resume of each characteristic, if you want to look a few more, visit: https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022?view=sql-server-ver16

Some of the new characteristics added are:

• Failover back/forth from SQL Server 2022 and Azure SQL DB Managed Instances, including restoring versionless databases from Azure SQL DB Managed Instances down to on-premises SQL Server 2022

• Parameter-sensitive plan optimization that caches multiple plans per stored procedure

• SQL Server Ledger

• Azure Synapse Link integration to avoid big ETL jobs between SQL Server and Azure Synapse

As I wrote before, SQL server 2022 doesn't have any release date. But, you can apply for the early adoption program.