{"id":38283,"date":"2021-11-02T08:00:00","date_gmt":"2021-11-02T15:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=38283"},"modified":"2024-04-19T10:49:29","modified_gmt":"2024-04-19T17:49:29","slug":"announcing-sql-server-2022-preview-azure-enabled-with-continued-performance-and-security-innovation","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2021\/11\/02\/announcing-sql-server-2022-preview-azure-enabled-with-continued-performance-and-security-innovation\/","title":{"rendered":"Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovation"},"content":{"rendered":"

Today we are announcing the preview of SQL Server 2022<\/a>, the most Azure-enabled release of SQL Server yet, with continued innovation in performance, security, and availability.<\/p>\n

The rise of data represents a tremendous opportunity and also poses challenges. Companies are seeing their relational and nonrelational data proliferate exponentially on-premises, in the cloud, at the edge, and in hybrid environments. The most transformative companies drive predictive insights on current data, whereas others may struggle to drive even reactive insights to their historical data. Information may be siloed across geographies and divisions.<\/p>\n

To empower customers amid this environment, Microsoft offers an end-to-end data platform<\/a> of products and services that come together to meet these challenges. Operational databases cover all possible deployment locations, including SQL Server and Azure Arc-enabled data services, Azure SQL fully-managed cloud databases, and Azure SQL Edge for IoT devices. To enable real-time insights, Azure Synapse Analytics brings together data integration, enterprise data warehousing, and big data analytics, and customers can visualize their data with Power BI. Customers can discover, catalog, and govern their data wherever it resides with Azure Purview.<\/p>\n

SQL Server 2022 integrates with Azure Synapse Link and Azure Purview to enable customers to drive deeper insights, predictions, and governance from their data at scale. Cloud integration is enhanced with disaster recovery (DR) to Azure SQL Managed Instance, along with no-ETL (extract, transform, and load) connections to cloud analytics, which allow database administrators to manage their data estates with greater flexibility and minimal impact to the end-user. Performance and scalability are automatically enhanced via built-in query intelligence. There is choice and flexibility across languages and platforms, including Linux, Windows, and Kubernetes.<\/p>\n

\"SQL<\/p>\n

Azure-enabled<\/h2>\n

Bi-directional HA\/DR to Azure SQL<\/h4>\n

To ensure uptime, SQL Server 2022 is fully integrated with the new link feature in Azure SQL Managed Instance. With the new link feature for Azure SQL Managed Instance, you now get all the benefits of running 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 is required. You can also use this link feature in read scale-out scenarios to offload heavy requests that might otherwise affect database performance. And we are working on building out more capabilities to support bi-directional data movement.<\/p>\n

Azure Synapse Link<\/h4>\n

Previously, moving data from on-premises databases, like SQL Server, to Synapse required you to use ETL. As we all know, setting up and running an ETL pipeline takes a lot of work, and insights lag behind what is happening at any moment. Azure Synapse Link for SQL Server 2022 provides automatic change feeds that capture the changes within SQL Server and feed those into Azure Synapse Analytics. It provides near real-time analysis and hybrid transactional and analytical processing with minimal impact on operational systems. Once the data hits 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. Since the automated change feeds only push what is new or different, data transfer happens much faster and now allows for near real-time insights, with minimal impact on the performance of the source database in SQL Server 2022.<\/p>\n

Azure Purview integration<\/h4>\n

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