1 / 26

What’s New in Microsoft SQL Services

What’s New in Microsoft SQL Services. Nigel Ellis Architect Microsoft SQL Services. Agenda. Year in review: SDS learning Database Service Value Proposition Relational Database-as-a-Service Architecture and breadth Roadmap. Data Platform: Device to Cloud. RDBMS. Service. Protection.

deon
Download Presentation

What’s New in Microsoft SQL Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What’s New in Microsoft SQL Services Nigel Ellis Architect Microsoft SQL Services

  2. Agenda • Year in review: SDS learning • Database Service Value Proposition • Relational Database-as-a-Service • Architecture and breadth • Roadmap

  3. Data Platform: Device to Cloud RDBMS Service Protection Mining Sync Load Reporting Caching Query Analysis Integration Search Backup Model & policy based development and management In Memory RelationalBLOB MultiDim XML File Type Place Mega-server Desktop Data Services Server Mobile/Desktop

  4. Extending SQL Data Platform to Cloud Reference Data Business Intelligence Data Sync Reporting SQL Data Services (SDS) Database-as-a-Service Symmetric Programming Model Data Hub Aggregation • Initial services – core RDBMS capabilities as a service (SDS), Data Sync and Data Hub • Future Offerings • Additional data platform capabilities as a service: BI/DSS, DW • New services: Reference Data, Secure Data Hub Enable new uses of data to deliver differentiated business value

  5. The New SQL Data Services Clear Feedback: “I want a database in the Cloud” • Familiar SQL Server relational model • Uses existing APIs & tools • Built for the Cloud with availability and scale • Accessible to all from PHP, Ruby, and Java Focus on combining the best features of SQL Server running at scale with low friction

  6. The Evolution of SDS Application BrowserApplication Evolves Application BrowserApplication Application ODBC, OLEDB, ADO.Net PHP, Ruby, … REST Client REST Client SQL Client* Cloud Cloud Windows Azure REST (Astoria) Web App ADO.Net + EF REST Client HTTP+REST HTTP+REST HTTP TDS HTTP Windows Azure Web App SQL Client* Data Center Data Center REST/SOAP + ACE Model TDS + TSQL Model SDS Next SDS Current * Client access enabled using TDS for ODBC, ADO.Net, OLEDB, PHP-SQL, Ruby, …

  7. Database Choices • Value Props: • Full h/w control – size/scale • 100% compatibility • Roll-your-own HA/DR/scale • Value Props: • XSPs, Server Ops • SQL CLR • 100% compatibility • Roll-your-own HA/DR/scale Dedicated On-premise SQL Server or other s/w on-premise Resource governance @ machine Security @ DB Server/OS • Value Props: • Auto HA, Fault-Tolerance • Friction-free scale • Self-provisioning • High compatibility Resources Hosted Hosted SQL Server or other Resource governance @ VM Security @ DB Server/OS SDS (RDBMS) Virtual DB server Logical user database (LDB) Resource governance @ LDB Security @ LDB Shared Low “Friction”/Control High Low-cost and zero friction addresses web/dept workloads High compatibility with existing SQL Server offering

  8. Demo: Accessing SDS from PHP BrowserApplication • PHP runs in Azure using FastCGI • Access to SDS via existing drivers • Ease of provisioning Internet HTTP Windows Azure Wordpress (PHP) ODBC Microsoft Data Center TDS+SSL TDS + TSQL Model SQL Data Services

  9. Service Provisioning Model • Each account has • a billing relationship with Microsoft • owns one or more virtual servers • Each server has • one or more databases including virtual master • each database limited in size • one or more logins • Each database has • one or more SQL users Account Server Database • Server=server1.data.database.windows.net • Database=testDB • Login=nigele[@server1] (maps to testuser)

  10. Logical Databases (LDB) • Shared infrastructure at SQL database and below • Request routing, security and isolation • Scalable HA technology provides the glue • Automatic replication and failover • Provisioning, metering and billing infrastructure Machine 4 Machine 5 Machine 6 Machine 7 SQL Instance SQL Instance SQL Instance SQL Instance SQL DB SQL DB SQL DB SQL DB Provisioning (databases, accounts, roles…), Metering, and Billing DB1 DB2 DB3 DB4 DB5 DB1 DB3 DB2 DB1 DB6 DB2 DB3 DB4 DB5 DB1 DB7 Scalability and Availability: Fabric, Failover, Replication, and Load Balancing

  11. demo SQL Tooling and Development

  12. Compatibility Goals • Support common application patterns • Logical/policy based administration • Patterns work from Server to Cloud • Multi-tenancy considerations • Throttling and load balancing • Limits on DB size, transaction duration, … V1: Address the needs of 95% or more web and departmental application

  13. Example of SQL Compatibility In Scope for v1 (likely) Out of Scope for v1 (likely) Distributed Transactions Distributed Query CLR Service Broker Spatial Physical server or catalog DDL and views • Tables, indexes and views • Stored Procedures • Triggers • Constraints • Table variables, session temp tables (#t) • …

  14. Connection Model • Clients connect directly to a database • Most SQL supported within database • Cannot hop across DBs • DB’s can be on different servers so state management is hard Connection tied to target database; cannot “hop” across

  15. Security Model • Uses regular SQL security model • Authenticate logins, map to users and roles • Authorize users and roles to SQL objects • Limited to standard SQL Auth logins • Username + password • Future AD Federation, WLID, etc as alternate authentication protocols Security model is 100% compatible with on-premise SQL

  16. Platform Readiness (EHA) • Exchange Hosted Archive (EHA) is high scale archival service • Runs on SDS infrastructure • In production prior to SDS v1 • Rebuilt to address cost and scale issueshttp://go.microsoft.com/fwlink/?LinkId=145374 • Reduced COGS with increased customerand business benefit: • Larger scale (e.g. larger customers ~20TB+ each) • More self-managing (e.g. fault-tolerance) • Better query performance for fan-out • Faster provisioning of new customers

  17. SQL ServicesOpportunities and Futures • Partitioned databases • Geo-location and geo-redundancy • Distributed query • Security w/AD, WLID, etc • Support for multiple levels of hardware and software isolation

  18. Release Plan Invitation CTP – On-board invitation-only customers + some current Public CTP – On-board all early adopters Commercial Availability with Windows Azure in 2009 Migration InternalAdoption Invitation CTP Public CTP Commercial Availability PDC MIX ‘09 WWPC TechEd Mar 09 Apr 09 May 09 Jun 09 Jul 09 Aug 09 Sep 09 Oct 09 Nov 09

  19. Key Takeaways • Foundation of the SDS relational platform • Built using core SQL Server product codebase • Delivery of rich relational database service – PDC ’09 • Key capability of the Azure platform • Supports broad spectrum of scenarios

  20. Please Complete an Evaluation FormYour feedback is important! • Evaluation forms can be found on each chair • Temp Staff at the back of the room have additional evaluation form copies

  21. Want to Know More? • Team Blog • http://blogs.msdn.com/ssds • MSDN Development Center • http://msdn.microsoft.com/en-us/sqlserver/dataservices

  22. © 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.

  23. SQL Data Services Clear Feedback: “I want a database in the Cloud” SDS delivers… Zero-friction provisioning Scale-free & easy to manage Automatic HA, fault-tolerance and geo-location support • Familiar relational model • T-SQL, Tables, DML, DDL, Indexes, SPs... • Leverage existing tools • Extends on-premises apps • Highly interoperable • Breadth developer support • PHP, Ruby, Java • OSS libraries and frameworks SQL Data Services combines the best features of simple storage and hosted RDBMS Replaces current “Flex Entity” Data Model and Protocol Support ADO.NET Data Services – REST/HTTP support Windows Azure Storage – “property bag” data model

  24. Logical vs. Physical Administration • SDS focus on logical administration • Move to policy based management • Data management, config and availability • Automatically replicated with HA “out of box” • Transparent failover in case of failure • Load balancing of data to ensure SLA DBA role places more focus on policy/logical management

  25. High Level Architecture TDS Gateway Utility Layer 1 7 Front-end Node Billing/Usage Database Account Database Protocol Parser Front-end Node 6 2 Protocol Parser Roles TDS Session 1 Gateway Logic TDS Session 2 3 Gateway Logic 4 Master Cluster Master Node Master Node 8 Partition Manager Partition Manager NodeProvisioning 5 Data Node Components Data Node Components ServicePlatform Load Balancing Monitoring Machine 4 Machine 5 Machine 6 Machine 7 SQL Instance SQL Instance SQL Instance SQL Instance SQL DB SQL DB SQL DB SQL DB DB1 DB2 DB3 DB4 DB5 DB1 DB3 DB2 DB1 DB6 DB2 DB3 DB4 DB5 DB1 DB7 Scalability and Availability: Fabric, Failover, Replication, and Load balancing Scalability and Availability: Fabric, Failover, Replication, and Load balancing

More Related