Understanding Data Compression In SQL Server
4.5 (8 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.
98 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Understanding Data Compression In SQL Server to your Wishlist.

Add to Wishlist

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
4.5 (8 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.
98 students enrolled
Created by Shaun Stuart
Last updated 3/2014
English
Current price: $10 Original price: $45 Discount: 78% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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
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.

Who is the target audience?
  • Advanced beginner to intermediate level DBAs
  • Anyone interested in learning more about how SQL Server Data Compression works
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:20:13
+
Introduction
1 Lecture 00:49
+
Database Compression Overview
1 Lecture 03:17

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

Preview 03:17
+
SQL Server Storage Internals
1 Lecture 09:26

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

Preview 09:26
+
Types Of Data Compression
1 Lecture 01:05

SQL Server implements two different types of compression algorithms.

Two Different Types Of Data Compression
01:05
+
Data Compression Methodologies
2 Lectures 11:21

A look at how row compression operates.

Preview 03:51

A look at how page compression operates.

Page Compression - How It Works
07:30
+
Working With Data Compression
2 Lectures 04:42

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

When Does Compression Take Place?
02:04

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

Turning Data Compression On And Off
02:38
+
Data Compression Demos
1 Lecture 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.

Data Compression Demos
21:07
+
Compression Pitfalls
1 Lecture 06:52

Things to watch out for when implementing data compression.

Compression Gotchas
06:52
+
New Object Compression Demo
1 Lecture 20:40

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

How To Find And Compress Newly Created Objects Demo
20:40
+
Wrap Up
1 Lecture 00:54

A summary of what this course was taught you.

Wrap Up
00:54

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

Data Compression Quiz
10 questions
About the Instructor
Shaun Stuart
4.4 Average rating
113 Reviews
1,197 Students
4 Courses
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.