Wednesday, November 30, 2022
HomeMicrosoftMicrosoft releases SQL Server 2022 and simplifies hybrid scenarios

Microsoft releases SQL Server 2022 and simplifies hybrid scenarios

Not so long ago, a release of a new version of SQL Server would have been celebrated with great fanfare, with partner and customer parties, press tours and hype. But – like Windows Server – times have changed. SQL Server 2022 was released last week by Microsoft without fanfare or trumpet. Admittedly, the Microsoft DBMS remains one of the most present in companies. But the future lies in databases managed as services in the cloud. Furthermore, migration and expansion to the cloud is at the core of this 2022 edition…

SQL Server was born over 30 years ago. But it was with the 2000 version that the database (which already introduced a lot of self-management mechanisms) really became popular in enterprises, making it one of Oracle’s main competitors and the star database in the Windows Server universe (but SQL Server also exists in Linux version since 2016).

The arrival of this 2022 version is first and foremost a form of recognition that not all applications and their bases end up in the cloud. For reasons of compliance, comfort and financial balance, some bases will remain “On-Premises” for a long time to come. Nevertheless, even with an “in-house” database, it can be useful to seek services in the cloud, whether to extend analytical capabilities or to achieve robustness.

This is the whole spirit of this 2022 edition, which wants to be a full member of what Microsoft calls its “Intelligent Data Platform”. In other words, SQL Server 2022 wants to simplify hybrid scenarios by relying especially on Azure Arc, Azure SQL Managed Instance, Azure Synapse Analytics, Purview, Azure AD, Microsoft Defender.

But before we return to these links with Azure and the clouds, it should also be noted that Microsoft has also worked on the basic functions of SQL Server to enrich its functionalities. As always, performance has been focused on to allow SQL Server to remain the fastest base in terms of OLTP performance (TPC-E) and in terms of non-clustered Datawarehouse (according to the TPC ranking). Thus, the 2022 version embeds new optimizations of its “Intelligent Processing Query”, such as makes it possible to optimize execution plans according to the parameters as well as intelligently control the degree of parallelism (the database checks whether embedding more cores in the execution of a query really speeds it up or not).

But the most important addition of the 2022 edition is the appearance of a “Ledger” mode (born in the Azure SQL universe), which allows the database to be used as a registry with a history of the changes of data over time. Which provides many advantages of blockchains without their complexity.

Back to the cloud. The figure below illustrates the hybrid scenarios that the publisher has focused on for this 2022 edition. The idea is essentially to leverage Azure’s key services without migrating to the cloud.

SQL Server 2022 - Simplified hybrid scenarios

Function” Link to Azure SQL Managed Instance allows you to link an internal database to a managed instance in the cloud to ensure disaster recovery. ” The cloud instance is ready to go when you need it, without the need for extensive setup or maintenance says Rohan Kumar, VP Azure Data at Microsoft. A cloud instance that can also be used for reading to relieve the internal infrastructure of the heaviest requests that can normally affect the performance of the production database.

Another key news ” Azure Synapse Link for SQL » makes it possible to use the internal data stored in SQL Server 2022 directly in Azure Synapse without going through an ETL phase. Any changes in SQL Server 2022 are automatically streamed to Azure Synapse and are therefore available in near real-time for advanced analysis. ” Once the data arrives in Synapse, you can combine it with many different data sources, regardless of size, scale or format, and run powerful analytics on all that data using ‘Azure Machine Learning, Spark or Power BI’ explains Rohan Kumar.

Similarly, SQL Server 2022 now integrates natively with Microsoft Purview, the publisher’s cloud service for data management. Purview can thus automatically scan (without add-ons) SQL Server 2022 databases to capture metadata, classify local data using Purview’s AI, implement controls and access rights in SQL Server 2022.

Other new features include the ability to use Azure Active Directory to control access to SQL Server 2022 databases and data, the ability to monitor and protect internal databases (or hosted in GCP or AWS) with Microsoft Defender and of course to manage the internal databases directly from the interface Azure bow to manage cloud databases and on-site databases from a single interface.

Finally, the last news and not least, Microsoft inaugurates with SQL Server 2022 a new pay-as-you-go billing model (by paying per hour consumed), provided the database is attached to Azure Arc.

Finally, it should be noted that this release of SQL Server 2022 is of course accompanied by the free versions “SQL Server 2022 Developer” and “SQL server 2022 Express”. SQL Server 2022 is available on Windows, on Linux, as a Docker image, and as a VM in Azure.

Compare SQL Server 2022 with the 2019 and 2016 editions:
SQL Server 2022—Comparison | Microsoft

Also read:



Please enter your comment!
Please enter your name here

Most Popular

Recent Comments