Updated: November 27, 2023 (May 7, 2019)

SQL Server 2019 Advances Linux Version

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server 2019 on Linux receives several key database features, bringing it close to parity with the Windows version.
SQL Server 2019 and future versions will have some features that are specific to each OS, so architects will need to check that features are available on their chosen platform.

SQL Server 2019, expected in the second half of 2019, includes improved Linux database engine and integration components compared to SQL Server 2017. The upcoming version addresses many incompatibilities between Linux and Windows deployments of the product. It also sharpens the differences between the OSs: the Linux version will offer an exclusive deployment option for creating and managing data lakes and plans to bring SQL Server business intelligence (BI) roles from Windows to Linux are canceled in favor of Power BI investments.

Possible Use Cases

SQL Server 2017 introduced Linux OS support for most features of the core database engine, although on Linux it is limited compared to on Windows and is missing BI features, such as Reporting Services and Analysis Services. Deploying SQL Server to Linux servers will most likely benefit organizations in the following scenarios:

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now