Andy Mallon~Demystifying Data Compression: When is it right for you?

Rhode Island SQL Server User Group
Rhode Island SQL Server User Group
Public group

New England Institute of Technology - East Greenwich Campus

1408 Division Road · East Greenwich, Rh

How to find us

Hall of Fame Room ~ First floor across from the cafeteria

Location image of event venue


Pizza and Networking at 6PM. Presentation to start around 6:30PM.

High-end storage is expensive, and SQL Server data compression can make your database smaller. So lets compress all the tables! No--unfortunately, it's not that easy. We'll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we'll look at the costs and benefits associated with each type of compression. By the end of this session, you'll have a better idea of when compression is the right solution, as well as what type of compression to use.

About Andy:
Andy is a SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has over 12 years of experience supporting high-volume, highly-available OLTP environments with demanding performance needs. Andy blogs at, and is co-organizer of SQL Saturday Boston.