Understanding Data Compression In SQL Server

An exploration of how SQL Server implements data compression, how it can help improve performance, & how to implement it
5.0 (4 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
74 students enrolled
Instructed by Shaun Stuart Development / Databases
$45
Take This Course
  • Lectures 12
  • Contents Video: 1.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2013 English

Course Description

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.

What are the requirements?

  • To run the included scripts, a copy of SQL Server 2008 or higher, Enterprise, Developer, or Evaluation edition is required
  • Basic knowledge of T-SQL is helpful, but not required

What am I going to get from this course?

  • Over an hour of content!
  • By the end of this course, you will know how SQL Server data compression operates and how to implement it

What is the target audience?

  • Advanced beginner to intermediate level DBAs
  • Anyone interested in learning more about how SQL Server Data Compression works

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Welcome!
Preview
00:49
Section 2: Database Compression Overview
03:17

An overview of what SQL Server's Data Compression is, what it is not, and where it can provide the most benefit.

Section 3: SQL Server Storage Internals
09:26

A brief look at how SQL Server stores data internally, without compression.

Section 4: Types Of Data Compression
01:05

SQL Server implements two different types of compression algorithms.

Section 5: Data Compression Methodologies
03:51

A look at how row compression operates.

07:30

A look at how page compression operates.

Section 6: Working With Data Compression
02:04

A discussion on when SQL Server performs data compression and how that affects system performance.

02:38

A discussion of the various ways data compression can be turned on and off.

Section 7: Data Compression Demos
21:07

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.

Section 8: Compression Pitfalls
06:52

Things to watch out for when implementing data compression.

Section 9: New Object Compression Demo
20:40

A demonstration of a script you can use to automatically find and compress newly created objects in multiple databases.

Section 10: Wrap Up
00:54

A summary of what this course was taught you.

10 questions

This quiz will test how well you understand the important concepts discussed in this course.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shaun Stuart, Senior SQL Server Database Administrator And Author

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.

Ready to start learning?
Take This Course