What's New in SQL Server vNext
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.
Run SQL Server on Linux! For more information, see:
Try it out:
- 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.
- Encoding hints - an advanced feature used to optimize processing (data refresh) of large in-memory tabular models. To learn more, see What's New in Analysis Services vNext.
- 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).
- 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.
- For more detailed SSRS what's new information, including details from previous releases, see What's new in Reporting Services.
- There are no new SSAS features in this CTP.
- 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