Microsoft’s SQL Server 2022 is all about Azure • TechCrunch
Microsoft today released SQL Server 2022, the latest version of its database software, originally launched more than 33 years ago. Microsoft describes this release as the “most Azure-compatible version of SQL Server to date” and with connections to Azure Synapse Link to enable real-time in-database analytics, Azure Purview for data governance, and disaster recovery using Azure SQL Managed Instance. , this release is, in many ways, the culmination of groundwork on cloud connectivity that the team began a few years ago.
“From the start, the vision [for SQL Server] was really on – the databases were very complex – how to make this extremely simple? And in many ways, I think that’s one of the main reasons why it’s lasted so long and how we’ve scaled it as well,” Rohan Kumar, Microsoft vice president for Azure, told me. Data. “One of the big things I think about with SQL Server 2022 is that we’ve made it fully cloud-connected to Azure.”
He noted that during the migration of on-premises workloads, Microsoft customers all move at very different speeds and some, for a myriad of reasons, might never migrate to the cloud. This, he says, is why the company has always bet on a hybrid approach, but it’s also why many customers have started asking how they can take advantage of the cloud without having to move all their data there. . . “That was really the key thesis of why we invested in making it a cloud version,” Kumar said.
A good example here is the new disaster recovery feature which allows users to replicate their data to SQL Managed Instance on Azure and use it as a backup for their primary on-premises SQL Server, which should make failover to it easier. when the main server goes down.
Kumar also noted that with Synapse Link, SQL Server users can now run real-time analytics against their database without having to set up complex infrastructure. “All you have to do is tick a box and say, ‘replicate this data in near real time.’ It lands it in Synapse and you can have your Power BI report reading that data and that whole pipeline is just designed for you,” he said.
And for companies that do have a hybrid setup, support for the Purview data governance service now allows them to set their policies whether the data resides in SQL Server in the cloud or on-premises.
In addition to working on new cloud-connected capabilities, the team also, of course, worked on improving the overall performance, stability, and security of the database. At the heart of that work, at least for this release, was the database’s intelligent query processing engine, which can now optimize queries in a number of more complex scenarios, for example.
Also interesting is a new pay-as-you-go model for SQL Server through Azure Arc, Microsoft’s platform for managing cloud and on-premises resources. Through a connection to Azure Arc, which is part of the SQL Server 2022 setup process, on-premises users can now also opt for cloud-enabled billing to handle peak consumption or for ad-hoc use cases .
As Kumar noted, SQL Server usage, despite all the competition available today, continues to grow (although in part this is due to existing customers expanding their usage).
The new edition of SQL Server is now generally available, including free Developer and Express editions.