Allow data compression (to improve size/performance)
Allowing data compression would make it easier to fit within a 1GB/10GB limit and help improve I/O performance on large datasets, not to mention it helps with T-SQL/SQL Server compatibility.
Thanks for your feedback. We now have the next generation of Azure SQL DB in public preview in the US and GA in Europe. Specifically we now support page and row level compression.
Details here http://azure.microsoft.com/blog/2014/12/11/preview-available-for-next-generation-of-azure-sql-database/We understand the issue of database size and SQL Database.
Kevin Christensen commented
Our current databases use data compression extensively. This is a must have for us to migrate to Sql Azure.
Ryan Lamansky commented
In the older storage-centric pricing model, I can see why this would be blocked (to conserve CPU time), but with new model which limits our CPU usage, reckless use of DATA_COMPRESSION (and other features) isn't going to hurt other users. Savvy developers have who have a low CPU % database can save a lot of space and potentially reduce I/O load.
in addition this will help schema migration: no need to use a tool or syntax to strip ou tthe syntax related to compression