Microsoft SQL Server 2022 Standard Edition – DG7GMGF0M80J
AED 3,751.00 excl. VAT
For The Immediate delivery requirement contact sales team. Usually Ship in 2-3 days
Microsoft SQL Server 2022 Standard Edition – DG7GMGF0M80J
Overview
Overview
Explore SQL Server 2022 capabilities
Business continuity through Azure
Help ensure uptime with fully managed disaster recovery in the cloud through the link feature in Azure SQL Managed Instance. Continuously replicate data to and from the cloud.2
Seamless analytics over on-premises operational data
Drive insights in near real time by breaking the wall between operational and analytical stores. Analyze all your data using both Spark and SQL runtimes in the cloud with Azure Synapse Link.
Visibility over your entire data estate
Manage and govern your entire data estate to overcome data silos with Microsoft Purview.
The most secure database over the last 10 years
Achieve your security and compliance goals using the database rated as least vulnerable over the last 10 years.1 Use an immutable ledger to help protect data from tampering.
Industry-leading performance and availability
Take advantage of performance and availability for faster queries and to help ensure business continuity. Accelerate query performance and tuning with no code changes required. Keep multi-write environments running smoothly for users across multiple locations.
Hybrid capabilities and pay-as-you-go pricing are now available for all versions of SQL Server environments with Azure Arc
SQL Server, enabled by Azure Arc, extends Azure services on-premises, and manages your SQL Server estate from the Azure portal for a more unified and streamlined management experience. Monitor the health of your SQL Servers with SQL assessment—available at no additional cost—and bring enhanced security capabilities through Microsoft Defender for Cloud.
Use cloud-native features including a new pay-as-you-go model and pay for only what you use.
“Features like Query Store hints and the next generation of intelligent Query processing are awesome. The possibility of improving and maintaining great performance over time without code changes is getting better on every new SQL Server version.”
– Javier Villegas, IT Director for DBA and BI Service, Mediterranean Shipping Company
Featured SQL Server 2022 resources
SQL Server 2022 Announcement Blog
Check out the blog post announcing the general availability of SQL Server 2022. Rohan Kumar, Microsoft CVP, Azure Data, discusses the innovations and enhancements in this release.
SQL Server 2022 datasheet
Learn about all the latest features in this free SQL Server 2022 datasheet.
SQL Server 2022 documentation
Dive into the technical details including installation guidance and stay up to date on the latest release notes.
SQL Server 2022 Microsoft Mechanics video
Watch Microsoft Engineering’s Bob Ward explain and demonstrate SQL Server 2022 capabilities.
Data Exposed web series
Learn more about what’s new in SQL Server 2022. Join Anna Hoffman and engineering leaders for this series of short videos as they explore hero features and benefits.
Additional resources
Microsoft Intelligent Data Platform
Easily pivot and adapt in rapidly evolving landscapes, add layers of intelligence to applications, uncover predictive insights, and govern data anywhere with an integrated data platform.
Tech Community forums: SQL Server and Azure databases
Connect with Microsoft Engineering experts and other members of the community in message boards, and access additional resources.
SQL Bits 2023
SQLBits is the largest Microsoft Intelligent Data Platform conference with over 300 sessions from March 13-18, including SQL Server, Azure SQL, Power BI, Machine Learning, and more! Your customers can reconnect with old friends, build new relationships, gain new skills, and get world-class training.
Blogging Series
Check out the blog series to get in-depth technical learning on the latest features available with SQL Server 2022.
Workshops
Learn how to solve modern data challenges with SQL Server 2022 using a hands-on lab approach with the SQL Server 2022 workshop.
SQL Server 2022: Azure-enabled, with continued performance and security innovation
Get to know the features and benefits now available in SQL Server 2022.
Compare SQL Server versions
Feature availability
Not supported- Fully supported
| FEATURES |
SQL SERVER 2022
|
SQL SERVER 2019
|
SQL SERVER 2017
|
|---|---|---|---|
| INTELLIGENCE ACROSS ALL YOUR DATA | |||
| DATA VIRTUALIZATION USING POLYBASE[1] |
 |
|
|
| DATA VIRTUALIZATION FOR ANY DATA LAKE |
|
 |
