SQL Server 2017 is here

2017-10-02

SQL Server 2017 is available today!!

SQL Server 2017 is the first version of SQL Server which can run on Linux (RedHat, Ubuntu, SUSE Linux, macOS, Docker). It can be downloaded from here. However, not everything is on other platforms except Windows. No Reporting Services or Analysis Services, nor Machine Learning Services, transactional replication, Stretch DB, or File Table. Check here to see Unsupported features and services. Management tools is still only for running on Windows only, though you can use command-line tools on other platforms.

Here is a detail list of What’s new in SQL Server 2017. The things I like the most are:

Adaptive query processing
Automatic database tuning provides insight into potential query performance problems, recommends solutions, and can automatically fix identified problems.
Graph query support
SSIS scale-out
Python in Machine Learning Services

Bob Ward has a post explainning why SQL Server 2017 is fast, faster and fastest database.

And another important thing is SQL Server won’t have service packs anymore starting from SQL Server 2017. Now it has a Modern Servicing Model for SQL Server. We will only see Cumulative Updates (CUs) and General Distribution Releases (GDRs).