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: