And what about to also encrypt the compressed content? Months ago, I was writing a UDT that automatically compress/decompress the content.  Not too much useful since and UDT can't be bigger than 8K, but I found that automatic encryption for the compressed content would be a nice feature.

Again, we can discuss if this should be done by database layer using CLR or by application layer, but as I explain in the article, if others RDBMS are offering this feature, probably someone is using it.

You can find this UDT at http://jcarlossaez.blogspot.com/2006/11/compressed-and-encrypted-user-defined.html