RDBMS Service Protection Mining Sync Reporting Load Caching Analysis Query Integration Search Backup Model & policy based development and management Type Place In Memory Multi Dim Relational BLOB XML File Symmetric Programming Model Data Hub Aggregation.
Download ReportTranscript RDBMS Service Protection Mining Sync Reporting Load Caching Analysis Query Integration Search Backup Model & policy based development and management Type Place In Memory Multi Dim Relational BLOB XML File Symmetric Programming Model Data Hub Aggregation.
RDBMS Service Protection Mining Sync Reporting Load Caching Analysis Query Integration Search Backup Model & policy based development and management Type Place In Memory Multi Dim Relational BLOB XML File Symmetric Programming Model Data Hub Aggregation Clear Feedback: “I want a database in the Cloud” Focus on combining the best features of SQL Server running at scale with low friction Data Center Windows Azure Web App REST Client REST/SOAP + ACE Model SDS Current Application SQL Client* HTTP TDS Cloud HTTP+REST HTTP HTTP+REST Cloud Browser Application REST Client Windows Azure Data Center REST Client Application Browser Application Evolves Application REST (Astoria) Web App ADO.Net + EF SQL Client* TDS + TSQL Model SDS Next * Client access enabled using TDS for ODBC, ADO.Net, OLEDB, PHP-SQL, Ruby, … ODBC, OLEDB, ADO.Net PHP, Ruby, … Value Props: Value Props: Dedicated Roll-your-own HA/DR/scale On-premise Resources Value Props: Hosted SDS (RDBMS) Shared Low “Friction”/Control High Browser Application Internet Microsoft Data Center HTTP Windows Azure Wordpress (PHP) ODBC TDS+SSL TDS + TSQL Model SQL Data Services account virtual servers server virtual master logins database SQL users Server=server1.data.database.windows.net Database=testDB Login=nigele[@server1] (maps to testuser) Provisioning (databases, accounts, roles…), Metering, and Billing ne 4 Machine 5 Machine 6 Mach tance SQL Instance SQL Instance SQL In SQL DB SQL DB DB DB3 DB4 DB5 DB1 DB3 DB2 DB1 DB6 DB2 SQL DB3 DB4 Scalability and Availability: Fabric, Failover, Replication, and Load Balancing DB5 V1: Address the needs of 95% or more web and departmental application Connection tied to target database; cannot “hop” across Security model is 100% compatible with on-premise SQL http://go.microsoft.com/fwlink/?LinkId=145374 Reduced COGS with increased customer and business benefit: Larger scale (e.g. larger customers ~20TB+ each) Better query performance for fan-out More self-managing (e.g. fault-tolerance) Faster provisioning of new customers Opportunities and Futures MIX ‘09 Mar 09 Apr 09 Internal Adoption TechEd May 09 Jun 09 Invitation CTP WWPC Migration Jul 09 Aug 09 PDC Sep 09 Public CTP Oct 09 Nov 09 Commercial Availability Your feedback is important! http://blogs.msdn.com/ssds http://msdn.microsoft.com/enus/sqlserver/dataservices © 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, 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. Clear Feedback: “I want a database in the Cloud” SDS delivers… Replaces current “Flex Entity” Data Model and Protocol Support SQL Data Services combines the best features of simple storage and hosted RDBMS DBA role places more focus on policy/logical management Billing/Usage Database 1 7 Utility Layer TDS Gateway Front-end Node Account Database Front-end Node Protocol Parser 6 TDS Session 1 Roles Protocol Parser 2 TDS Session 2 Gateway Logic Gateway Logic 3 4 8 Service Platform Load Balancing Node Provisioning tance DB DB3 DB4 DB5 Master Node Master Node Partition Manager Partition Manager Data Node Components Data Node Components 5 Monitoring ne 4 Master Cluster Machine 5 Machine 6 SQL Instance SQL Instance SQL DB SQL DB DB1 DB3 DB2 DB1 DB6 DB2 Mach SQL In SQL DB3 Scalability Availability: Fabric,Failover, Failover, Replication, andand Load balancing Scalability and and Availability: Fabric, Replication, Load balancing DB4 DB5