Clouds.png

Insights

The ManageForce Blog

SQL Server 2017: What You Need to Know About the Latest Updates

Posted by John Hughes | 9/13/17 10:26 AM

The SQL Server 2017 update has brought some significantly upgraded capabilities to its database engine, integration services, master data services, reporting services, and more. It’s also brought the power of SQL Server to Linux, Linux-based Docker containers, and Windows. All of these updates mean more insights, simpler processes, better database performance, and plenty of changes for on-premise and cloud database services.

As is usually the case, the updates are many and quite detailed, so we’ve pulled out the points we’re most excited to see from our SQL Server services perspective and that we think will bring the biggest changes to database management to keep you up to date.

  • Resumable online index rebuild resumes an online index rebuild operation from where it stopped after a failure (such as a failover to a replica or insufficient disk space), or pauses and later resumes an online index rebuild operation.
  • Automatic database tuning provides insight into potential query performance problems, recommends solutions, and can automatically fix identified problems
  • New Availability Groups functionality includes clusterless support.
  • SQL Server 2017 Integration Services (SSIS) now supports SQL Server on Linux, and a new package lets you run SSIS packages on Linux from the command line.

You can see the full release for all of the updates here: Microsoft

And learn more about how companies are updating their database management strategies in the complimentary eBook:

DownloadtheEbook

Topics: Database Management, SQL Server

Written by John Hughes

Subscribe