Accelerated Database Recovery enhancements in SQL Server 2022
We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022. Read more
Blog posts
SQL Server 2022: Intel® QuickAssist Technology overview
In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup compression provides the compressed backup option for all streaming SQL Server backup types—full, differential, and transaction log. Read more
Easily migrate SQL Server applications to the cloud with Azure
Microsoft Azure knows SQL Server best and will support your cloud migration at no cost for qualifying scenarios. Read more
Cardinality Estimation Feedback in SQL Server 2022
In SQL Server 2022, we have introduced a method of CE Feedback which adjusts those assumptions in a per-query way, based on actual performance of the query over time. Read more
Manage, govern, and secure all your SQL Servers with new hybrid capabilities enabled by Azure Arc
The newest edition of SQL Server 2022 delivers continued innovation with hybrid and multicloud capabilities, made possible through Azure Arc. Read more
Azure Data Studio November release
Table Designer and Query Plan Viewer are now generally available along with previews of Oracle database migration to Azure for PostgreSQL and Azure SQL. Read more
New SQL Server on Azure Virtual Machines and Azure SQL Managed Instance DR benefits
Customers using SQL Server on Azure Virtual Machines and SQL Managed Instance are now eligible for high availability and disaster recovery benefits. Read more
Memory Grant Feedback: Persistence and Percentile Grant
Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022: feedback persistence, and percentile grant feedback. Read more
Intelligent Query Processing: degree of parallelism feedback
Part of the SQL Server 2022 blog series. DOP inefficiencies are a constant challenge; Current DOP methods are inefficient The degree of parallelism (DOP) with which a query is executed can greatly impact its performance. Any time a query is using parallelism, there is always the question of if it’s using the right amount of parallelism. Read more
Data Virtualization with PolyBase for SQL Server 2022
Microsoft SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST APIs. Read more
Backup and restore to URL for S3-compatible object storage
Part of the SQL Server 2022 blog series. Backup and restore to simple storage service (S3)–compatible object storage is a new feature introduced in SQL Server 2022 that grants the user the capability to back up or restore their databases using S3-compatible object storage, whether that be on-premises, or in the cloud. What is object storage? Read more
Intelligent Query Processing: feature family additions
SQL Server 2022 expands and improves query performance feedback mechanisms and adds two new features—parameter sensitive plans and optimized plan forcing. Read more