logging in or signing up Introduction to SQL Azure ecastrom Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 662 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: May 07, 2010 This Presentation is Public Favorites: 1 Presentation Description No description available. Comments Posting comment... By: Malikia (12 month(s) ago) Excellent ... Could you please mail a copy of the ppt to imranmalik14@hotmail.com.. thanks Saving..... Post Reply Close Saving..... Edit Comment Close By: Heart_hacker (14 month(s) ago) Very well Explained.......please mail me this on asifzbaig@gmail.com or tell me how to download it... plz plz plz....... Saving..... Post Reply Close Saving..... Edit Comment Close By: kaushiksripada (16 month(s) ago) loved it... seriously... Saving..... Post Reply Close Saving..... Edit Comment Close By: sweetalidinesh (21 month(s) ago) Could you please mail a copy of the ppt to dinesh_ca@hotmail.com Saving..... Post Reply Close Saving..... Edit Comment Close By: lauren799 (22 month(s) ago) Requesting to download. Thank you. Saving..... Post Reply Close Saving..... Edit Comment Close loading.... See all Premium member 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 You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
Introduction to SQL Azure ecastrom Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 662 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: May 07, 2010 This Presentation is Public Favorites: 1 Presentation Description No description available. Comments Posting comment... By: Malikia (12 month(s) ago) Excellent ... Could you please mail a copy of the ppt to imranmalik14@hotmail.com.. thanks Saving..... Post Reply Close Saving..... Edit Comment Close By: Heart_hacker (14 month(s) ago) Very well Explained.......please mail me this on asifzbaig@gmail.com or tell me how to download it... plz plz plz....... Saving..... Post Reply Close Saving..... Edit Comment Close By: kaushiksripada (16 month(s) ago) loved it... seriously... Saving..... Post Reply Close Saving..... Edit Comment Close By: sweetalidinesh (21 month(s) ago) Could you please mail a copy of the ppt to dinesh_ca@hotmail.com Saving..... Post Reply Close Saving..... Edit Comment Close By: lauren799 (22 month(s) ago) Requesting to download. Thank you. Saving..... Post Reply Close Saving..... Edit Comment Close loading.... See all Premium member 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