1 / 10

SQL Azure

SQL Azure. Cloud Database Based on SQL Server 2012 Technologies. Gregory Leake Director Technical Marketing, SQL Azure Microsoft Corporation. MICROSOFT SQL AZURE . Information Platform as a Service. Managed Service. Scale on Demand. Faster Innovation.

Pat_Xavi
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 Cloud Database Based on SQL Server 2012 Technologies Gregory Leake Director Technical Marketing, SQL Azure Microsoft Corporation

  2. MICROSOFT SQL AZURE Information Platform as a Service Managed Service Scale on Demand Faster Innovation • Platform capabilities delivered as fully managed services • Easy provisioning and deployment • Auto high availability and fault tolerance • Reduced complexity, greater flexibility • Database as a utility with pay as you grow scaling • Platform optimized for multi-tenant solutions • Flexible scaling options to start small and scale out • Rely on business-ready SLAs and global datacenters • Build cloud-scale solutions using familiar skills and tools • Span on-premises and cloud with Data Sync • Deliver rich insight with SQL Azure Reporting

  3. Extending SQL Server to the Cloud Distributed “scale-out” database service Abstracts OS and hardware management Low-friction provisioning, multi-tenant Automatic high-availability and data replication Pay-as-you-go and commitment offers Enterprise-class “scale-up” data platform Multiple hardware platforms and deployment options Deploy as dedicated server in customer datacenter, VM or 3rd party Typically licensed per-server or per processor Symmetry with Traditional RDBMS Familiar T-SQL relational model Support existing code libraries and protocols Ecosystem of familiar development and management tools

  4. SQL Azure Database Single Logical Database Multiple PhysicalReplicas • Cloud relational database based on SQL Server engine • Use same tools, data access frameworks, T-SQL based language • Global datacenters • High Availability & Redundancy • Reads are completed at the primary • Writes are replicated to a quorum of secondaries Replica 1 Single Primary DB Replica 2 Multiple Secondaries Replica 3

  5. SQL Azure Federation Massive Scale Engage 10s or 100s of nodes within the SQL Azure cluster Best Economics Administrators can repartition applications based on workload No downtime is required for these repartitioning operations Simplified Development and Administration Robust programming & connectivity model for creating dynamic applications Native tooling support for managing federations and with online repartitioning operations Simplified Multi-tenant Database Tiers Multi-tenancy provides great efficiencies byincreasing density of tenants per database Applications don’t have to make a static decisionabout tenant placement

  6. Federated Database • 1 x 20 GB database = 1 Machine • 20 x 1 GB databases = 20 Machines

  7. SQL Azure Demonstration

  8. Next Steps • Take the Tour • Sign up for free trial subscription • Start building cloud applications today! • http://www.windowsazure.com/

  9. Further. Forward. Faster. • Learn moreVisit the Microsoft Virtual AcademyFree technical SQL Server training courses • Get moreDownload SQL Server 2012 Trial Software180-day evaluation of SQL Server 2012 • Do moreParticipate in virtual launch activities and collect points for prizesThe more points you earn, the bigger your prize could be

More Related