SQL AZURE Cloud Database Based on SQL Server

SQL AZURE Cloud Database Based on SQL Server 2012 Technologies Gregory Leake Director Technical Marketing, SQL Azure Microsoft Corporation This document has been prepared for limited distribution within Microsoft. This document contains materials and information that Microsoft considers confidential, proprietary, and significant for the protection of its business. The distribution of this document is limited to those solely involved with the program described within. Confidential and Proprietary © 2011 Microsoft Last Updated:

Information Platform as a Service MANAGED SERVICE SCALE ON DEMAND FASTER INNOVATION

EXTENDING SQL SERVER TO THE CLOUD Symmetry with Traditional RDBMS

SQL AZURE DATABASE Multiple Physical Replicas Replica 3 DB Replica 2 Replica 1 Single Logical Database • Reads are completed at the primary • Writes are replicated to a quorum of secondaries

SQL AZURE FEDERATION • Massive Scale • Engage 10 s or 100 s of nodes within the SQL Azure cluster • Best Economics • Administrators can repartition applications based on workload • No downtime is required for these repartitioning operations • Simplified Development and Administration • Robust programming & connectivity model for creating dynamic applications • Native tooling support for managing federations and with online repartitioning operations • Simplified Multi-tenant Database Tiers • Multi-tenancy provides great efficiencies by increasing density of tenants per database • Applications don’t have to make a static decision about tenant placement

FEDERATED DATABASE • 1 x 20 GB database = 1 Machine • 20 x 1 GB databases = 20 Machines

SQL AZURE DEMONSTRATION

NEXT STEPS 1. Take the Tour 2. Sign up for free trial subscription 3. Start building cloud applications today! http: //www. windowsazure. com/

FURTHER. FORWARD. FASTER. • Learn more Visit the Microsoft Virtual Academy Free technical SQL Server training courses • Get more Download SQL Server 2012 Trial Software 180 -day evaluation of SQL Server 2012 • Do more Participate in virtual launch activities and collect points for prizes The more points you earn, the bigger your prize could be

© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U. S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.