{"id":48885,"date":"2022-11-16T08:15:00","date_gmt":"2022-11-16T16:15:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=48885"},"modified":"2024-02-08T12:22:57","modified_gmt":"2024-02-08T20:22:57","slug":"sql-server-2022-is-now-generally-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/11\/16\/sql-server-2022-is-now-generally-available\/","title":{"rendered":"SQL Server 2022 is now generally available"},"content":{"rendered":"\n

Part of the\u202f<\/em>SQL Server 2022 blog series<\/em><\/a>.<\/p>\n\n\n\n

Today, we announced the general availability of SQL Server 2022<\/a>, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability1<\/sup>. This marks the latest milestone in the more than 30-year history of SQL Server.<\/p>\n\n\n\n

SQL Server 2022 is a core element of the Microsoft Intelligent Data Platform<\/a>. The platform seamlessly integrates operational databases, analytics, and data governance. This enables customers to adapt in real-time, add layers of intelligence to their applications, unlock fast and predictive insights, and govern their data\u2014wherever it resides.<\/p>\n\n\n

\"Image<\/figure>\n\n\n\n

<\/p>\n\n\n\n

SQL Server 2022\u2019s connections to Azure2<\/sup>, including Azure Synapse Link and Microsoft Purview make it easier for customers to drive deeper insights, predictions, and governance from their data at scale. Azure integration also includes managed disaster recovery (DR) to Azure SQL Managed Instance, along with near real-time analytics, allowing database administrators to manage their data estates with greater flexibility and minimal impact to the end user3<\/sup>.<\/p>\n\n\n\n

Performance and scalability are automatically enhanced via built-in query intelligence. Security innovation, building on SQL Server\u2019s track record as being the least vulnerable database over the last 10 years, continues with Ledger for SQL Server, which uses blockchain to create a tamper-proof track record of time of all changes to the database.<\/p>\n\n\n\n

Watch how one of our customers, Mediterranean Shipping Company, is already taking advantage of the new capabilities in SQL Server 2022.<\/p>\n\n\n

\"a<\/a><\/figure>\n\n\n\n

Azure-enabled features<\/u><\/u><\/h2>\n\n\n
\"Image<\/figure>\n\n\n\n

Link feature for Azure SQL Managed Instance<\/strong>: To ensure uptime, SQL Server 2022 is fully integrated with the new link feature in Azure SQL Managed Instance<\/a>. With this new capability, you benefit from a PaaS environment applied to disaster recovery\u2014allowing you to spend less time on setup and management even when compared to an IaaS environment. This works by using a built-in Distributed Availability Group (DAG) to replicate data to a previously deployed Azure SQL Managed Instance as a DR replica site. The instance is ready and waiting for whenever you need it\u2014no lengthy configuration or maintenance required. You can also use this link feature in read scale-out scenarios to offload heavy requests that might otherwise affect database performance. We are working on building out more capabilities to support online disaster recovery.<\/p>\n\n\n\n

Azure Synapse Link for SQL<\/strong>: Previously, moving data from on-premises databases, like SQL Server, to Synapse required you to use extract, transform, and load (ETL). Configuring and running an ETL pipeline is time-consuming, and insights often lag behind what is happening at any moment. Azure Synapse Link for SQL Server 2022 provides automatic change feeds to capture the changes within SQL Server and feed them into Azure Synapse Analytics. Synapse Link provides near real-time analysis and hybrid transactional and analytical processing with minimal impact on operational systems. Once the data comes to Synapse, you can combine it with many different data sources, regardless of their size, scale, or format, and run powerful analytics over all of it using your choice of Azure Machine learning, Spark, or Power BI. Because the automated change feeds only push what is new or different, data transfer occurs much faster and allows for near real-time insights, all with minimal impact on the performance of the source database in SQL Server 2022.<\/p>\n\n\n\n

\u201cSynapse Link for SQL Server 2022 helps us to seamlessly replicate operational data in near real-time to be able to have more powerful analytics.\u201d<\/em>\u2014Javier Villegas, IT Director for DBA and BI Service, Mediterranean Shipping Company.<\/p>\n\n\n\n

\n
\"Mediterranean<\/figure>\n<\/div>\n\n\n\n

Microsoft Purview integration<\/strong>: Microsoft Purview is a unified data governance and management service. We are excited to highlight that SQL Server is also integrated with Microsoft Purview for greater data discovery, allowing you to break down data silos. Through this integration you will be able to:<\/p>\n\n\n\n