Improve SQL Server Performance with Compression

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.
Course info
Rating
(13)
Level
Intermediate
Updated
Aug 11, 2017
Duration
1h 37m
Table of contents
Description
Course info
Rating
(13)
Level
Intermediate
Updated
Aug 11, 2017
Duration
1h 37m
Description

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
About the author

Kathi Kellenberger is a SQL Server MVP and a Teammate with Linchpin People. She is the author or co-author of several SQL Server books, including Beginning T-SQL from Apress, and frequently speaks at community events such as PASS Summit and SQL Saturday.

More from the author
Build and Deploy SSRS Mobile Reports
Intermediate
2h 45m
Jan 28, 2017
Configuring Kerberos for SSRS
Beginner
1h 40m
Jan 26, 2016
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone. My name is Kathi Kellenberger, and welcome to my course, Improve Performance with SQL Server Data Compression. I'm an independent database consultant, and you can find out more about me at auntkathisql. com. SQL Server data compression is now available in all editions of SQL Server, starting with 2016 SP1. In this course, you will not only learn how data compression will save space, you'll also find out how compression can sometimes improve performance as well. Some of the major topics that we'll cover include the different types of compression, row level and page level, how to estimate space savings, if several other features are compatible with compression, and how to write scripts to automate enabling compression. By the end of this course, you'll understand how data compression works, and whether it makes sense to implement in your databases. Before beginning the course, you should be familiar with SQL Server, for example, creating databases and running queries. I hope you'll join me on this journey to learn about data compression with the Improve Performance with SQL Server Data Compression course at Pluralsight.