<t>SQL Azure is great when you want to work with structured data using relations, indexes, constraints, etc.<br/>
<br/>
Azure storage table is great when you need to work with centralized structured data without relations and usually with large volumes.<br/>
<br/>
The Price:<br/>
SQL Azure: $25.98/mo for 5GB<br/>
<br/>
Storage table: $21.88/m for 175 GB (without transactions or bandwidth)<br/>
So when you store large volumes of data, storage table is a lot cheaper... think of logging for example.<br/>
<br/>
The centralization:<br/>
Windows Azure is a distributed environment for servers so if you save something on one machine, others won't know about it, therefore storage table is a good solution for centralized loggins, session handling, settings or whatever (keep on mind that there is latency even in one datacenter)<br/>
<br/>
The speed:<br/>
If you design it right, in many cases storage table should be faster than sql azure but it probably depends on use cases and I haven't really tested this.</t>