Windows Azure SQL Database Design: Concepts and Trade-offs

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
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Karen Lopez is a Sr. Project Manager and Architect at InfoAdvisors. As a Microsoft MVP, she specializes in the practical application of data management principles.  Her speaking style is interactive and engaging. An active blogger, speaker and social networker as @datachick, she hopes to influence attendees to love their data.

    She is a chronic volunteer, Advisor to the Data Management Association's International Board, a frequent speaker on diversity in technology, data policy, open data and emerging technologies and a sometimes runner.  She's also known for her enthusiasm for all things space-related.
  • Video
    The video is not available to view online.