SQL Azure doesn’t currently support page level or row level compression like the enterprise edition of SQL Server 2008. However, you can implement your own column level compression in your data access layer to take advantage of the performance and cost
Read More...
Read the complete post at http://blogs.msdn.com/b/sqlazure/archive/2010/09/02/10057355.aspx