In this episode of the SQL Data Partners Podcast I chat with Jason Brimhall about SQL Server compression. He also answers your compression questions: Why is it a bad idea to compress everything in your database? How does compression work? We also talk about why compression sometimes doesn’t help and he reveals a case study where compression moved the performance needle way back.