Jovan Popovic shows us the COMPRESS and DECOMPRESS functions in SQL Server 2016:
These functions use standard GZip algorithm so you can compress data in application layer/client side and send compressed data to SQL Server, or you can compress data in SELECT query and DECOMPRESS it in client side.
This seems potentially useful if you’re going to store blobs of data you don’t need to parse.