I’ve been writing articles for SQL Server Magazine as part of my Data Tales series.
Over the last couple of months, I’ve been writing a min-series about a database on a diet.
Earlier parts described the need for size reduction, how ROW and PAGE compression come into play, how to choose between them, etc.
Part 4 (the final part) is now online here:
It covers GZIP compression of large string fields, PDF size reduction in BLOBS, and more.