SQL Server 2019 preview release notes

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2019)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

CTP 3.0

SQL Server 2019 preview CTP 3.0 is the latest public release of SQL Server 2019 preview.

SQL Server 2019 preview CTP 3.0 is available only as Evaluation Edition. No other editions are available.

Complete details about support and licensing for CTP releases are in license_Eval.rtf with your installation media.

Support

CTP 3.0 is preview software. It is not publicly supported for operations. Customers who are in the SQL Early Adopter Program, may have support to run SQL Server 2019 CTP 3.0 by special agreement, in consultation with Microsoft. For CTP 3.0, this support includes:

  • Side-by-side installation. SQL Server 2019 CTP 3.0 supports side-by-side installation with instances of SQL Server 2012 through SQL Server 2017, or other instances SQL Server 2019 CTP 3.0.

    Note

    While side-by-side is not blocked with SQL Server 2008 and 2008 R2, there are no commonly supported Windows Operating system versions between them and SQL Server 2019.

  • SQL Server 2019 CTP 3.0 supports in-place upgrade from instances of SQL Server 2012 through SQL Server 2017. Upgrade from a previously released SQL Server 2019 CTP release to CTP 3.0 is not supported, a new installation must be performed.

    Note

    While in-place upgrade from SQL Server 2008 and 2008 R2 is not blocked, there are no commonly supported Windows Operating system versions between them and SQL Server 2019.

  • Production support. Customers in early adopter programs can run SQL Server 2019 CTP 3.0 in production environments.

Specific exceptions to support are noted in release notes.

Limited support for customers not in the early adoption program may be found at one of the following locations:

Try SQL Server 2019 preview!

Documentation

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

  • Issue and customer impact: SQL Server 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

Features excluded from support

  • Issue and customer impact: SQL Server 2019 preview excludes support for the following components, features, and scenarios:

    • SQL Sever Analysis Services
    • SQL Server Reporting Services
    • Always On availability groups on Kubernetes
    • Accelerated database recovery
    • Memory-optimized tempdb metadata
  • Workaround: None. Exclusion applies to all customers, including participants in SQL Early Adopter Program.

  • Applies to: CTP 3.0

Updated compiler

  • Issue and customer impact: SQL Server 2019 preview 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 SQL Server. As of CTP 3.0 release we do not know any remaining issues. Please report any result anomalies compared to SQL Server 2017 (14.x) to SQL Server team immediately.

  • Workaround: N/A

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

Installation Wizard may wait between EULA pages

  • Issue and customer impact: During installation with Installation Wizard, the process may wait an excessive amount of time between the end user license agreement (EULA) for R Services and the EULA for Python.

  • Workaround: Wait for the Installation Wizard to proceed. The time to wait may exceed 30 minutes.

  • Applies to: SQL Server 2019 CTP 3.0

UTF-8 collations

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

    • 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 SQL Server Management Studio (SSMS) version 18 supports choice of UTF-8 enabled collations in the UI.

  • Workaround: No workaround for SQL Server 2019 preview CTPs.

  • Applies to: SQL Server 2019 preview CTP 3.0, CTP 2.5, CTP 2.4, CTP 2.3, CTP 2.2, CTP 2.1, CTP 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: SQL Server 2019 preview CTP 3.0, CTP 2.5, CTP 2.4, CTP 2.3, 2.2, CTP 2.1, 2.0.

info_tip Get Help

MS_Logo_X-Small