1 / 20

Questions?

Questions?. Text Microsoft to 60300 Or Tweet # uktechdays. SQL Azure Highly available, scalable, multi-tenant database services in the cloud. Dr Keith Burns Data Architect Microsoft UK. Session Objectives and Takeaways. Session Objective(s): Get up to speed on SQL Azure

harry
Download Presentation

Questions?

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. Questions? Text Microsoftto 60300 Or Tweet #uktechdays

  2. SQL AzureHighly available, scalable, multi-tenant database services in the cloud. Dr Keith Burns Data Architect Microsoft UK

  3. Session Objectives and Takeaways • Session Objective(s): • Get up to speed on SQL Azure • Learn about the new features in SQL Azure • Demonstration some working features in action • Determine whether SQL Azure is ready for your application

  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. Extending SQL Server to the Cloud Data Sync Reporting Business Intelligence Database Symmetric Programming Model and tools • At PDC – core RDBMS capabilities with SQL Azure Database • Future Offerings • Additional data platform capabilities: Reporting, BI • New services: Data and Web Services

  6. SQL Azure SQL Azure delivers the value of hosted relational database with the differentiated benefits of a managed database as a utility Hosted RDBMS Managed RDBMS • SQL query processor • Familiar relational model • Transactions • Ecosystem of familiar development and management tools • Low-friction provisioning • High scale • Multi-tenant • Self-management • Automatic HA and DR

  7. Customer Scenarios Departmental Collab. Apps Custom Web Applications Small customers or start ups with Web applications of all scale that have simple RDBMS needs • Departmental workgroup applications with low concurrency and cyclical usage patterns Packaged LOB Applications • ISVs extending offering or selling software hosted in the cloud

  8. Costs(as of 12th April 2010)

  9. demo Provisioning and connection to SQL Azure

  10. Architecture • 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 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 SDS Provisioning (databases, accounts, roles, …), Metering, and Billing Scalability and Availability: Fabric, Failover, Replication, and Load balancing

  11. Database Replicas Single Database Multiple Replicas Replica 1 Single Primary Replica 2 DB Multiple Secondaries Replica 3

  12. Redundant Environment Scale Unit Scale Unit C D A B D Scale Unit Scale Unit C C B A A B D

  13. Connection Model • Use existing client libraries • ADO.NET, ODBC, PHP • Client libraries pre-installed in Azure roles • Support for ASP.NET controls • Clients connect directly to a database • Cannot hop across DBs (no USE)

  14. Logical vs. Physical Administration • SQL Azure focus on logical administration • Schema creation and management • Query optimization • Security management (Logins, Users, Roles) • Service handles physical management • 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 logical management

  15. Deployment • Support for basic deployment options • SQL scripts work (but not attach database) • Co-location of Windows Azure compute and SQL Azure Databases • Support for Data Tier Applications • DACPAC is unit of deployment • Cloud or on-premise is a deployment time choice • Visibility of data across on-premise and the cloud Support existing and new forms of deployment

  16. Security Model • 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 is 100% compatible with on-premise SQL

  17. demo Developing using SQL Azure

  18. Other features • SQL Azure Data Sync • oData services for SQL Azure

  19. Futures • SU2 • MARS Support • SU3 June • Spatial Support • Copy database

  20. For resources, decks and video: www.microsoft.com/uk/techdays SQL Azure: https://www.microsoft.com/windowsazure/sqlazure/ http://sql.azure.com http://www.sqlazurelabs.com Docs: http://msdn.microsoft.com/en-gb/sqlserver/ dataservices/default.aspx Team Blog:http://blogs.msdn.com/ssds/

More Related