What's new in SQL Server 2019 preview

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server 2019 preview builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems.

This article summarizes new features and enhancements for SQL Server 2019 preview.

For more information and known issues, see the SQL Server 2019 preview Release Notes.

Use the latest tools for the best experience with SQL Server 2019 preview.

CTP 3.2 July 2019

Community technology preview (CTP) 3.2 is the latest public release of SQL Server 2019 preview. This release includes improvements from previous CTP releases to fix bugs, improve security, and optimize performance. For a list of features introduced or improved in each of the CTP releases before SQL Server 2019 preview CTP 3.2, see SQL Server 2019 preview CTP announcement archive.

New in big data clusters

New feature or update Details
Public preview Prior to CTP 3.2, SQL Server big data cluster was available to registered early adopters. This release allows anyone to experience the features of SQL Server Big data clusters.

See Get started with SQL Server big data clusters.
azdata CTP 3.2 introduces azdata - a command-line utility written in Python that enables cluster administrators to bootstrap and manage the big data cluster via REST APIs. azdata replaces mssqlctl. See Install azdata.
PolyBase External table column names are now used for querying SQL Server, Oracle, Teradata, MongoDB, and ODBC data sources. In previous CTP releases, the columns were bound only based on ordinal on the destination and column names in external table definition was not used.
HDFS tiering refresh Introducing refresh functionality for HDFS tiering so that an existing mount can be refreshed for the latest snapshot of the remote data. See HDFS tiering
Notebook-based troubleshooting CTP 3.2 introduces Jupyter notebooks to assist with deployment and discovery, diagnosis, and troubleshooting for components in a SQL Server big data cluster.
   

New in Analysis Services

New feature or update Details
Governance setting for Power BI cache refreshes. The Power BI service caches dashboard tile data and report data for initial load of Live Connect report, causing an excessive number of cache queries being submitted to SSAS, and in extreme cases overload the server. This release introduces the ClientCacheRefreshPolicy property. This property allows you to override this behavior at the server level. To learn more, see General Properties.
Online attach This feature provides the ability to attach a tabular model as an online operation. Online attach can be used for synchronization of read-only replicas in on-premises query scale-out environments. To learn more see Online attach in Details.
   

New in Language extensions

New feature or update Details
New default Java Runtime SQL Server now includes Azul System's Zulu Embedded for Java support throughout the product. For more information, see Free supported Java in SQL Server 2019 is now available.

New in SQL Server on Linux

New feature or update Details
Change Data Capture (CDC) support Change Data Capture (CDC) is now supported on Linux for SQL Server 2019.

SQL Server 2019 preview features by component

The following sections highlight new components and features that were enhanced in earlier releases of SQL Server 2019 preview.

Big data clusters

New feature or update Details
Scalable big data solution Deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes

Read, write, and process big data from Transact-SQL or Spark

Easily combine and analyze high-value relational data with high-volume big data

Query external data sources

Store big data in HDFS managed by SQL Server

Query data from multiple external data sources through the cluster

Use the data for AI, machine learning, and other analysis tasks

Deploy and run applications in big data clusters
   

For more details, see What are SQL Server big data clusters

SQL Server 2019 preview (CTP) announcement archive contains a list of features announced and changed for all previous CTP releases of this feature.

Database engine

Security

New feature or update Details
Index encrypted columns Create indexes on columns encrypted using randomized encryption and enclave-enabled keys, to improve the performance of rich queries (using LIKE and comparison operators). See Always Encrypted with Secure Enclaves.
Suspend and resume initial scan for Transparent Data Encryption (TDE) See Transparent Data Encryption (TDE) scan - suspend and resume
Certificate management in SQL Server Configuration Manager See Certificate Management (SQL Server Configuration Manager)
   

Graph

