What’s new in SQL Server 2019 (15.x)

SQL Server 2019 (15.x) builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud environments, and operating systems.

This article summarizes the new features and enhancements for SQL Server 2019 (15.x).

For more information and known issues, see SQL Server 2019 (15.x) release notes.

For the best experience with SQL Server 2019 (15.x), use the latest tools.

SQL Server 2019 (15.x) introduces Big Data Clusters for SQL Server. It also provides additional capability and improvements for the SQL Server database engine, SQL Server Analysis Services, SQL Server Machine Learning Services, SQL Server on Linux, and SQL Server Master Data Services.

Data virtualization and SQL Server 2019 Big Data Clusters

Businesses today often preside over vast data estates consisting of a wide array of ever-growing data sets that are hosted in siloed data sources across the company. Gain near real-time insights from all your data with SQL Server 2019 Big Data Clusters, which provide a complete environment for working with large sets of data, including machine learning and AI capabilities.

Intelligent Database

SQL Server 2019 (15.x) builds on innovations in previous versions to provide industry-leading performance out of the box. From Intelligent Query Processing to support for persistent memory devices, the SQL Server Intelligent Database features improve performance and scalability of all your database workloads without any changes to your application or database design.

In-Memory Database

SQL Server In-Memory Database technologies leverage modern hardware innovation to deliver unparalleled performance and scale. SQL Server 2019 (15.x) builds on earlier innovations in this area, such as in-memory online transaction processing (OLTP), to unlock a new level of scalability across all your database workloads.

Intelligent performance

SQL Server 2019 (15.x) builds on Intelligent Database innovations in previous releases to ensure that it just runs faster. These improvements help overcome known resource bottlenecks and provide options for configuring your database server to provide predictable performance across all your workloads.

Monitoring

Monitoring improvements unlock performance insights over any database workload, just when you need them.

Intelligent Query Processing

With Intelligent Query Processing, you know that critical parallel workloads improve when they’re running at scale. At the same time, they remain adaptive to the constantly changing world of data. Intelligent Query Processing is available by default on the latest database compatibility level setting, delivering broad impact that improves the performance of existing workloads with minimal implementation effort. read more

Developer experience

SQL Server 2019 (15.x) continues to provide a world-class developer experience with enhancements to graph and spatial data types, UTF-8 support, and a new extensibility framework that allows developers to use the language of their choice to gain insights across all their data.