What you'll learn

Data compression has been available for SQL Server Enterprise Edition since 2008. It's now available in all editions starting with 2016 SP1. Now that it's available for any budget, it might be a feature you have never considered before. In this course, Improve SQL Server Performance with Compression, you'll learn how to determine if data compression is right for your database and how much space savings you can expect. First, you'll discover the different types of compression, and how to determine if compression can improve performance. Next, you'll explore what exactly to watch out for when you're using several popular features, and if those features are compatible. Finally, you'll delve into how to write scripts to automate the process of enabling compression. When you're finished with this course, you'll have all the tools to implement compression and a thorough knowledge of how it works. Software required: SQL Server 2016 SP1.