Introduction to SQL Azure

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

By: Malikia (105 month(s) ago)

Excellent ... Could you please mail a copy of the ppt to imranmalik14@hotmail.com.. thanks

By: Heart_hacker (107 month(s) ago)

Very well Explained.......please mail me this on asifzbaig@gmail.com or tell me how to download it... plz plz plz.......

By: kaushiksripada (109 month(s) ago)

loved it... seriously...

By: sweetalidinesh (115 month(s) ago)

Could you please mail a copy of the ppt to dinesh_ca@hotmail.com

By: lauren799 (115 month(s) ago)

Requesting to download. Thank you.

See all

Presentation Transcript

The database in the cloud forAzure Services Platform, SQL Azure : 

The database in the cloud forAzure Services Platform, SQL Azure Ing. Eduardo Castro, PhD Comunidad Windows ecastro@grupoasesor.net http://ecastrom.blogspot.com

Session Objectives And Takeaways : 

Session Objectives And Takeaways Session Objectives: Provide “why”, “what”, and “how” around SQL Azure Help you to answer your customer’s Cloud questions Key Takeaways Microsoft will have a strong position in Cloud business software SQL Azure is different than SQL Server and hosted SQL Server SQL Azure will open up new scenarios and opportunities

Session Structure : 

Session Structure

What’s up with the Cloud? : 

What’s up with the Cloud?

What’s going on out there? : 

What’s going on out there? Cloud perception… Costs? New capabilities? Massively scalable computing? IaaS, PaaS, SaaS ??? Value chains being remade Private clouds? Interop & standards…

A Working Definition of Cloud Computing : 

A Working Definition of Cloud Computing Cloud computing is a model for enabling convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction. This cloud model promotes availability and is composed of five essential characteristics, three service models, and four deployment models. 6 NIST, Information Technology Laboratory

5 Essential Cloud Characteristics : 

7 5 Essential Cloud Characteristics On-demand self-service Broad network access Resource pooling Location independence Rapid elasticity Measured service NIST, Information Technology Laboratory

Business View : 

Business View

Microsoft, Cloud & “business software”… : 

Microsoft, Cloud & “business software”…

Platform dimensions : 

Platform dimensions Characteristics of Software Platforms

Cloud Success Factors : 

Cloud Success Factors Utility Computing Capability Technical capability Datacenter Innovation capability Application Pattern Capability Not just about the browser Multi-screen experience Platform, delivery & tooling Platform Ecosystem Work with ISVs, SIs, VARs & Businesses to get to Cloud

Challenges : 

Challenges Identity and Access Management Composition / Workflow 2PL  OCC  Sync  Workflow Trust Availability Performance Information protection Latency It matters Separating logical / physical administration

Microsoft Value Proposition : 

Microsoft Value Proposition Learning & Growth Internal Processes & Capabilities Partners Customers SaaS Experience (BPOS) IaaS Experience (Live) On-premises Software (OPS) to Services Learning w/ Partners SaaS influencing OPS & Services PaaSBuildout Extreme Scale Data Centers MSR PartnerEcosystem Hosters ISVs SIs VARs Existing BusinessProcesses Provide “Multi-screen”Experience Provider Of Choice Provider w/ Choice Billing as a Service ServiceComposition

What is “SQL Azure”? : 

What is “SQL Azure”?

The Azure Services PlaformAn illustration : 

The Azure Services PlaformAn illustration

Microsoft Azure Services : 

16 Microsoft Azure Services

SQL AzureA relational DB in the cloud : 

SQL Services .NET Services Windows Azure Live Services Applications Applications Others Windows Mobile Windows Vista/XP Windows Server SQL AzureA relational DB in the cloud Relational database as a service Highly available, automatically maintained Extension of the SQL Server Data Platform

Extending SQL Server Data Platform to the Cloud : 

Extending SQL Server Data Platform to the Cloud Database Data Sync Reference Data Reporting Business Intelligence Symmetric Programming Model Data Hub Aggregation Initial services – core RDBMS capabilities with SQL Azure Database, Data Sync Future Offerings Additional data platform capabilities: Reporting, BI New services: Reference Data

The New SQL Data Services : 

The New SQL Data Services Familiar SQL Server relational model Uses existing APIs & tools Built for the Cloud with availability and scale Accessible to all from PHP, Ruby, and Java Clear Feedback: “I want a database in the Cloud” Focus on combining the best features of SQL Server running at scale with low friction

The Evolution of SDS : 

The Evolution of SDS Evolves

Database : 