New feature or update Details
Edge constraint cascade delete actions Define cascaded delete actions on an edge constraint in a graph database. SeeEdge constraints.
New graph function - SHORTEST_PATH Use SHORTEST_PATH inside MATCH to find the shortest path between any 2 nodes in a graph or to perform arbitrary length traversals.
Partition tables and indexes The data of partitioned tables and indexes is divided into units that can be spread across more than one filegroup in a graph database.
Use derived table or view aliases in graph match query See Graph Edge Constraints.
   

Indexes

New feature or update Details
OPTIMIZE_FOR_SEQUENTIAL_KEY Turns on an optimization within the database engine that helps improve throughput for high-concurrency inserts into the index. This option is intended for indexes that are prone to last-page insert contention, typically seen with indexes that have a sequential key such as an identity column, sequence, or date/time column. See CREATE INDEX for more information.
Build and rebuild online clustered columnstore index See Perform Index Operations Online.
   

In memory databases

New feature or update Details
DDL control for hybrid buffer pool With hybrid buffer pool, database pages sitting on database files placed on a persistent memory (PMEM) device will be directly accessed when required.
Memory-optimized tempdb metadata See Memory-Optimized TempDB Metadata
   

Linked servers

New feature or update Details
Linked Servers support UTF-8 character encoding. Collation and Unicode Support
   

PolyBase

New feature or update Details
PolyBase External table column names are now used for querying SQL Server, Oracle, Teradata, MongoDB & ODBC data sources.
   

Collation

New feature or update Details
Support UTF-8 character encoding Enabled for a BIN2 collation (Latin1_General_100_BIN2_UTF8). See Collation and Unicode Support.
Select UTF-8 collation as default during setup See Collation and Unicode Support.
   

Server settings

New feature or update Details
Set MIN and MAX server memory values at setup During setup, you can set server memory values. Use the default values, the calculated recommended values, or manually specify your own values once you've chosen the Recommended option Server Memory Server Configuration Options.
SQL Server Setup enables MAXDOP settings New recommendations follow the documented guidelines.Configure the max degree of parallelism Server Configuration Option
Hybrid buffer pool New feature of the SQL Server database engine where database pages sitting on database files placed on a persistent memory (PMEM) device will be directly accessed when required. See Hybrid buffer pool .
   

Performance monitoring

New feature or update Details
Scalar UDF inlining Automatically transforms scalar user-defined functions (UDF) into relational expressions and embeds them in the calling SQL query. See Scalar UDF Inlining.
sys.dm_exec_requests column command Shows SELECT (STATMAN) if a SELECT is waiting for a synchronous statistics update operation to complete prior to continuing query execution. See sys.dm_exec_requests.
WAIT_ON_SYNC_STATISTICS_REFRESH New wait type in sys.dm_os_wait_stats dynamic management view. It shows the accumulated instance-level time spent on synchronous statistics refresh operations. See sys.dm_os_wait_stats.
Custom capture policy for the Query Store When enabled, additional Query Store configurations are available under a new Query Store Capture Policy setting, to fine-tune data collection in a specific server. For more information, see ALTER DATABASE SET Options.
sys.dm_exec_query_plan_stats New DMF returns the equivalent of the last known actual execution plan for most queries. See sys.dm_exec_query_plan_stats.
LAST_QUERY_PLAN_STATS New database scoped configuration to enable sys.dm_exec_query_plan_stats. See ALTER DATABASE SCOPED CONFIGURATION.
LIGHTWEIGHT_QUERY_PROFILING New database scoped configuration. See LIGHTWEIGHT_QUERY_PROFILING.
query_post_execution_plan_profile Extended Event collects the equivalent of an actual execution plan based on lightweight profiling, unlike query_post_execution_showplan which uses standard profiling. See Query profiling infrastructure.
Row mode memory grant feedback. Row mode memory grant feedback
Table variable deferred compilation. Table variable deferred compilation
Approximate COUNT DISTINCT. Approximate query processing
Batch mode on rowstore. Batch mode on rowstore

Language extensions

