This course explains how SQL Server implements data compression, how it can improve performance, reduce disk space, and shows how it can be implemented. It provides sample scripts and demonstrations of the process.
The course will take about 1.5 hours to complete. It consists of videos and video demos. It also includes T-SQL scripts you can download for use on your own systems.
The course is intended for database administrators with an intermediate-level knowledge of SQL Server 2008, 2008 R2, or 2012.
SQL Server implements two different types of compression algorithms.
A discussion on when SQL Server performs data compression and how that affects system performance.
A discussion of the various ways data compression can be turned on and off.
Several demos of turning data compression on and off, row versus page compression, and an example of SQL Server switching from row to page compression.
Things to watch out for when implementing data compression.
A demonstration of a script you can use to automatically find and compress newly created objects in multiple databases.
A summary of what this course was taught you.
This quiz will test how well you understand the important concepts discussed in this course.
Shaun J. Stuart is a Database Administrator with over 15 years experience with SQL Server. He holds the following Microsoft certifications: MCTS: SQL Server 2005, MCTS: SQL Server 2008, MCITP: Database Administrator 2008, and MCSA: SQL Server 2012. He is the senior Database Administrator at the largest credit union in Arizona and a co-author of the book Tribal SQL: New Voices In SQL Server, published by Red Gate. He holds a Bachelors degree in electrical engineering.