| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | ||
|---|---|---|---|---|---|---|---|---|---|---|
What's New for SQL Server 2019 on Linux |
This article highlights what's new for SQL Server 2019 on Linux. |
rwestMSFT |
randolphwest |
01/10/2024 |
sql |
linux |
conceptual |
|
[!INCLUDE sqlserver2019-linux]
This article describes the major features and services available for SQL Server 2019 running on Linux. For package downloads and known issues, see the Release notes.
Starting with SQL Server 2019 CU14, SLES 15 is now supported. Check out our Quickstart on Installing SQL Server and creating a database on SUSE Linux Enterprise Server.
- Starting with SQL Server 2019 CU3, Ubuntu 18.04 is now supported.
- Starting with SQL Server 2019 CU10, Ubuntu 20.04 is now supported.
- Check out our Quickstart on Installing SQL Server and creating a database on Ubuntu.
Starting with SQL Server 2019 CU1, 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 SQL Server 2019 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 SQL Server 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 SQL Server 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 SQL Server 2019. |
| 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 SQL Server 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 SQL Server 2019, see What's New in SQL Server 2019.
[!INCLUDEget-help-options]