Database Relational database, provided as a service Highly symmetrical development and tooling experience (use TDS protocol and T-SQL) Highly scaled out, on commodity hardware Built on the SQL Server technology foundation Beyond “hosted database” High availability, DB provisioning, and DB management are provided by the service Pay for what you use

Customer Scenarios : 

Customer Scenarios

Service Provisioning Model : 

Service Provisioning Model Each account has a billing relationship with Microsoft owns one or more virtual servers Each server has one or more databases including virtual master each database limited in size one or more logins Each database has one or more SQL users Account Server Database Server=server1.data.database.windows.net Database=testDB Login=nigele[@server1] (maps to testuser)

Logical Databases (LDB) : 

Logical Databases (LDB) 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 SQL Instance SQL DB DB5 DB1 DB3 DB2 Machine 6 SQL Instance SQL DB DB1 DB6 DB2 DB3 Machine 4 SQL Instance SQL DB DB1 DB2 DB3 DB4 Machine 7 SQL Instance SQL DB DB4 DB5 DB1 DB7

Computing EvolutionTowards Shared Resources : 

Computing EvolutionTowards Shared Resources Time  Computer Disk Computer Memory Disk Memory Learning to share more resources over time. Things we used to want Exclusively are now a burden…

SQL Azure Compared To… : 

SQL Azure Compared To… Hosted SQL Server SQL Azure further separates physical and logical administration SQL Azure includes HA/DR SQL Azure will include other high level services in the future – e.g. BI, “Data Hub”, etc. SQL Server On Premises Separates logical/physical administration Provide DBMS “Utility” Ultimately  Write your app and deploy to: SQL Server, SQL Server Utility, SQL Azure, etc.

Sample of SQL Compatibility : 

Sample of SQL Compatibility Included in v1 Tables, indexes and views Stored Procedures Triggers Constraints Table variables, session temp tables (#t) … Out of Scope for v1 Distributed Transactions Distributed Query CLR Service Broker Spatial Physical server or catalog DDL and views

High Level Architecture : 

High Level Architecture SQL Data Services Gateway Tier SQL Data Services Back End

SQL Azure Network Topology : 

SQL Azure Network Topology Application Load Balancer TDS (tcp:1433) TDS (tcp: 1433) Applications use standard SQL client libraries: ODBC, ADO.Net, … Load balancer forwards ‘sticky’ sessions to TDS protocol tier Data Node Data Node Data Node Data Node Data Node Data Node Scalability and Availability: Fabric, Failover, Replication and Load balancing

SQL Azure Application Architectures : 

SQL Azure Application Architectures

SQL AzureUsing one or multiple databases : 

SQL Data Services SQL AzureUsing one or multiple databases

Scalability : 

Scalability Database max size 1 GB (Web Edition) 10 GB (Business Edition) 50 GB (Beta) SQL Azure scalability Application must build custom partition logic

Sharding : 

Sharding Scaling data between different databases SQL Azure dynamic database creation Partitioning schemas Vertical Horizontal Dynamic Random Based on ranges

Sharding : 

Sharding Customer 123

Sharding Schema : 

Sharding Schema

SQL Azure - Pros : 

SQL Azure - Pros Transactions within the platform are not charged Supports relational data & stored procedures etc. Supports ACID characteristics of transaction across multiple entities/tables (but not across databases)

SQL Azure - Considerations : 

SQL Azure - Considerations Doesn’t provide scalability out of the box and there is a hard limit of 50 GB per database instance. Application need to handle the partition logic Since application has to build custom partition logic might incur sizable efforts to build such functionality

SQL Azure Improvements : 

SQL Azure Improvements MARS (Multiple Active Results Sets), which simplifies the application design process ALTER rename process for symmetry in renaming databases Application and Multi-server management for Data-tier Applications which further streamlines application design and enables deployments of database applications directly from SQL Server 2008 R2 and Visual Studio 2010 to SQL Azure for database deployment flexibility SQL Azure implements Open Data Protocol

The Future : 

The Future Ultimately not about “here or there” Hybrid applications & scenarios Major scenario & application evolution over next 3-5 years Constrained by: Trust & Capabilities Policy based management & execution crucial Lot of noise/confusion over interop

Summary : 

Summary Key Takeaways Microsoft will have a strong position in Cloud business software SQL Azure is different than SQL Server and hosted SQL Server SQL Azure will open up new scenarios and opportunities Think about services / scenarios that have no “on-premises” equivalent

Links : 

Links http://comunidadwindows.org http://ecastrom.blogspot.com http://www.sqlazurelabs.com http://www.microsoft.com/windowsazure/ http://sql.azure.com/

Q&A : 

Q&A

authorStream Live Help