What's New in SQL Server vNext
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.
Run SQL Server on Linux! For more information, see:
Try it out:
- 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.
WITHIN GROUPclause 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_STORAGEoption 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).
- 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.
- There are no new SSRS features in this CTP.
- 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.
- There are no new SSIS features in this CTP.
- For more detailed SSIS what's new information, including details from previous CTPs, see What's New in Integration Services vNext.
- There are no new Master Data Services features in this CTP.
- Stack Overflow (tag sql-server)
- MSDN Forums
- Microsoft Connect - report bugs and request features
- Reddit - general discussion about R