New feature or update Details
New Java language SDK Simplifies development of Java programs that can be run from SQL Server. See What's new in SQL Server Machine Learning Services.
SQL Server Language Extensions - Java language extension The Microsoft Extensibility SDK for Java for Microsoft SQL Server is now open source and available on GitHub.
Register external languages New DDL, CREATE EXTERNAL LANGUAGE, registers external languages, like Java, in SQL Server. See CREATE EXTERNAL LANGUAGE.
Support for Java data types See Java data types.

Spatial

New feature or update Details
New spatial reference identifiers (SRIDs) Australian GDA2020 provides more robust and accurate datum which is more closely aligned to global positioning systems. The new SRIDs are:

- 7843 - geographic 2D
- 7844 - geographic 3D

sys.spatial_reference_systems view contains definitions of new SRIDs.
   

Performance

New feature or update Details
Accelerated database recovery Enable accelerated database recovery per-database. See Accelerated database recovery.
Forcing fast forward and static cursors Query Store plan forcing support for fast forward and static cursors. See Plan forcing support for fast forward and static cursors.
Reduced recompilations for workloads Improves using temporary tables across multiple scopes. See Reduced recompilations for workloads
Indirect checkpoint scalability See Improved indirect checkpoint scalability.
   

Availability groups

New feature or update Details
Up to five synchronous replicas SQL Server 2019 preview increases the maximum number of synchronous replicas to 5, up from 3 in SQL Server 2017 (14.x). You can configure this group of five replicas to have automatic failover within the group. There is one primary replica, plus four synchronous secondary replicas.
Secondary-to-primary replica connection redirection Allows client application connections to be directed to the primary replica regardless of the target server specified in the connection string. For details, see Secondary to primary replica read/write connection redirection (Always On Availability Groups).
   

Error messages

New feature or update Details
Verbose truncation warnings Truncation error message defaults to include table and column names, and truncated value. See VERBOSE_TRUNCATION_WARNINGS.
   

SQL Server on Linux

New feature or update Details
New container registry Get started with SQL Server containers on Docker
Always On Availability Group on Docker containers with Kubernetes Always On Availability Groups for containers
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 AD 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.
   

SQL Server Machine Learning Services

New feature or update Details
Partition-based modeling Process external scripts per partition of your data using the new parameters added to sp_execute_external_script. This functionality supports training many small models (one model per partition of data) instead of one large model. See Create partition-based models
Windows Server Failover Cluster Configure high availability for Machine Learning Services on a Windows Server Failover Cluster.
   

Master Data Services

New feature or update Details
Supports Azure SQL Database managed instance databases. Host Master Data Services on a managed instance. See Master Data Services installation and configuration.
New HTML controls HTML controls replace all former Silverlight components. Silverlight dependency removed.
   

Analysis Services

New feature or update Details
Calculation groups in tabular model Calculation groups in tabular model
MDX query support for tabular models with calculation groups See Calculation groups.
Dynamic formatting of measures using calculation groups This feature allows you to conditionally change format strings for measures with calculation groups. For example, with currency conversion, a measure can be displayed using different foreign currency formats.
Many-to-many relationships in tabular models Many-to-many relationships in tabular models
Property settings for resource governance Property settings for resource governance
   

Enabled deployment scenarios

CTP 3.2 enables the following scenarios:

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

    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.

  • In-place upgrade. Upgrade instances of SQL Server 2019 CTP 3.2 from instances of SQL Server 2012 through SQL Server 2017 and SQL Server CTP 3.0. Upgrade from a SQL Server 2019 CTP below 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.

Support

SQL Server 2019 CTP 3.2 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.2 by special agreement, in consultation with Microsoft.

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

Try SQL Server 2019 preview!

For specific features excluded from support, see the release notes.

In addition, the following features are added or enhanced for SQL Server 2019 preview CTP 3.2.

See also

Next steps

info_tip Get Help