![]() SQL Server 2019 included the following improvements: Support for graph capabilities to model relationships.Automatic plan correction for performance tuning. ![]() Adaptive and intelligent query processing.Support for containers on GNU/Linux and Windows containers.Support for different GNU/Linux distros, like SLES (SUSE Enterprise Linux), RHEL (Red Hay Enterprise Linux) or Ubuntu Linux.SQL Server 2017 included the following improvements: However, it’s important to note that around 20% of these new features rely entirely on Microsoft Azure. If we look at the number of new features added with each release, we can see that this latest version features almost double the number of new features compared with previous versions, and that’s what makes this new release so exciting. Image – Evolution of Intelligent Query Processing (IQP) The table below shows a summary of the differences between the different editions of SQL Server 2022. It has the same features and functionalities as the Enterprise version, but you cannot put it into production. Developer: A version that allows you to program and test applications of all types on SQL Server.It’s useful for trials or small applications if you don’t want to pay for a licence. Standard: A less powerful version than the Enterprise edition, but it is still a first-rate solution.There are no restrictions, it offers professional performance and it can handle a higher workload than other editions. Enterprise: The premium version that includes complete features for the data centre.The same editions that were available previously are also available for SQL Server 2022. What Editions of SQL Server 2022 Are Available?įirst off, it appears that absolutely no changes have been made to the different editions of SQL Server that are available. So, let’s get down to business and see what’s changed! To do this, we’re going to review some of the main features and compare them with the 20 versions as these are the versions that still receive Microsoft support.Īs usual, Microsoft appears to have focused on enhancing existing features, boosting working capacity, increasing computing power and improving security, as well as increasing its usage capabilities with Azure. Then, just over a week ago, on 16 November 2022, Microsoft released the final version 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. In this short article, we’ll take a look at the latest version of SQL Server and compare it to previous versions of Microsoft’s DBMS.Ī 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |