Thursday, May 30, 2024

SQL Server 2022: Microsoft is fully committed to the cloud


SQL Server 2022 is here: Microsoft has released the latest version of its relational database management system (RDBMS). The most important new features are the links to Azure. Among other things, the local instance can now be linked to the one in the cloud and replicated there, which is mainly intended to ensure operation and recovery after failure.

Additionally, data from SQL Server 2022 can be used directly in Azure Synapse. With the latter, users can, among other things, analyze large amounts of information and relate it to other sources, and with the new link between the cloud and the local database server, this should happen in real time without interruption. The software only transfers data that is new or has changed since the last upload.

In addition, Microsoft is integrating its Purview data monitoring service: customers can automatically and free of charge scan their local installation to extract SQL server metadata. This information can then be classified and labeled appropriately. Last but not least, users should keep an eye on company information marked as confidential through Purview in its database.

In addition, there’s the connection to Azure Arc, which SQL Server 2022 now configures by default during first setup. Administrators should be able to have a central view of all SQL servers and their status, regardless of their location. Microsoft also wants to give managers advice on how to optimize their databases, which, in addition to system performance and scalability, also includes security settings.

In the future, Microsoft Defender from the cloud will also take care of protecting local installations. The software can now obtain user identities from Azure Active Directory, and support for single sign-on is also new.

By linking to Azure Arc, Microsoft is also introducing a new payment option. It is intended for customers who only use their SQL Server at peak times, virtualize it themselves, or generally prefer flexible billing. With Pay As You Go (PAYG), users only pay per hour used, even with an on-premises system. This works with the standard and enterprise editions, there is no need to deposit a license key.

But there are also some changes under the hood in SQL Server 2022: among other things, developers want to have improved performance without requiring users to make code changes. There are details about this in the Microsoft Cloud blog announcement.

More from iX Magazine

More from iX Magazine

More from iX Magazine


To the home page

Ebenezer Robbins
Ebenezer Robbins
Introvert. Beer guru. Communicator. Travel fanatic. Web advocate. Certified alcohol geek. Tv buff. Subtly charming internet aficionado.

Share post:


More like this

The Future Of Horse Racing In The Digital Age  

Horse racing, a sport steeped in tradition and history,...

How to Sell CS:GO Skins for Real Money

CS:GO skins have become not just an ordinary design...

Decoding The Diversity: A Guide To Different Types Of Horse Races

Horse racing reaches 585 million households worldwide, enjoying immense...

Maximizing Efficiency: How Our Cloud Services Revolutionized Operations for Small Businesses

Small businesses constantly seek innovative solutions to streamline operations...