The tech giant has claimed that this is “the most Azure-enabled version of SQL Server” since the software was first unveiled in 1989, and this will also be the software’s first significant update in three years.
The new solutions are part of the Microsoft Intelligent Data Platform, a cloud platform launched in May 2022 that looks forward to full integration of databases, analytics, and data management.
Microsoft SQL Server 2022 Update
Microsoft says SQL Server 2022 will bring improved integration with many different types Microsoft Azure Services, such as the Azure Synapse Link data analytics platform as well as the data governance solution Microsoft Purview.
These will “make it easier for customers to get deeper insights, predictions, and governance from their data at scale,” according to the company.
In addition, the company claims that enhanced Azure integration also includes managed disaster recovery (DR) to Azure SQL Managed Instance, along with “near-real-time analytics.” These features, she says, will allow database administrators to manage their datasets with greater flexibility and the least possible impact on end users.
The update also appears to include a simple connection to the Azure Arc Agent, as part of the default SQL Server 2022 setup process.
Microsoft says this will enable additional capabilities, such as a single view of all SQL servers deployed on-premises, in Azure, and other clouds as well as protecting on-premises data with Microsoft Defender for Cloud.
In addition, it is clear that the integration with Azure Arc will also include support for Microsoft Single Sign-On, which is the company’s secure Identity management softwareand Azure Active Directory, plus pay-as-you-go billing.
Users can leave feedback about the new software by going to Microsoft SQL Server Notes Entrance (Opens in a new tab). They are also able to increase their knowledge through Microsoft Learn SQL Server 2022 Modules (Opens in a new tab) and the SQL Server 2022 Workshop. (Opens in a new tab)