One cool little feature in SQL Server 2016 is COMPRESS(). It's a TSQL function available in all editions that shrinks down data using the GZIP algorithm (documentation). Things to know about COMP