SQL Server Portal

The most Azure Enabled SQL Server is now being launched as SQL server 2022(16.x). It has a lot of new features and enhancements too. You can download it from here and use its express and developer edition for FREE.

New Features & Enhancements of SQL Server 2022:

• Analytics:

In analytics, there are many new features and enhancements, few of them are shown below :

1. Azure Synapse Link for SQL
2. Object storage integration

Here is the full list of enhancements and new features in the Analytics.

• Availability:

In Availability, there are many new features and enhancements, few of them are shown below.

1. Link to Azure SQL Managed Instance
2. Contained availability group
3. Improved backup metadata

Here is the full list of enhancements and new features in the Availability.

• Security:

In Security, there are many new features and enhancements, few of them are shown below.

1. Microsoft Defender for Cloud integration
2. Microsoft Purview integration
3. Ledger

Here is the full list of enhancements and new features in the Security.

• Performance:

In Performance, there are many new features and enhancements, few of them are shown below.

1. Buffer pool parallel scan
2. Ordered clustered columnstore index

Here is the full list of enhancements and new features in the Performance.

• Query Store and intelligent query processing:

In Query Store and intelligent query processing, there are many new features and enhancements, few of them are shown below.

1. Query Store on secondary replicas
2. Query Store hints
3. Memory grant feedback
4. Parameter sensitive plan optimization

Here is the full list of enhancements and new features in the Query Store and intelligent query processing.

• Management:

In Management, there are many new features and enhancements, few of them are as shown below.

1. Manage Azure extension for SQL Server
2. Max server memory calculations
3. Accelerated Database Recovery (ADR) improvements

Here is the full list of enhancements and new features in the Management.

• Platform:

In platform, there are many new features and enhancements, few of them are as shown below.

1. Hybrid buffer pool with direct write
2. Integrated acceleration & offloading

Here is the full list of enhancements and new features in the Platform.

• Language:

In Language, there are many new features and enhancements, few of them are as shown below.

1. Resumable add table constraints
2. CREATE INDEX
3. Transactional replication

Here is the full list of enhancements and new features in the Language.

Reference Links:

1. What’s new in SQL Server 2022

Read Full Post »