What’s New in SQL Server 2019

What’s New in SQL Server 2019

What’s New in SQL Server 2019

A few days ago (end of 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 (CTP 2.0)

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 SlideShare 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 SlideShare 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 STP 2.0:

  • Performance
  • Security
  • High Availability
  • Development
  • SQL Server on Linux
  • Big Data
  • Other Enhancements

For the full list of features, please visit Microsoft’s official documentation.

 

Performance

Intelligent query processing

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:

  • Adaptive Query Processing
  • Table variable deferred compilation
  • Approximate query processing
  • Batch Mode on Rowstore

Learn more about Intelligent query processing.

 

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.

Learn more

 

Security

Always Encrypted with secure enclaves

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.

Learn more

 

Data discovery and classification

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.

Learn more

 

Certificate management in SQL Server Configuration Manager

You can now import directly into SQL Server and manage SSL/TLS certificates.

Here’s a screenshot below:

What's New in SQL Server 2019 - SSL/TLS Certificate Manager - Article on SQLNetHub

Briefly, in SQL Server Configuration Manager, with regards to SSL/TLS certificate management, you can now perform the following actions:

  • View and validate certificates installed in a SQL Server instance.
  • Report on certificates close to expiration.
  • Deploy certificates across machines participating in Always On Availability Groups (from the node holding the primary replica).
  • Deploy certificates across machines participating in a failover cluster instance (from the active node).

Learn more

 

High Availability

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.

Learn more

 

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.

Learn more

 

Development

UTF-8 support

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.

What's New in SQL Server 2019 - Support for UTF-8 -Article on SQLNetHub

 

Learn more

 

Java language programmability extension

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.
  • …and much more

Learn more

 

Big Data

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.

Learn more

 

Other Features

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.

Also, along with the release of SQL Server 2019 CTP 2.0, a new release of Azure Data Studio is out, as well as SQL Server Management Studio (SSMS) v18.0 (Preview).

 

Learn more about SQL Server 2019 (CTP 2.0)

You can learn more about SQL Server 2019 by accessing the below online resources:

 

Read Also

 

Subscribe to our newsletter and stay up to date!

Check out our latest software releases!

Check out Artemakis’s eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub

What's New in SQL Server 2019 Click to Tweet

 

Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server and Software Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Artemakis's official website can be found at aartemiou.com.