Simple play icon Course
Skills Expanded

Improve SQL Server Performance with Compression

by Kathi Kellenberger

Data compression is now available with all editions of SQL Server beginning with 2016 SP1. This course will teach you how to know if data compression is right for your database and how to implement it.

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.

About the author

Kathi Kellenberger is a Data Platform MVP and independent database consultant. She helps customers with SQL Server performance, query tuning, high availability, ETL, and reporting. Kathi has over 15 years' experience with SQL Server starting with SQL Server 6.5. She is the author or co-author of several SQL Server books, including Beginning T-SQL from Apress. She is also an author at SimpleTalk. Kathi enjoys presenting SQL Server topics and frequently speaks at community events such as PASS Summ... more

Ready to upskill? Get started