Our January guest speaker is Andy Mallon! He will talk about Demystifying Data Compression!
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.
Andy is a Data Platform MVP and Product Manager responsible for Data Performance Management at SentryOne. His background is as a SQL Server DBA that has managed databases across many industry sectors, and before that in database-oriented tech support. He has over 13 years of experience supporting high-volume, highly-available OLTP environments with demanding performance needs.
Andy is also the founder of the BostonSQL User Group , and past organizer of SQLSaturday events in Boston. He blogs at am2.co, blogs.sentryone.com, and SqlPerformance.com.
Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.
Thanks to our sponsors: Capital Tech Search, CommerceHub, Datto (formerly AutoTask), and SentryOne for helping to make this meeting possible!
Our meeting schedule is usually as follows:
5:30 PM Food, soft drinks, and networking
6:15 PM Chapter news and announcements
6:20 PM Presentation (topic changes monthly)
We usually wrap up between 7:30 PM and 8:00 PM.