What's new in SQL Server 2017


SQL Server 2017 represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows. This topic summarizes what is new for specific feature areas and includes links to additional details. 

SQL Server 2017 Database Engine
SQL Server 2017 includes many new Database Engine features, enhancements, and performance improvements.
  • CLR Assemblies
  • Resumable online index rebuild
  • IDENTITY_CACHE
  • Adaptive query processing
  • Automatic database tuning
  • New graph database capabilities
  • modified_extent_page_count
  • Always On Availability Group
  • New Availability Groups
  • Database Tuning Advisor (DTA)
  • In-memory enhancements
  • New String Functions are CONCAT_WS, TRANSLATE, TRIM and  WITHIN GROUP  is now supported for the  STRING_AGG function.  
  • bulk access options
  • Memory-optimized object enhancements
  • DATABASE SCOPED CREDENTIAL
  • Database COMPATIBILITY_LEVEL 140 is added.