In this article, we will be discussing about what’s new in SQL Server 2019, in terms of new features and enhancements.
In September 2018, during the MS Ignite Conference, Microsoft announced the Community Technology Preview of SQL Server 2019 (CTP 2.0). This is an exciting new version with a plethora of new features, as well as with enhancements to existing features. Read this article, in order to learn what’s new in SQL Server 2019 (currently CTP 2.0).
Installing SQL Server 2019
Prior to talk about the new features in SQL Server 2019, let’s talk a bit about how you can install it. I have prepared a short presentation, which illustrates a simple installation of SQL Server 2019 CTP 2.0 on my local machine.
Note that this is a simple installation, performed for demo purposes. Therefore, since I have installed everything on local C drive (never do that on Production environments), I have not taken into consideration any performance or scalability considerations.
You can check out the relevant presentation below.
What’s New in SQL Server 2019
In this article, we will talk for some of these features along with providing some screenshots. We will structure our discussion based on three areas of SQL Server 2019:
Intelligent query processing in SQL Server, is a family of features that improve the performance of existing workloads with minimal implementation effort. Currently, up to the CTP 2.0 release of SQL Server 2019, the following features are supported:
Clustered columnstore online index build and rebuild
In SQL Server 2019, you can build and rebuild clustered columnstore indexes. This is very useful, especially in Data Warehouse environments, where columnstore indexes are heavily used.
Resumable online index create
With this feature, an index create operation, can be resumed after interruption.
sp_estimate_data_compression_savings
New options added in order to support colunstore indexes.
This is a new security feature that provides additional functionality to the the existing “Always Encrypted” feature. This feature, addresses previous limitations, by allowing computations on plaintext data inside a secure enclave on the server side.
Data discovery and classification is natively built into SQL Server, and allows you to classify columns in your database that contain sensitive information. This is extremely useful for Compliance scenarios that have to do with data security.
Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!
Lifetime Access / Live Demos / Downloadable Resources and more!
Enhanced database level health detection for Availability Group databases
The above functionality has been enhanced in order to detect additional error conditions and -if required- to initiate a failover or restart of the involved availability group resource.
Up to five synchronous replica pairs
SQL Server 2019 supports up to 5 synchronous replica pairs (1 primary- 4 secondary). In SQL Server 2017 the limit was set to 3 synchronous replica pairs.
Secondary replica connection redirection in Always On Availability Groups
The secondary replica connection redirection, allows redirecting connections to be redirected to the primary replica, regardless of the target server specified in the connection string. This redirection can be achieved without the use of a listener, and it is suitable for such cases.
UTF-8 support in SQL Server 2019, is another amazing feature. The basic idea is that when you use a collation ending in _UTF8, along with the datatypes CHAR and VARCHAR, you can store, import and export data in unicode, without needed to use the NCHAR and NVARCHAR data types. This allows for significant storage savings.
An example of using UTF-8
See the below example, where I have created a UTF-8 enabled database and table, inserted and then successfully retrieved records with Greek characters, by using VARCHAR columns instead of NVARCHAR.
By using this extension (currently in preview), you can execute Java code in SQL Server. This feature is related to the Machine Learning Services (In-Database) feature. It gets installed when you installed the Machine Learning Services feature.
SQL Server on Linux
There are many new features regarding SQL Server on Linux. Among other, SQL Server 2019 on Linux now supports:
SQL Server replication.
Microsoft Distributed Transaction Coordinator service (MSDTC).
Machine-Learning Services (In-Database)
Improved integration between SQL Server on Linux and Active directory, via the OpenLDAP support for third-party AD providers.
Many new features and enhancements are also introduced, regarding Big Data.
The major enhancement in the area of Big Data, is the ability to create Big Data clusters, combining multiple instances of SQL Server along with Apache Spark and Hadoop Distributed File System.
Other significant new features and enhancements in SQL Server 2019 (CTP 2.0), include: SQL Graph features, new PolyBase connectors, SQL Server Machine Learning Services failover clusters, and much more.
Moreover, SQL Server 2019, introduces the “Transparent Data Encryption (TDE) Scan – Suspend and Resume” option. Learn more about it in the below video.
Watch a Preview of our Online Course on SQL Server 2019
In the below video, you can watch a short preview of my online course: “SQL Server 2019: What’s New (New and Enhanced Features)“.
Artemakis Artemiou is a seasoned Senior Database and AI/Automation Architect with over 20 years of expertise in the IT industry. As a Certified Database, Cloud, and AI professional, he has been recognized as a thought leader, earning the prestigious Microsoft Data Platform MVP title for nine consecutive years (2009-2018). Driven by a passion for simplifying complex topics, Artemakis shares his expertise through articles, online courses, and speaking engagements. He empowers professionals around the globe to excel in Databases, Cloud, AI, Automation, and Software Development. Committed to innovation and education, Artemakis strives to make technology accessible and impactful for everyone.
Views:7,846
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent. Read More
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
Cookie
Duration
Description
cookielawinfo-checkbox-analytics
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional
11 months
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy
11 months
The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Loading...