sql-server-ver15-release-notes.md

title	SQL Server 2019 Release Notes | Microsoft Docs
ms.date	03/27/2019
ms.prod	sql
ms.reviewer
ms.technology	release-landing
ms.topic	article
ms.assetid	13942af8-5a40-4cef-80f5-918386767a47
author	MikeRayMSFT
ms.author	mikeray
manager	craigg
monikerRange	= sql-server-ver15 || = sqlallproducts-allversions

SQL Server 2019 preview release notes

[!INCLUDEtsql-appliesto-ssver15-xxxx-xxxx-xxx]

This article describes limitations and known issues for the [!INCLUDESQL Server 2019] Community Technology Preview (CTP) releases. For related information, see:

• What's New in SQL Server 2019

Note

Preview releases of [!INCLUDEssNoVersion] are made available for you to experience the features of the upcoming release. They are not supported or licensed for production use. The following scenarios are explicitly unsupported:

• Side-by-side installation with other versions of [!INCLUDEssNoVersion]
• Upgrade an existing instance of SQL Server from any version

Try [!INCLUDESQL Server 2019]!

• [Download [!INCLUDESQL Server 2019] to install on Windows](https://go.microsoft.com/fwlink/?LinkID=862101)
• Install on Linux for Red Hat Enterprise Server, SUSE Linux Enterprise Server, and Ubuntu.
• Run on SQL Server 2019 on Docker.

CTP 2.4

[!INCLUDESQL Server 2019] CTP 2.4 is the latest public release of [!INCLUDESQL Server 2019].

[!INCLUDESQL Server 2019] CTP 2.4 is available only as Evaluation Edition. No other editions are available. Support for CTP releases is described in license_Eval.rtf with your installation media.

Limited support may be found at one of the following locations:

• Forums

  • SQL Server Feedback
  • Getting started with SQL Server
  • Transact-SQL
  • SQL Server Documentation

• Or tweet @SQLServer with #sqlhelp

Documentation (CTP 2.4)

• Issue and customer impact: Documentation for SQL Server 2019 (15.x) is limited and content is included with the [!INCLUDEssSQL17] documentation set. Content in articles that is specific to SQL Server 2019 (15.x) is noted with Applies To.

• Issue and customer impact: [!INCLUDEssNoVersion] documentation can be filtered by version. Use the control at the top left of each documentation page to filter for your requirements.

• Issue and customer impact: No offline content is available for SQL Server 2019 (15.x).

Hardware and software requirements (CTP 2.4)

• Issue and customer impact: Hardware and software requirements are still being reviewed and not final for the product release.

  • Hardware
    • Windows - processor, memory, and operating system requirements
    • Linux - system requirements
  • Software
    • Windows Server 2016 or later. For additional requirements, see Requirements for Installing SQL Server
    • Microsoft .NET Framework 4.6.2. Available from Download Center.
    • For Linux, refer to Linux - supported platforms

Updated compiler

• Issue and customer impact: [!INCLUDESQL Server 2019] is built with an updated compiler. CTP 2.1 had a known issue where results for floating point and other conversion scenarios may have returned a different value than previous versions because of the updated compiler. CTP 2.2 includes work to ensure that the affected scenarios return the same results as previous versions of [!INCLUDEssNoVersion]. As of CTP 2.3 release we do not know any remaining issues. Please report any result anomalies compared to [!INCLUDEss2017] to [[!INCLUDEssNoVersion] team](http://aka.ms/sqlfeedback) immediately.

• Workaround: N/A

• Applies to: SQL Server 2019 CTP 2.4, CTP 2.3, CTP 2.2, CTP 2.1

UTF-8 collations

• Issue and customer impact: UTF-8 enabled collations cannot be used with some other [!INCLUDEssNoVersion] features. UTF-8 is not supported when the following [!INCLUDEssNoVersion] features are in use:

  • Linked Server
  • In-memory OLTP
  • External Table for PolyBase
  • Always Encrypted

  [!Note] There is currently no UI support to choose UTF-8 enabled collations in Azure Data Studio or SQL Server Data Tools (SSDT). The latest [!INCLUDEssManStudioFull] (SSMS) version supports choice of UTF-8 enabled collations in the UI.

• Workaround: No workaround for [!INCLUDESQL Server 2019] CTPs.

• Applies to: [!INCLUDESQL Server 2019] CTP 2.4, CTP 2.3, CTP 2.2, CTP 2.1, CTP 2.0.

SQL Graph

• Issue and customer impact: Tools that are dependent on DacFx like import-export, will not work for the new graph features - Edge Constraints or Merge DML. Scripting in [!INCLUDEssManStudioFull] may not work.

• Workaround: Writing [!INCLUDEtsql] scripts and running them against the server using [!INCLUDEssManStudioFull] or SQLCMD will work. Exporting or Importing database objects that create Edge constraints, have the new merge DML syntax, or create derived tables/views on graph objects will not work. Users will have to manually create such objects in their database using [!INCLUDEtsql] scripts.

• Applies to: [!INCLUDESQL Server 2019] CTP 2.4, CTP 2.3, CTP 2.2, CTP 2.1, 2.0.

Always Encrypted with secure enclaves

• Issue and customer impact: Rich computations are pending several performance optimizations, include limited functionality (no indexing, etc.), and are currently disabled by default.

• Workaround: To enable rich computations, run DBCC traceon(127,-1). For details, see Enable rich computations.

• Applies to: [!INCLUDESQL Server 2019] CTP 2.4, CTP 2.3, 2.2, CTP 2.1, 2.0.

System Dynamic Management Views

• Issue and customer impact: The system table-valued function sys.dm_db_objects_disabled_on_compatibility_level_change returns random values in the dependency column.

• Applies to: [!INCLUDESQL Server 2019] CTP 2.4, CTP 2.3.

[!INCLUDEget-help-options-msft-only]