Advertisements

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 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
 

My YouTube videos on SQL Server 2017:


 

Connect & Share:

     – Facebook Group: SQL Server 2016 & 2017

     – My FB Page: SQL Server with Manoj


Advertisements
%d bloggers like this: