Microsoft right this moment launched SQL Server 2022, the most recent 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 information 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 staff began fairly a couple of years in the past.
“From the very starting, the imaginative and prescient [for SQL Server] actually was about — databases have been very complicated — how do you make that very simple? And in some ways, I feel that has been a key cause why it lasted for thus lengthy and the way we’ve developed it as nicely,” Ran Kumar, Microsoft’s company VP for Azure Knowledge, advised me. “One of many massive issues that I take into consideration with SQL Server 2022 is that we’ve made it utterly 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 totally different speeds and a few, for a mess of causes, might 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 a number of prospects began asking about how they might get the worth of being within the cloud with out really having to maneuver all of their information to it. “That was actually the important thing thesis of why we invested in making this right into a cloud launch,” Kumar mentioned.
A superb instance right here is the brand new catastrophe restoration perform that enables customers to copy their information in SQL Managed Occasion on Azure and use that as a backup for his or her important 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 fancy infrastructure. “All you should do is test a field and say: ‘replicate this information in close to actual time.’ It lands it into Synapse and you’ll have your Energy BI report that’s studying that information and that complete pipeline is simply constructed for you,” he mentioned.
And for corporations that do certainly have a hybrid setup, assist for the Purview information governance service now allows them to set their insurance policies, regardless of whether or not the info resides in SQL Server within the cloud or on premises.
Along with the work on the brand new cloud-connected capabilities, the staff additionally, after all, labored on enhancing the database’s total efficiency, stability and safety posture. On the core of that work, no less than for this launch, was the database’s clever question processing engine, which might now optimize queries in various extra complicated situations, for instance.
Additionally fascinating 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 sources. 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 instances.
As Kumar famous, SQL Server utilization, regardless of the entire competitors obtainable right this moment, continues to develop (although partially, 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.