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. For package downloads and known issues, see the Release notes.
SLES 15 supported
Starting with SQL Server 2019 (15.x) CU 14, SLES 15 is now supported. Check out our Quickstart on Installing SQL Server and creating a database on SUSE Linux Enterprise Server.
Ubuntu 18.04 and 20.04 supported
- Starting with SQL Server 2019 (15.x) CU 3, Ubuntu 18.04 is now supported.
- Starting with SQL Server 2019 (15.x) CU 10, Ubuntu 20.04 is now supported.
- Check out our Quickstart on Installing SQL Server and creating a database on Ubuntu.
RHEL 8 supported
Starting with SQL Server 2019 (15.x) CU 1, RHEL 8 is now supported. Check out our Quickstart on Installing SQL Server and creating a database on Red Hat.
Updates
The updates have been made 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 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 (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. See build and run SQL Server containers as a non-root user for more details. |
Related content
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 (15.x), see What's new in SQL Server 2019.
Get help
- Ideas for SQL: Have suggestions for improving SQL Server?
- Microsoft Q & A (SQL Server)
- DBA Stack Exchange (tag sql-server): Ask SQL Server questions
- Stack Overflow (tag sql-server): Answers to SQL development questions
- Reddit: General discussion about SQL Server
- Microsoft SQL Server License Terms and Information
- Support options for business users
- Additional SQL Server help and feedback
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 How to contribute to SQL Server documentation