Improve SQL Server Performance with Compression

Learn to know if data is compressed right and gain the tools to be able to Improve SQL Server Performance with Compression in this course. Start Today!

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.

• Course Overview 1min
• Introduction 14mins
• Determining What to Compress 16mins
• Understanding Row Compression 18mins
• Understanding Page Compression 15mins
• Using the New COMPRESS Function 12mins
• Pulling It All Together 19mins