Microsoft Releases Azure-Enabled SQL Server 2022
Microsoft has just announced the release of its SQL Server 2022, an Azure-enabled operational database, deigned to offer differentiated performance, protect data from tampering by malicious actors as well as automate the last-writer wins rule – to help avoid multi-write scenarios.
As announced, the SQL Server 2022 integrates with Azure Synapse Link – to help provide near real-time analysis and hybrid transactional and analytical processing, as well as Azure Purview – to enable customers drive deeper insights, predictions, and governance from their data at scale.
“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,” said Peter Carlin, CVP, Azure Database Services.
Through the integration of the SQL Server 2022 with Azure Purview, customers are expected to enjoy various capabilities including automatic scanning of on-premises SQL Server for free to capture metadata, set up and control specific access rights to SQL Server as well as classify data using built-in and custom classifiers and Microsoft Information Protection sensitivity labels.
“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,” continued Peter Carlin.
According to Microsoft, the SQL Server 2022 is presently available in preview, but at this point in time, it is only available to a limited number of customers and partners, however, customers can now apply for the SQL Server in advance of public preview and general availability in the coming year.