Data architects and designers need to understand the logical, physical, and technical differences in designing for Windows Azure SQL Databases (WASDs) and traditional on-premise SQL Server databases.

In this session we will discuss the reasons why some business problems are better suited for cloud-based solutions and why others might still be best hosted at home.

We'll review the concepts that still work in both and the features that need to be tailored to each target environment. You’ll see demonstrations of the database creation and initial design processes and gain best practices for model-driven development for each environment, including tool support. We’ll finish up with 5 tips for designing databases for both WASD and SQL Server.
Presented by Karen Lopez at SQLBits XII