SQLAzure简介.ppt

1、Introduction to SQL Azure,Presenter Title Company,Session Objectives and Takeaways,Session Objectives: Get up to speed on SQL Azure Learn about the architecture and cloud specific features of SQL Azure Demonstration of some core features in action Takeaways: SQL Azure lets you innovate faster becaus

2、e its a managed service that lets you scale on demand SQL Azure is uniquely positioned as an ideal data platform for Windows Azure applications,Notes (hidden),This version of the deck was built for the Windows Azure Platform Training Workshop hosted Dec-2010 in Redmond WA by the DPE Platform Evangel

3、ism Team The content is up to date as of SQL Azure Service Update 5 which shipped 22-Oct-2010,SQL Azure DatabaseThe first and only true database as a service,Subtitle color,Scale On Demand,Innovate Faster,Managed Service,Database utility; pay as you grow Business-ready SLAs Enable multi-tenant solut

4、ions World-wide presence,Easy provisioning and deployment Auto high-availability and fault tolerance No need for server or VM administration,Build cloud-based database solutions on consistent relational model Leverage existing skills through existing ecosystem of developer and management tools,Appli

5、cation Topologies,From Windows Azure,From Outside Microsoft Datacenter,From Windows Azure proxy to backend SQL,Service Provisioning Model,Each account has zero or more logical servers Provisioned via a common portal Establishes a billing instrument Each logical server has one or more databases Conta

6、ins metadata about database User ID=userserver;Password=password;. Setup your firewall rules first!,Logical vs. Physical Administration,SQL Azure focus on logical administration Schema creation and management Query optimization Security management (Logins, Users, Roles) Service handles physical mana

7、gement Automatically provides 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,Deployment,Deploy via T-SQL scripts Support for SQL Server Data-Tier Applications (DAC) feature DACPAC is unit of deployment Clo

8、ud or on-premise is a deployment time choice Create Logical Server in same region as Windows Azure Affinity Group for code-near architecture,Support existing and new forms of deployment,Security Model,Uses regular SQL security model Authenticate logins, map to users and roles Authorize users and rol

9、es to SQL objects Support for standard SQL Auth logins Username + password,Security model is compatible with on-premise SQL,Deploying and Managing SQL Azure Databases with Visual Studio 2010 Data-tier Applications,Presenter Title Company,demo,SQL Azure Compatibility,Currently Supported,Tables, index

10、es and views Stored Procedures Triggers Constraints Table variables, session temp tables (#t) Spatial types, HierarchyId,Not Currently Supported,Data Types XML, Sparse Columns, Filestream Partitions Full-text indexes SQL-CLR,Tables require clustered indexes,Database Editions,Two SQL Azure Database S

11、KUs: Web ,Up to 50 GB 10 GB increments,Business Edition,1 GB or 5 GB,Web Edition,Summary,SQL Azure provides a highly available cloud database service. Managed Service Scale On Demand Innovate Faster, 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product

12、 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