{"id":49068,"date":"2022-11-29T00:00:00","date_gmt":"2022-11-28T23:00:00","guid":{"rendered":"https:\/\/jotelulu.com\/blog\/review-of-sql-server-2022-compared-with-previous-versions\/"},"modified":"2022-11-29T00:00:00","modified_gmt":"2022-11-28T23:00:00","slug":"review-sql-server-2022","status":"publish","type":"post","link":"https:\/\/jotelulu.com\/en-gb\/blog\/review-sql-server-2022\/","title":{"rendered":"Review of SQL Server 2022 Compared with Previous Versions"},"content":{"rendered":"

In this short article, we’ll take a look at the latest version of SQL Server <\/strong>and compare it to previous versions of Microsoft’s DBMS.<\/p>\n

A few months ago, we carried out a little technical review of the SQL Server 2022 Release Candidate (RC) based on the information provided by Microsoft at the Ignite conference and some tests that we performed ourselves.<\/p>\n

Then, just over a week ago, on 16 November 2022<\/strong>, Microsoft released the final version <\/strong>and we thought that it would be a good idea to analyse the real differences between this version and previous releases, not just the RC but versions released in previous years.<\/p>\n

To do this, we’re going to review some of the main features <\/strong>and compare them with the 2019 and 2017 versions <\/strong>as these are the versions that still receive Microsoft support.<\/p>\n

As usual, Microsoft appears to have focused on enhancing existing features<\/strong>, boosting working capacity<\/strong>, increasing computing power<\/strong> and improving security<\/strong>, as well as increasing its usage capabilities with Azure<\/strong>.<\/p>\n

So, let’s get down to business and see what’s changed!<\/p>\n

 <\/p>\n

What Editions of SQL Server 2022 Are Available?<\/strong><\/h2>\n

First off, it appears that absolutely no changes have been made to the different editions of SQL Server that are available. The same editions that were available previously are also available for SQL Server 2022.<\/p>\n