Microsoft’s SQL Server 2022 is all about Azure • TechCrunch

Microsoft in the present day launched SQL Server 2022, the newest model of its database software program, which initially launched greater than 33 years in the past. Microsoft describes this launch because the “most Azure-enabled launch of SQL Server but” and with connections to Azure Synapse Hyperlink for enabling real-time analytics over the database, Azure Purview for knowledge governance and catastrophe restoration with the assistance of Azure SQL Managed Occasion, this launch is, in some ways, the end result of the cloud-connection groundwork the group began fairly a number of years in the past.

“From the very starting, the imaginative and prescient [for SQL Server] actually was about — databases had been very complicated — how do you make that very simple? And in some ways, I feel that has been a key purpose why it lasted for thus lengthy and the way we’ve developed it as effectively,” Ran Kumar, Microsoft’s company VP for Azure Knowledge, instructed me. “One of many huge issues that I take into consideration with SQL Server 2022 is that we’ve made it fully cloud-connected to Azure.”

He famous that whereas the migration of on-prem workloads is going on, Microsoft’s prospects are all transferring at very completely different speeds and a few, for a mess of causes, could by no means transfer to the cloud in any respect. That, he argues, is why the corporate all the time guess on a hybrid method, however it is usually why lots of prospects began asking about how they may get the worth of being within the cloud with out truly having to maneuver all of their knowledge to it. “That was actually the important thing thesis of why we invested in making this right into a cloud launch,” Kumar mentioned.

An excellent instance right here is the brand new catastrophe restoration perform that enables customers to duplicate their knowledge in SQL Managed Occasion on Azure and use that as a backup for his or her principal on-premises SQL Server, which ought to make it straightforward to fail over to that when the principle server goes down.

Kumar additionally famous that with Synapse Hyperlink, SQL Server customers can now run real-time analytics over their database with out having to arrange a posh infrastructure. “All you should do is verify a field and say: ‘replicate this knowledge in close to actual time.’ It lands it into Synapse and you’ll have your Energy BI report that’s studying that knowledge and that entire pipeline is simply constructed for you,” he mentioned.

And for firms that do certainly have a hybrid setup, assist for the Purview knowledge governance service now allows them to set their insurance policies, irrespective of whether or not the information resides in SQL Server within the cloud or on premises.

Along with the work on the brand new cloud-connected capabilities, the group additionally, in fact, labored on bettering the database’s general efficiency, stability and safety posture. On the core of that work, a minimum of for this launch, was the database’s clever question processing engine, which may now optimize queries in a lot of extra complicated eventualities, for instance.

Additionally attention-grabbing is a brand new pay-as-you-go billing mannequin for SQL server via Azure Arc, Microsoft’s platform for managing cloud and on-premises assets. Utilizing a connection to Azure Arc, which is a part of the SQL Server 2022 setup course of, on-premises customers can now additionally go for cloud-enabled billing to handle consumption spikes or for advert hoc use circumstances.

As Kumar famous, SQL Server utilization, regardless of the entire competitors obtainable in the present day, continues to develop (although partly, that’s pushed by present prospects increasing their utilization).

The brand new version of SQL Server is now usually obtainable, together with the free Developer and Categorical editions.