SQLBits 2011

SQL Azure-Design Concepts

Basic outline of SQL Azure: How SQL Azure fits in with other Azure Storage Options. Main differences between SQL Azure and SQL 2008. Brief new design challenges.
Detail to be added

How SQL Azure fits into Azure storgae options:

1. Blobs Blocks and Pages
2. Azure Tables.
3. Queues
4. Other - local storage and remote storage including SQL.


Main differences.
1. Security and Connecting
2. Unavailable Commands
3. Debugging and tracing -dmv's
4. No DTC


Different design challenges
1. Cloud issues - individual VM reliability
2. Throttling Issues
3. Costs