Microsoft has just officially launched the latest version of its internal database software. The central feature of the SQL Server 2022 release is of course the optimization of the group’s cloud platform, Azure.
The tech giant says it’s the most “Azure-compatible” version of SQL Server since the software was first unveiled in 1989, and it’s also the first update. Important day for the software in three years.
With connections to Azure Synapse Link for real-time analysis from the database, Azure Purview for data management and disaster recovery using Azure SQL Managed Instance, this release is in many ways the culmination of the substantive work with the connections to clouds that the development team started a few years ago.
“From the start, the vision for SQL Server was really to make databases much simpler – because they were so complex? And I think that in many ways was one of the main reasons why we were able to continue development for so long.” said Rohan Kumar, Azure Data team lead at Microsoft. “One of the biggest things that comes to mind about SQL Server 2022 is that we’ve fully integrated it into the cloud with Azure“.
However, Kumar also pointed that out developers still take a hybrid approach. In fact, they are fully aware that customers are discovering clouds at different speeds and that some will probably never change. After all, there are good reasons not to leave certain data to another company and store it on its own infrastructure. This is still possible, although the news mainly revolves around the integration of Azure.
A very useful new feature
One of the main new features is the new disaster recovery function, which reflects the hybrid approach of both variants: customers can replicate their data to a managed SQL instance on Azure and use it as a backup for their on-premises primary SQL server. If the main server fails, the redundancy system i clouds can take over in a very short time.
For companies that still have a hybrid setup, Purview’s data management service support now allows setting policies on whether the data is stored in SQL Server in clouds or on site. In addition, according to the information provided, the developers have of course also worked on the general performance, stability and security of the database. The new version of SQL Server is now generally available, including free Developer and Express editions.
Users can provide feedback about the new software by visiting Microsoft’s SQL Server Feedback Portal. They can also deepen their knowledge with the Microsoft Learn SQL Server 2022 module and the SQL Server 2022 workshop.