Edit

Share via


What's new for SQL Server 2019 on Linux

Applies to: SQL Server 2019 (15.x) - Linux

This article describes the major features and services available for SQL Server 2019 (15.x) running on Linux.

In addition to these capabilities in this article, cumulative updates (CUs) are released at regular intervals. These cumulative updates provide many improvements and fixes. For detailed information about the latest CU release, see SQL Server 2019 build versions. For package downloads and known issues, see the Release notes.

Red Hat Enterprise Linux 8 support

Red Hat Enterprise Linux (RHEL) 8 is supported in SQL Server 2019 (15.x) CU 1 and later versions. For more information, see Quickstart: Install SQL Server and create a database on Red Hat.

SUSE Linux Enterprise Server 15 support

SUSE Linux Enterprise Server (SLES) 15 is supported in SQL Server 2019 (15.x) CU 14 and later versions. For more information, see Quickstart: Install SQL Server and create a database on SUSE Linux Enterprise Server.

Ubuntu 18.04 and 20.04 support

Ubuntu 18.04 is supported in SQL Server 2019 (15.x) CU 3 and later versions.

Ubuntu 20.04 is supported in SQL Server 2019 (15.x) CU 10 and later versions.

For more information, see Quickstart: Install SQL Server and create a database on Ubuntu.

Updates

The following updates are available in SQL Server 2019 (15.x) on Linux:

New feature or update Details
Replication support SQL Server replication on Linux
Support for the Microsoft Distributed Transaction Coordinator (MSDTC) How to configure the Microsoft Distributed Transaction Coordinator (MSDTC) on Linux
OpenLDAP support for third-party Active Directory providers Tutorial: Use Active Directory authentication with SQL Server on Linux
Machine Learning on Linux Install SQL Server 2019 Machine Learning Services (Python and R) on Linux
tempdb improvements By default, a new installation of SQL Server on Linux creates multiple tempdb data files based on the number of logical cores (with up to eight data files). This setting doesn't apply to in-place minor or major version upgrades. Each tempdb file is 8 MB with an auto growth of 64 MB. This behavior is similar to the default SQL Server installation on Windows.
PolyBase on Linux Install PolyBase on Linux on Linux for non-Hadoop connectors.

Type mapping with PolyBase.
Change Data Capture (CDC) support Change Data Capture (CDC) is supported on Linux for SQL Server 2019 (15.x).
Microsoft Container Registry The Microsoft Container Registry replaces Docker Hub for official Microsoft container images, including SQL Server.
Non-root containers SQL Server 2019 (15.x) introduces the ability to create safer containers by starting the SQL Server process as a non-root user by default. For more information, see Build and run SQL Server containers as a non-root user.

Get help

Contribute to SQL documentation

Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page.

For more information, see Edit Microsoft Learn documentation.