What's New in SQL Server vNext

SQL Server 2016 and later
 

Updated: February 17, 2017

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

  • Indirect checkpoint performance improvements.
  • Cluster-less Availability Groups support added.
  • Minimum Replica Commit Availability Groups setting added.
  • Availability Groups can now work across Windows-Linux to enable cross-OS migrations and testing.
  • Temporal Tables Retention Policy support added,
  • New DMV SYS.DM_DB_STATS_HISTOGRAM
  • Online non-clustered columnstore index buill and rebuild support added
  • 5 new dynamic management views to return information about Linux process. For more information, see Linux Process Dynamic Management Views.
  • sys.dm_db_stats_histogram (Transact-SQL) is added for examining statistics.

SQL Server Analysis Services (SSAS) (CTP 1.3)

SQL Server Database Engine

  • Online index build and rebuild support for non-clustered Columnstore indexes.
  • This CTP also contains bug fixes for the Database Engine.
  • For a detailed list of vNext CTP enhancements in previous CTP releases, 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.
  • For more detailed SSRS what's new information, including details from previous releases, see What's new in Reporting Services.

SQL Server Analysis Services (SSAS)

SQL Server Integration Services (SSIS)

Master Data Services (MDS)

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

MS_Logo_X-Small

Show: