What's New in SQL Server vNext

SQL Server 2016 and later

Updated: December 16, 2016

SQL Server vNext represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises and in the cloud, and across operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows.

This topic is a summary of what is new in the most recent Community Technical Preview (CTP) release, links to more detailed what's new information for specific feature areas.

info_tip Run SQL Server on Linux! For more information, see:

Try it out:

SQL Server Database Engine

  • Memory-optimized tables and indexes now support computed columns.
  • Natively compiled modules now support the CROSS APPLY operator, and all JSON functions.
  • New string functions CONCAT_WS, TRANSLATE, and TRIM are added.
  • The WITHIN GROUP clause is now supported for the STRING_AGG function.
  • Two new Japanese collation families (Japanese_Bushu_Kakusu_140 and Japanese_XJIS_140) were added, and the collation option Variation-selector-sensitive (_VSS) was added for use in Japanese collations. For more detail see Collation and Unicode Support
  • New bulk access options (BULK INSERT and OPENROWSET(BULK...) enable access data directly from a file specified as CSV format, and from files stored in Azure Blog storage through the new BLOB_STORAGE option of EXTERNAL DATA SOURCE.

Note: SQL Server vNext includes features added in SQL Server 2016 service packs. For a list, go to What's New in SQL Server 2016 (Database Engine).

For a detailed list of vNext CTP enhancements, see What's New in SQL Server vNext (Database Engine).

SQL Server R Services

  • There are no new R Services features in this CTP.
  • For more detailed R Services what's new information, including details from previous CTPs, see What's New in SQL Server R Services.

SQL Server Reporting Services (SSRS)

  • There are no new SSRS features in this CTP.

SQL Server Analysis Services (SSAS)

  • 1400 Compatibility level for tabular models.
  • Modern Get Data query and import data features for tabular models.
  • Support for ragged hierarchies with the new Hide Members property.
  • Support for drillthrough by using Detail Rows. This includes the Default Detail Rows expression property and DETAILROWS DAX function.
  • Table-level security, restricts user permissions on table data and table names.
  • New DAX IN function.
  • For more details, see What's New in Analysis Services vNext.

SQL Server Integration Services (SSIS)

Master Data Services

  • There are no new Master Data Services features in this CTP.