The NTFS file system comparison is great!
Sometimes you compress by using file/folder attributes because you get seamless access to the file, it's convenient and you get some compression benefits for some acceptable overhead.
Likewise, sometimes explicit compression is better - you offload the compression overhead to another one-off task, but you lose the ease of access.
As always, it really depends. I do agree with others though; it was a great article from the point of view of seeing just what sort of things you can do in the DB engine with the new CLR integration - good or bad - and is a welcome distraction from some of the more mundane DBA task articles