SQL Server 2022 datasheet

Private Preview
SQL Server 2022
An industry leader in performance and security, powered by Azure
Take advantage of the latest SQL Server offering
Get more out of your data with the Azure-enabled capabilities of SQL Server 2022. Through integration with
Azure Synapse Analytics and Azure Purview, Microsoft is enabling customers to drive deeper insights,
predictions and governance from their data at scale.
Seamless analytics
over on-prem
operational data
Visibility over your
entire data estate
Azure Purview
Data Insights
500
450
400
350
300
250
200
150
100
50
0
SQL Server
MySQL
Oracle
IBM DB2
PostgreSQL
SAP HANA
Data Catalog
Most secure over
the last 10 years1
Vulnerabilities
Business continuity
through Azure
Data Map
Industry-leading
performance and
availability
#1 OLTP performance2
#1 DW performance
on 1TB3, 3TB4 , 10TB5,
and 30TB6
Business continuity through Azure
Seamless analytics over on-prem
operational data
Disaster recovery in the cloud with Link feature
in Azure SQL Managed Instance
Break the wall between operational and
analytical stores with Azure Synapse Link
for SQL Server
Continuously replicate data to and from the cloud
Power BI
Online failover
Cloud
Azure
DR in
the cloud
SQL Server
2022
Azure SQL
Managed Instance
IoT
SaaS
Azure Synapse
Analytics
SQL pools
Azure Machine
Learning
Azure Data
Lake Storage
Spark
pools
All TPC Claims as of 10/06/2021.
1 National Institute of Standards and Technology Comprehensive Vulnerability Database; 2 http://www.tpc.org/4087; 3 http://www.tpc.org/3374; 4 http://www.tpc.org/3380; 5 http://www.tpc.org/3362; 6 http://www.tpc.org/3364;
Data
Catalog
Visibility over your entire data estate
Get a clear view of all your data, no matter where it
is, with Azure Purview integration
Data
Map
• Automatically scan on-prem SQL Server to
capture metadata
• Classify data using built-in and custom classifiers and
Microsoft Information Protection sensitivity labels
• Set up and control specific access rights to SQL Server
Data
Insights
Most secure over the last 10 years
Enhanced security, including SQL Server Ledger
to ensure data integrity
• Use an immutable ledger to protect data from
tampering by malicious actors
• Establish digital trust in a centralized system using
blockchain technology
Database ledger
Bank A
Ledger view
Bank
Regulator
Updatable
ledger table
• Attest to other parties that data integrity has not
been compromised
Block N
Trusted
storage
Block N-1
History table
Block N-2
Industry-leading
performance and availability
Accelerate query performance and tuning with
no code changes
• Query Store now turned on by default
• Support for read replicas from availability groups
• New IQP scenarios enabled through better
together capabilities
Intelligent Query
Processing (IQP)
Next Generation
Query Store
Resources and next steps
Learn more about SQL Server 2022
aka.ms/sqlserver2022
Read more in the SQL Server 2022
Announcement blog
aka.ms/sqlserver2022blog
Watch the SQL Server 2022
Microsoft Mechanics video
aka.ms/sqlserver2022mechanics
Register to apply for the SQL Server
2022 Early Adoption Program
aka.ms/EAPSignup
“
©2021 Microsoft Corporation. All rights reserved.
”