| title | What's New for SQL Server 2019 on Linux | ||
|---|---|---|---|
| description | This article highlights what's new for SQL Server 2019 on Linux. | ||
| author | rwestMSFT | ||
| ms.author | randolphwest | ||
| ms.date | 01/10/2024 | ||
| ms.service | sql | ||
| ms.subservice | linux | ||
| ms.topic | whats-new | ||
| ms.custom |
|
[!INCLUDE sqlserver2019-linux]
This article describes the major features and services available for [!INCLUDE sssql19-md] running on Linux. For package downloads and known issues, see the Release notes.
Starting with [!INCLUDE sssql19-md] CU 14, SLES 15 is now supported. Check out our Quickstart on Installing SQL Server and creating a database on SUSE Linux Enterprise Server.
- Starting with [!INCLUDE sssql19-md] CU 3, Ubuntu 18.04 is now supported.
- Starting with [!INCLUDE sssql19-md] CU 10, Ubuntu 20.04 is now supported.
- Check out our Quickstart on Installing SQL Server and creating a database on Ubuntu.
Starting with [!INCLUDE sssql19-md] CU 1, RHEL 8 is now supported. Check out our Quickstart on Installing SQL Server and creating a database on Red Hat.
The updates have been made in [!INCLUDE sssql19-md] 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 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 | Configure Machine Learning on Linux |
tempdb improvements |
By default, a new installation of [!INCLUDE ssnoversion-md] on Linux creates multiple tempdb data files based on the number of logical cores (with up to 8 data files). This does not 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 [!INCLUDE ssnoversion-md] installation on Windows. |
| PolyBase on Linux | Install PolyBase on Linux for non-Hadoop connectors. PolyBase type mapping. |
| Change Data Capture (CDC) support | Change Data Capture (CDC) is now supported on Linux for [!INCLUDE sssql19-md]. |
| Microsoft Container Registry | The Microsoft Container Registry replaces Docker Hub for official Microsoft container images, including [!INCLUDE ssnoversion-md]. |
| Non-root containers | [!INCLUDEsql-server-2019] introduces the ability to create safer containers by starting the [!INCLUDEsql-server] process as a non-root user by default. See build and run SQL Server containers as a non-root user for more details. |
To install [!INCLUDE ssnoversion-md] on Linux, use one of the following tutorials:
- Install on Red Hat Enterprise Linux
- Install on SUSE Linux Enterprise Server
- Install on Ubuntu
- Run on a Linux container
- Provision a SQL VM in Azure
For answers to frequently asked questions, see the SQL Server on Linux FAQ. To see other improvements introduced in [!INCLUDE sssql19-md], see What's new in SQL Server 2019.
[!INCLUDEget-help-options]