|
| OBJECT STORAGE BACKUP AND RESTORE |
|
|
|
| AZURE SYNAPSE LINK |
|
|
|
| DATABASE PERFORMANCE | |||
| IN-MEMORY DATABASE: IN-MEMORY OLTP |
|
|
|
| IN-MEMORY DATABASE: PERSISTENT MEMORY[2] |
|
|
|
| IN-MEMORY DATABASE: MEMORY-OPTIMIZED TEMPDB |
|
|
|
| REAL-TIME OPERATIONAL ANALYTICS |
|
|
|
| INTELLIGENT QUERY PROCESSING[3] |
|
|
|
| BUFFER POOL PARALLEL SCAN |
|
|
|
| QUERY STORE ON BY DEFAULT WITH REPLICA SUPPORT |
|
|
|
| QUERY STORE HINTS |
|
|
|
| INTEGRATED ACCELERATION & OFFLOADING |
|
|
|
| HYBRID BUFFER POOL WITH DIRECT WRITE |
|
|
|
| ADVANCED VECTOR EXTENSION (AVX) 512 EXTENSION TO IMPROVE BATCH MODE OPERATIONS |
|
|
|
| AVAILABILITY | |||
| ALWAYS ON |
|
|
|
| ACCELERATED DATABASE RECOVERY |
|
|
|
| READ SCALE-OUT AVAILABILITY GROUPS |
|
|
|
| LARGE MEMORY AND CONCURRENCY SCALABILITY |
|
|
|
| MULTI-WRITE REPLICATION |
|
|
|
| LINK TO AZURE SQL MANAGED INSTANCE – REPLICAS |
|
|
|
| LINK TO AZURE SQL MANAGED INSTANCE – UNIDIRECTIONAL |
|
|
|
| LINK TO AZURE SQL MANAGED INSTANCE – BIDIRECTIONAL[6] |
|
|
|
| CONTAINED AVAILABILITY GROUP |
|
|
|
| ENCRYPTION AT REST AND IN MOTION |
|
|
|
| SECURITY | |||
| ALWAYS ENCRYPTED WITH SECURE ENCLAVES[4] |
|
|
|
| DATA DISCOVERY AND CLASSIFICATION |
|
|
|
| TRANSPARENT DATA ENCRYPTION |
|
|
|
| BACKUP ENCRYPTION SUPPORT |
|
|
|
| ENCRYPTION AT REST AND IN MOTION |
|
|
|
| DYNAMIC DATA MASKING AND ROW-LEVEL SECURITY |
|
|
|
| MICROSOFT ENTRA ID (FORMERLY AZURE ACTIVE DIRECTORY) AUTHENTICATION[7] |
|
|
|
| MICROSOFT DEFENDER FOR SQL |
|
|
|
| MICROSOFT PURVIEW INTEGRATION CENTRAL GOVERNANCE |
|
|
|
| MICROSOFT PURVIEW INTEGRATION DATA OWNER POLICIES |
|
|
|
| SQL LEDGER |
|
|
|
| SUPPORT FOR PFX CERTIFICATES AND OTHER CRYPTOGRAPHIC ENHANCEMENTS |
|
|
|
| MS-TDS 8.0 PROTOCOL AND TLS 1.3 |
|
|
|
| AZURE-ENABLED | |||
| LINK TO AZURE SQL MANAGED INSTANCE – REPLICAS |
|
|
|
| LINK TO AZURE SQL MANAGED INSTANCE – UNIDIRECTIONAL |
|
|
|
| LINK TO AZURE SQL MANAGED INSTANCE – BIDIRECTIONAL[6] |
|
|
|
| OPTIMIZED VIRTUAL MACHINE (VM) IMAGES IN AZURE GALLERY |
|
|
|
| FREE ASYNCHRONOUS REPLICATION ON AZURE VIRTUAL MACHINES FOR DISASTER RECOVERY |
|
|
|
| MICROSOFT DEFENDER FOR SQL |
|
|
|
| AZURE PURVIEW CENTRAL GOVERNANCE |
|
|
|
| AZURE PURVIEW DATA OWNER POLICIES |
|
|
|
| MICROSOFT ENTRA ID (FORMERLY AZURE AD) AUTHENTICATION |
|
|
|
| AZURE SYNAPSE LINK FOR SQL |
|
|
|
| MANAGEMENT AND PROGRAMMABILITY | |||
| LINUX SUPPORT |
|
|
|
| CONTAINER SUPPORT |
|
|
|
| KUBERNETES SUPPORT |
|
|
|
| TEMPORAL TABLES |
|
|
|
| JSON SUPPORT |
|
|
|
| GRAPH DATA SUPPORT |
|
|
|
| UTF 8 SUPPORT |
|
|
|
| JAVA SUPPORT |
|
|
|
| AZURE DATA STUDIO TO MANAGE SQL SERVER INCLUDING SUPPORT FOR T-SQL USING NOTEBOOKS |
|
|
|
| DATABASE COMPATIBILITY CERTIFICATION |
|
|
|
| BIT MANIPULATION FUNCTIONS |
|
|
|
| TIME SERIES SUPPORT |
|
|
|
| BI AND ANALYTICS SUPPORT | |||
| INTEGRATION SERVICES MANAGED AS A SERVER |
|
|
|
| TABULAR BI SEMANTIC MODEL[5] |
|
|
|
| MASTER DATA SERVICES[5] |
|
|
|
| DATA QUALITY SERVICES[5] |
|
|
|
| MANY-TO-MANY RELATIONSHIPS IN TABULAR MODELS |
|
|
|
| END-TO-END MOBILE BI ON ANY DEVICE |
|
|
|
| SQL SERVER ANALYSIS SERVICES (SSAS) DIRECT QUERY |
|
|
|
| CALCULATION GROUPS IN TABULAR MODEL |
|
|
|
- [1] For HDFS and Azure Blob Storage only(For SQL Server 2017, SQL Server 2016 only).
- [2] For tail of the log only (For SQL Server 2017, SQL Server 2016 only).
- [3] See full list Intelligent Query Processing updates by release.
- [4] See additional SQL Server 2022 secure enclaves updates.
- [5] SQL Server Enterprise edition only.
- [6] The bidirectional disaster recovery capability of the Link feature for Azure SQL Managed Instance is available in limited public preview. Sign up for early access. General availability will occur at a future date.
- [7] Feature requires connection to Azure Arc agent.
NOTE: See the list of SQL Server 2022 features.
Related products
