July 23, 2019 – Demystify Data Compression

Andy Mallon

Demystify Data Compression

Jul 23, 2019, 5:30pm

Andy Mallon

SQL Server 2016 SP1 and newer makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it’s important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.

By the end of this session, you’ll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

Speaker Bio

Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003.

Andy is also co-organizer of SQL Saturday events in Boston, and the founder of the BostonSQL User Group. He blogs at am2.co, and as a guest blogger at SqlPerformance.com.

Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.

Presentation Materials

Available on Andy’s GitHub

Important meeting information:

We meet at the offices of Wayfair, upstairs from the Copley Place Mall, at 4 Copley Place, Boston.

Due to building security at our meeting venue, attendees must be registered, and must present a valid photo ID to building security. Directions to the Wayfair offices can be found here.

Typical Meeting Format:

5:30pm – 6:00pm — food / beverages, networking and group discussion

6:00pm – 6:15pm — news, announcements, upcoming training opportunities

6:15pm – 7:30pm — guest speaker presentation … we keep it flexible. Some speakers will talk longer or shorter than others.

Each attendee must RSVP separately so that we have your name for the building security list.

Leave a Reply

Your email address will not be published. Required fields are marked *