1 / 29

SQL Azure

SQL Azure. An Introduction. Tony Petrossian Microsoft Corporation Tony.Petrossian@microsoft.com. Agenda. What is SQL Azure Why use SQL Azure How does SQL Azure work Architecture Programming Model and APIs Similarities and differences with SQL Server Business Model Future Roadmap.

carsyn
Download Presentation

SQL Azure

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. SQL Azure An Introduction Tony Petrossian Microsoft Corporation Tony.Petrossian@microsoft.com

  2. Agenda • What is SQL Azure • Why use SQL Azure • How does SQL Azure work • Architecture • Programming Model and APIs • Similarities and differences with SQL Server • Business Model • Future Roadmap

  3. Introduction Database as a Service

  4. The Windows Azure Platform • Developer Experience • Use existing skills and tools Relational data Management platform Compute Storage Management AppFabric Flexible APIs Connectivity Access control Information Marketplace Reporting & BI Billing & Payments

  5. Information Platform Vision Empowered IT Pervasive Insight Dynamic Development Mission Critical Platform Desktop & Mobile Server & Datacenter Cloud

  6. Relational Database as a Service C R E A T E D A T A B A S E m y D B Low Friction Elastic Scale Developer Agility

  7. Low Friction Easy, low-cost provisioning • Wizard-based provisioning • Simple database deployment • No physical administration Self-healing platform • Auto High Availability • Built-in fault-tolerant • Automated maintenance Familiar Tools and Interfaces • Manage multiple databases with the same tools you use today

  8. Elastic Scale Provision When and Where you need • Easy to Scale out with multiple database • Pay-as-you-grow databases • No hardware, physical DB or file management required Multi-tenant Applications • Logical schema per tenant with isolated physical storage • Provision new tenants quickly and easily Business-Ready SLAs • Reliability at scale • Security management across multiple databases

  9. Developer Agility • Leverage familiar T-SQL based relational database model • Transact-SQL • ADO.NET • ODBC, • LINQ • Entity Framework • Odata, php • Integration with existing tools to ensure rapid development and symmetry with on-premises DB • Visual Studio • SQL Server Management Studio • Relational Database for Windows Azure applications • SQL Azure provides database service for applications built on Windows Azure

  10. Relational Database as a Service Low Friction Elastic Scale Developer Agility

  11. Extending your Database Choices • Value Props: • Full h/w control – size/scale • 100% of API surface area • Roll-your-own HA/DR/scale • Value Props: • 100% of API surface area • 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 • Subset of API surface area Resources Hosted • Hosted SQL Server • Resource governance @ VM • Security @ DB Server/OS SQL Azure • Logical DB server • Resource governance @ DB • Security @ DB/Logical Server Shared Low “Friction”/Control High SQL Azure V1 targets scenarios that live in the lower left quadrant

  12. Demo Provisioning & Connecting to SQL Azure

  13. Basic Architecture SQL Azure Internals

  14. Service Provisioning Model • Each account has zero or more servers • Azure wide, provisioned in a common portal • Billing instrument • Each server has one or more databases • It is a logical grouping of databases • Contains metadata for databases and usage • Unit of authentication • Unit of Geo-location • Generated DNS based name • A databaseis what you buy • Unit of consistency • Contains Users, Tables, Views, Indices, etc. • Most granular unit of billing • Looks just like a SQL Server database Account Server Database

  15. SQL Azure Topology

  16. Uses shared infrastructure at SQL database and below Each user database is replicated to one or more servers (configurable based on SLA) Client requests are routed to current “primary server” for read and write operations (based on SQL session) Security, lockdown and isolation enforced in SQL tier Highly scalable and state-of-the-art HA technology Automatic failure detection; client request re-routed to new primary on failure High SLA guarantee using logical replication (hot standby replicas) Automatic management, self-healing and load balancing across shared resource pool Provides provisioning, metering and billing infrastructure Core Database Layer Machine 5 Machine 4 Machine 6 SQL Instance SQL Instance SQL Instance SQL DB SQL DB SQL DB UserDB1 UserDB1 UserDB1 UserDB2 UserDB2 UserDB2 UserDB3 UserDB3 UserDB3 UserDB4 UserDB4 UserDB4 SQL Azure Provisioning (databases, accounts, roles, …, Metering, and Billing Scalability and Availability: Fabric, Failover, Replication, and Load balancing Scalability and Availability: Fabric, Failover, Replication, and Load balancing

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

  18. Programming Model Symmetry with SQL Server

  19. On and Off-Premises SymmetrySQL Azure – Highly Symmetrical at Database Scope SQL Data Platform Business Intelligence, Data Integration, Data Warehouse SQL Server Instance Instance Management & Administration SQL Database Core relational database system • Master DB • Extended SPs • Service Broker • SQL Agent • Backup/Restore • Replication • Etc. Relational Model (DDL) Logical Data Administration (DML) • Relational Query & CRUD Transaction Management Stored Procedures, Views, etc. AuthN/AuthZ • Users, Roles, Schemas • Connectivity • ADO.Net • Astoria • EF • LINQ • PHP • Java

  20. T-SQL Support And on and on… the list is growing Some Features are not needed in the Cloud Service model and they will not be supported

  21. Comparing the DDL • SQL Server • CREATE DATABASE[TPCH] ON PRIMARY • ( NAME = N'TPCH', • FILENAME = N'C:\TPCH.mdf' , • SIZE = 195840KB , • MAXSIZE = UNLIMITED, • FILEGROWTH = 1024KB ) • LOG ON • ( NAME = N'TPCH_log', • FILENAME = N'C: TPCH_log.LDF' , • SIZE = 470144KB , • MAXSIZE = 2048GB , • FILEGROWTH = 10%) • SQL Azure • CREATE DATABASE[TPCH]

  22. Current Service Offerings Availability & Pricing

  23. Pricing & Service Level Standard Consumption Database Availability Initial Offers Low barrier to entry and flexible. Optimized to enable cloud elasticity. Additional promo and program offers to drive early adoption • Introductory Offer (promotion) • Free developer starter offer • Limit one per customer • Standard Consumption Offer • Optimized for cloud elasticity • Subscription Offers (promotion) • Predictable and discounted price • MSDN Premium Offer (promotion) • Available to MSDN Premium subscribers • Limit one per subscription Database will be available/reachable, external connectivity Proper requests will be processed successfully All usage at standard rates No limit in the number of subscriptions Charged only for what you use Web Edition 1 GB DB space $9.99 ~11 CHF Business Edition 10 GB DB space $99.99 ~ 110 CHF Additional 5% promotional discount available to partners (Except storage and bandwidth) > 99.9% + Bandwidth

  24. Service Presence & Availability Data centers in US, Europe and Asia

  25. Microsoft SQL Azure Roadmap • Multi-tenant ISVs • Business continuity • Scale Up (50GB in June) • Reporting as a Service • Backup/Restore (copy & logical) • Spatial Support • Relational Database as a service for Windows Azure T-SQL query support Core RDBMS features • Data Types • BulkCopy • ADO.NET, ODBC • Better Sharding Support • Compliance • Premium SLAs • Tooling Support • SQL Server Management Studio • Visual Studio • Query Analyzer • BCP, SSIS, SQL cmd • Powershell, SMO • Security: • Authentication • Authorization • Firewall • High Availability • Fault Tolerance • Auto Management • Elastic Scale-out • ‘Dallas’ information as a service • Data Sync • On-prem to cloud, 2/3-tier • Management of DACs • BI as a service • DW as a service • Automated migration 2009 2010 Beyond

  26. Azure Prices and Packages http://www.microsoft.com/WindowsAzure/offers/ SQL Azure Information http://www.microsoft.com/windowsazure/sqlazure/ MSDN Resources http://www.microsoft.com/windowsazure/sqlazure/ MSDN Documentation http://msdn.microsoft.com/en-us/library/ee336279.aspx Additional Resources Come see us at “Windows Azure “Ask the Experts” table if you have questions OR to give us your feedback

  27. Q&A

  28. Thank you for your Attention! • For more Information please contact • Tony Petrossian • Principal Program Manager • SQL Azure Development • Microsoft Corporation • tonypet@microsoft.com

More Related