Past Meetup

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

This Meetup is past

11 people went

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

Details

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 www.am2.co, and is co-organizer of SQL Saturday Boston.