What’s new in SQL Server 2017 ?

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.

Published by arjunpremier

Software Engineer, Blogger,

2 thoughts on “What’s new in SQL Server 2017 ?

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Design a site like this with WordPress.com
Get started