Microsoft SQL Server 2022 | 5.8 GbThe Microsoft development team is pleased to announce the availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability. This marks the latest milestone in the more than 30-year history of SQL Server. SQL Server 2022 new features Let’s take a closer look at the editions of SQL Server 2022 and their new features.
Parameter Sensitive Plan Optimization
This is a new intelligent query processing enhancement that’s designed to improve the performance of existing workloads without changes to the application code. Previously, SQL Server cached a single plan per each stored procedure. This was based on a set of parameters and it was called parameter sniffing.
However, some parameterized queries are sensitive to the input parameter values that are used. And the generated plan was not optimal for all possible values those parameters can take. The new Parameter Sensitive Plan Optimization caches multiple active execution plans in the plan cache for a single parameterized query.
These cached execution plans will accommodate different data sizes based on the provided runtime parameter values. To enable PSP optimization, you need to set the database compatibility level to 160 for the database you are using.
Query Store enhancements
The Query Store is a performance feature that helps you better track performance history and troubleshoot query plan and performance issues. In previous releases, you had to manually enable the Query Store. With SQL Server 2022, the Query Store will now be enabled by default for new databases providing improved query intelligence and insight.
Query Store will also now be supported on Availability Group read-only replicas providing better performance analytics for your read-only workloads. You will also be able to use Query Store hints to shape query plans and enhance query execution without changing application code. Previously, Query Store hints were only available on Azure SQL Database and Azure SQL Managed Instance.
Link to Azure SQL Managed Instance
Like you might guess, Link to Azure SQL Managed Instance is a hybrid cloud feature that is designed to enhance availability. It provides near real-time data replication between SQL Server 2022 and the link feature in Azure SQL Managed Instance. It enables you to shift workloads to read-only secondaries on Azure, allowing you to take advantage of cloud performance and scale for those workloads. SQL Server 2022 – Azure SQL Managed Instance
You can also use it to migrate databases with minimum downtime. The Link to Azure Managed Instance is also supported with SQL Server 2019 Enterprise and Developer edition, and SQL Server 2016 Enterprise, Developer, and Standard editions.
This feature is based on the technology from distributed availability groups. However, it does not require the involved setup and configuration of availability groups. Currently, the replication of user databases from SQL Server to Azure SQL Managed Instance is one-way. And it can only be used with user databases.
User databases from SQL Managed Instance can’t be replicated back to SQL Server, although you can restore a migrated database back to SQL Server 2022 on-premise. Microsoft has stated that the general availability of the bidirectional disaster recovery (DR) failover capability of the Link feature for Azure SQL Managed Instance will be released after the general availability of SQL Server 2022.
Contained Availability Groups
Another availability feature, Contained Availability Groups addresses the limitations found in the previous versions of Availability Groups (AGs). AGs consist of one or more user databases intended to operate as a coordinated group where they are replicated to different nodes in a cluster. When there is a failure in the node that hosts the primary copy, the databases in the AG are moved as a unit to another replica node in the AG.
Previous version of AGs did not include other objects like users, logins, and permissions. This required the administrator to manually make sure that these objects are duplicated across all replica instances in the AG.
Contained availability groups extend the concept of the group of databases being replicated to include relevant portions of the master and msdb databases. The contained AG environment includes settings that would affect the application. Relying on them like users, logins, permissions, and SQL Agent jobs at the AG level using specialized contained system databases within the availability group.
Like the user databases, these objects will automatically be consistent across replicas in the AG. This eliminates the need for the administrator to manually make, create, and update these objects manually across the different AG replicas.
Azure Synapse Link for SQL
Azure Synapse Link for SQL is a new analytics feature that provides ETL-free (extract, transform, load) near real time analysis and reporting for SQL Server relational data. It captures the changes to databases in SQL Server 2022 and feeds them to Azure Synapse Analytics for real time analysis. There is seamless integration between SQL Server 2022 relational databases and Azure Synapse Analytics dedicated SQL pools. SQL Server 2022 new features powered by Azure
It works by continuously replicating the data from Azure SQL Database or SQL Server 2022 to Azure Synapse Analytics. This integration enables you to run analytics, business intelligence, and machine learning scenarios on your operational data with minimal impact on source databases. And without requiring any ETL processes.
SQL Server 2022’s Multi-Write Replication automates the last-writer wins rule for replication conflict resolution. With earlier versions of SQL Server, when a conflict arose between data that was written to different replicas, the conflict would need to be addressed manually.
Multi-Write Replication solves this issue by implementing the last-write wins rule. If a conflict were to occur between replicas, the last write would take precedence and be written to all replicas. Multi-Write Replication uses the timestamp recorded in UTC time to avoid timezone issues.
Azure Active Directory authentication
Previous versions of SQL Server required you to use either Windows Server Active Directory (AD) or SQL Server authentication – even if you were using SQL Server in hybrid Azure environments. With SQL Server 2022, you can now use Azure AD authentication for your SQL Server 2022 connections.
Azure Purview integration
Azure Purview is a unified data governance and management service that runs in Azure. SQL Server 2022 is integrated with Microsoft Purview for greater data discovery, allowing you to break down data silos and to provide policy management for access control. Purview can classify data using built-in and custom classifiers, as well as Microsoft Information Protection sensitivity labels.
SQL Server Ledger
SQL Ledger is another feature that was first introduced on Azure SQL database then later passed on to SQL Server 2022. SQL Ledger uses blockchain to verify changes made to your databases. It enables to you maintain an immutable record of the data, cryptographically linking the data and their changes in a blockchain structure. It shows any data tampering and makes the data verifiable. SQL Server 2022 Ledger overview
Ledger can help customers streamline audits, providing cryptographic proof of data integrity to auditors and eliminating the need for manual forensics. Ledger also helps protect data from any attacker or high-privileged user, including database administrators (DBAs), system administrators, and cloud administrators.
If a row is updated in the database, its previous value is maintained and protected in a history table. Ledger provides a history of all changes made to the database over time.
AWS S3 storage integration
SQL Server 2022 provides new object storage integration, enabling you to integrate SQL Server with AWS S3 compatible object storage in addition to Azure Storage. A new S3 connector has been added to SQL Server. It uses the S3 REST API to connect to any provider of S3-compatible object storage.
SQL Server 2022 extends the existing BACKUP/RESTORE TO/FROM URL syntax by adding support for the new S3 connector using the REST API. There are a number of cloud vendors providing S3 storage including Amazon, Cloudian, Dell, Hitachi, HPE, Netapp, Nutanix, Pure Storage, Red Hat, and more.SQL Server is Microsoft’s premier enterprise database platform. But in today’s world of rapid-fire releases and continuous updates, the new SQL Server 2022 release seems like it has been a long time in coming. But it includes some great new features. SQL Server 2019 was the last major release of SQL Server. With every release, Microsoft continues to optimize the core SQL Server engine. Today, most SQL Server innovations start off in the Azure cloud and then make their way to the on-premises editions of SQL Server. What's new in SQL Server 2022 A first look at SQL Server 2022—the latest Azure-enabled database and data integration innovations. See what it means for your hybrid workloads, including first-time bi-directional high availability and disaster recovery between Azure SQL Managed Instance and SQL Server, Azure Synapse Link integration with SQL for ETL free near real-time reporting and analytics over your operational data, and new next-generation built-in query intelligence with parameter sensitive plan optimization. Bob Ward, SQL engineering leader, joins Jeremy Chapman to share the focus on this round of updates.Microsoft Corporation, leading developer of personal-computer software systems and applications. The company also publishes books and multimedia titles, offers e-mail services, and sells electronic game systems, computer peripherals (input/output devices), and portable media players. It has sales offices throughout the world. Product: Microsoft SQL ServerVersion: 2022 (16.0.1000.6) *Supported Architectures: x64Website Home Page : www.microsoft.comLanguages Supported: englishSystem Requirements: Windows **Size: 5.8 Gb * included:
SQL Server 2022 EditionsSQL Server 2022 will continue to follow the same editions of SQL Server as the previous few releases of SQL Server.
Enterprise – Designed for the high-end datacenter, the Enterprise edition delivers the highest levels of performance and scalability for mission-critical workloads. It supports the operating system maximums for CPUs and RAM. There is full support for eight node Availability Groups.
Standard – Standard edition provides basic data management for departments and small organizations. It is limited to a lesser of 4 sockets or 24 cores and 128 GB of RAM. It provides support for two node Basic Availability Groups.
Web – Intended for Web hosting providers, the Web edition provides scalability, affordability, and manageability for small to large scale web properties. It is limited to a lesser of 4 sockets or 16 cores and 64 GB or RAM.
Developer – Designed to enable developers build applications using SQL Server as the backend database. It includes all the functionality of Enterprise edition but it is licensed for use only as a development and test system. It cannot be used for production workloads.
Express – An entry-level, free database, the Express edition is intended to be used as a learning tool. And for building desktop and small server applications. It is limited to a lesser of 1 socket or 4 cores, 1410 MB of RAM, and it has a maximum database size of 10 GB.
SW_DVD9_NTRL_SQL_Svr_Ent_Core_2022_64Bit_English_OEM_VL_X23-28404.ISO ** System Requirements:
Microsoft SQL Server 2022 x64