1 / 27

What’s New in Microsoft SQL Azure

Required Slide. SESSION CODE: DAT209. What’s New in Microsoft SQL Azure. Patric McElroy Group Program Manager – SQL Azure Microsoft Corporation. Challenges Facing Enterprise IT. Provisioning, deploying and managing servers at scale.

fathi
Download Presentation

What’s New in Microsoft 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. Required Slide SESSION CODE: DAT209 What’s New in Microsoft SQL Azure Patric McElroy Group Program Manager – SQL Azure Microsoft Corporation

  2. Challenges Facing Enterprise IT Provisioning, deploying and managing servers at scale Enabling faster, more efficient development of applications with existing knowledge and toolsets Reducing IT hardware and infrastructure costs

  3. SQL Azure DatabaseThe first and only true relational database as a service Subtitle color Self-managed Elastic Scale Developer Agility • Build cloud-based database solutions on consistent relational model • Leverage existing skills through existing ecosystem of developer and management tools • Explore new data application patterns • Database utility; pay as you grow • Flexible load balancing • Business-ready SLAs • Enable multi-tenant solutions • World-wide presence • Easy provisioning and deployment • Auto high-availability and fault tolerance • Self-maintaining infrastructure; self-healing • No need for server or VM administration

  4. Compute # of Hr’s Average Usage Managing Data Centric Applications with Capacity BurstsExample: Events, Promotions, Product Launches “Capacity Bursting“ Challenges Today • Elastic scale – database as a service • Pay as you grow and shrink • Easy to provision and manage database • No hardware, no manual database administration required Capacity Average Usage Time • Promotions, events, ticket selling businesses are “bursts – bound” by nature • Capacity constraints limit business agility • High costs of entry into new business • Difficult to roll out extra capacity quickly • Idle capacity “off-bursts” is cost prohibitive “Without SQL Azure, we wouldn’t be able to do this. And that means we couldn't do it on any cloud platform other than Windows Azure. SQL Azure is really a cloud -optimized Database. Chris Auid, Director of Strategy and Innovation, Solution

  5. Service Provisioning Model • Each account has zero or more servers • Azure wide, provisioned in a common portal • Established a Billing instrument • Each server has one or more databases • Logical concept equal to a master DB • Contains metadata about database & usage • Unit of authentication, geo-location, billing, reporting • Generated DNS-based name • Each database has standard SQL objects • Users, Tables, Views, Indices, etc • Unit of consistency Account Server Database

  6. SQL Azure High Level Architecture Applications use standard SQL client libraries: ODBC, ADO.Net, PHP, … Application Internet Azure Cloud TDS (tcp) Load balancer forwards ‘sticky’ sessions to TDS protocol tier LB Security Boundary TDS (tcp) Gateway: TDS protocol gateway, enforces AUTHN/AUTHZ policy; proxy to backend SQL Gateway Gateway Gateway Gateway Gateway Gateway SQL SQL SQL SQL SQL SQL TDS (tcp) Scalability and Availability: Fabric, Failover, Replication, and Load balancing

  7. The Journey So Far… Q2 Q1 Q3 Q4 Q1 Q2 PDC 2008 Initial CTP SQL Server Data Services July 2009 1st Production Deployment MS Internal Property Feb 2010 Commercial Availability Windows Azure Platform Post Launch New Countries New Service Updates New Data Centers PDC 2009 Service Launch Windows Azure Platform MIX 2009 Announce Relational Database as a Service 2009 2010 …On To The New Stuff!

  8. Rounding Out – Spatial Support • 2D Vector Data: • Geography – Round-Earth data • Geometry – Flat-Earth data • Support for Point, Line, Area (Polygon) objects • Over 70 T-SQL spatial methods • High-performance spatial indices • Spatial industry standard support • Symmetry w/ SQL Server 2008

  9. Growing Up – 50GB Database Support • Two SQL Azure Database SKUs: • Web Edition & Business Edition • Historically: size == SKU • Editions: independent size ceilings and increments for usage based billing You create a Web or Business Edition database You specify (or modify) MAXSIZE • Web: MAXSIZE = 1 GB| 5 GB • Business: MAXSIZE = 10 | 20 | … | 50 • This is the size we will not let you grow beyond You will only be charged for the actual (peak) size of your database (in any one day) Business Edition Up to 50 GB 10 GB increments Web Edition Up to 5 GB Either 1 GB or 5 GB

  10. Best Integration – Office 2010 & Other Tools PowerPivotfor SharePoint PowerPivot

  11. Upsizing an Access Database DEMO

  12. Broad Reach – OData Support (Labs) Open Data Protocol JSON ATOM PUB HTTP https://www.sqlazurelabs.com Sign up and send us your feedback!

  13. Interactive Management – SQL Web Management

  14. Management & AdministrationSQL Azure Database DEMO

  15. Getting Data Where You Need ItSQL Azure Data Sync Service • Benefits • Scale-out read or read/write • Geo replication of data • Edge network data distribution • Content delivery networks SQL Azure Sync Group SQL Azure SQL Azure

  16. SQL Azure Data Sync – Overview On-Premises Applications SQL Azure SQL Azure Data Sync Service http://sqlazurelabs.com Data Sync Sync Group SQL Azure SQL Azure SQL Azure Data Sync http://azure.com Remote Offices & Retail Stores Data Sync Offline-Capable Cached Mode Applications Data Sync

  17. SQL Azure Data Sync Service Liam Cavanagh Senior Program Manager – SQL Azure Data Sync DEMO

  18. Features Under Consideration FUTURES • Multiple DB collations • Operational Reporting • Business Intelligence/Analytics • Logical Back-up/Restore (incl. geo) • Full text support • Radical scale-up and scale-out • Service Tiers …and much, much more… We’re Just Getting Started!

  19. Summary • Well established, commercially available service • Symmetrical extension of the SQL Server data platform …unique capabilities integrated into an enterprise-class ecosystem • Great new features including: • Microsoft Office 2010 integration • New DB sizes and billing tiers • Spatial data support • Web-based logical data administration • Broad reach through industry-standard web protocols • Rich relational data synchronization capabilities

  20. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. Track Resources • Team Blog – http://blogs.msdn.com/sqlazure • MSDN Dev Center – http://msdn.microsoft.com/azure/sqlazure • SQL Azure Labs – http://www.sqlazurelabs.com • Follow us on Twitter - @sqlazure Windows Azure Platform Training Kit - http://bit.ly/dgvMv0

  21. Required Slide Speakers, please list the Breakout Sessions, Interactive Sessions, Labs and Demo Stations that are related to your session. Related Content • Breakout Sessions • DAT209 – What’s New in Microsoft SQL Azure • COS305 – Microsoft SQL Azure Development Best Practices • COS311 – Migrating Applications to Microsoft SQL Azure • Interactive Sessions • COS07-INT – Using SQL Azure as a Datahub to connect SQL Server and Silverlight clients • COS13-INT – Database Performance in a Multi-tenant Environment • Hands-on Labs • COS04–HOL – Introduction to Microsoft SQL Azure

  22. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. DAT Track Scratch 2 Win • Find the DAT Track Surface Table in the Yellow Section of the TLC • Try your luck to win a Zune HD • Simply scratch the game pieces on the DAT Track Surface Table and Match 3 Zune HDs to win

  23. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers http://microsoft.com/technet http://microsoft.com/msdn

  24. Required Slide Complete an evaluation on CommNet and enter to win!

  25. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

  26. © 2010 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.

  27. Required Slide

More Related