SQLSaturday #499 Madison–Jason Brimhall

Jason Brimhall, a Principal Consultant at SQL Solutions Group and a Microsoft Certified Master, was a featured speaker at the Madison SQLSaturday on April 9.

Jason’s topic was Working with Object Compression in SQL Server

SQL Server 2008 introduced object compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What you might not know boils down to some subtleties of compression. For example, not all page compressed objects are entirely page compressed. Many pages can be uncompressed or just row-compressed.

This session shows you how to reach into the database and discover compression states at the page level. At the lower level, this session also shows how to determine compression settings of objects in the database. You can use both some undocumented and more commonly known commands to derive some interesting information from the database engine.

Get all event details on the Madison SQLSaturday website.

 
 
Loading Map....

Date/Time
Date(s) - 04/09/2016
8:00 AM - 6:00 PM

Location
The Pyle Center

Categories No Categories