February Meeting 2017 Andy Mallon – Demystifying Data Compression

andyBio:

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. As co-organizer of SQL Saturday Boston, and speaker at many SQL Server user groups & SQL Saturdays, Andy loves sharing his knowledge & experience with others.

He’s lazy: Andy loves scripting and automating repetitive tasks, and hates doing the same thing over and over.

He’s impatient: Andy loves looking at processes and figuring out a faster, more efficient way to accomplish the same goal. Sometimes this is performance-tuning a query, and sometimes it’s looking for fundamentally different ways to accomplish the same goal.

Abstract:

SQL Server 2016 SP1 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.

 

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

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