SQL Server 2017 – Articles


–> Download and Install [SQL Server 2017 (RTM)], [SSRS 2017]

–> Download & Install SQL Server for free [Developer Edition]

–> Install and Configure SQL Server 2017 on Linux

–> Connect SQL Server on Linux with SSMS from a Windows machine
 

Top new Features:

     1. Adaptive query processing

     2. Resumable online index rebuild

     3. Automatic database tuning

     4. New Graph database

     5. “SELECT INTO” to a File Group

     6. New DMV sys.dm_db_stats_histogram, for examining statistics

     7. New DMVs, sys.dm_exec_query_statistics_xml and sys.dm_os_host_info

     8. New Machine Learning Services with R & Python
 

New Functions:

     1. STRING_AGG()

     2. TRIM()

     3. TRANSLATE()

     4. CONCAT_WS()
 

Enhancements:

     1. In-Memory enhancements and improvements over previous versions

     2. ColumnStore Index enhancements and improvements over previous versions

     3. Indirect Checkpoint performance improvements

     4. Improvements on calculating thresholds on Incremental Statistics
 

My YouTube videos on SQL Server 2017:


 

Connect & Share:

     – Facebook Group: SQL Server 2016 & 2017

     – My FB Page: SQL Server with Manoj