A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much smaller.
I see database compression, as offered with SQL 2008, to be more like these file compression utilities than DriveSpace. Data compression in SQL 2008 is not an all or none implementation. You get to pick and choose what gets compressed. That is a big time bonus for me.