SQL Azure-Design Concepts

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
Presented by Geoff Clark at SQLBits IX
  • Downloads
  • SpeakerBIO

    Geoff has architected SQL systems with high throughput and availability for business in many sectors including media and finance. Geoff has been involved with SQL Server since the beginning having been the technical architect at BAA for one of the earliest SQL database project. Geoff began his professional career as a consultant for ICL based in the City of London, designing and capacity planning mainframe systems before moving to Ingres relational databases on Sun and more recently Microsoft .Net technology including SQL Server.

    MCM SQL Server 2008, MCPD Azure.

  • Video