extend your application to the cloud with sql azure database
DESCRIPTION
AP005 Extend Your Application to the Cloud with SQL Azure Database Presenters: Rick Negrin Mon 7/13 | 3:30 PM-4:30 PM | 220-222 Learn how SQL Azure delivers on the promise of database-as-a-service in the Cloud. Check out how partners like Infosys and Clearway are building their LOB applications on SQL Azure. Explore the key value propositions of SQL Azure relational Database, its capability and targeted scenarios. The session demonstrates interoperability with Windows Azure. The symmetry of the programming model and tools between on-premises SQL Server and SQL Azure make it easy to port your existing applicationsTRANSCRIPT
Your Feedback is Very Important to Us
Or submit NOW on your Mobile Device at: http://www.mspartnerconference.com
Winners Every Hour!
$25 Conference
Store gift
certificate
Palm Treo
Pro Windows
Mobile Device!
Official Microsoft Gear: Bike Jerseys Bing Backpacks & Hats
Submit your Session Evaluation Online and Win! www.digitalwpc.com/evals
Enter to Win a Dell Inspiron Netbook
Extend Your Application to the Cloud with SQL Azure
Rick NegrinNiraj Nagrani
AP005
Key Takeaways – Why Should You Care About Azure
Grow revenue and increase segment reachFind new sources of revenue and increase marginsTraditional ISVs, Web VAPs, Custom software developers
Win New BusinessesQuick time to marketSaaS ISVs, CSDs
Focus on delivering more valueReduce infrastructure cost, eliminate provisioning, and physical administrationVAR/VAPs, SIs
Take advantage of your existing knowledge and developer tools
Customer Pain PointsManaging IT hardware and infrastructure and costs
Managing complexity in provisioning and administration
Meeting new business needs of the mobile workforce
Increasing competition drives needs for efficiency and reduced time to market
Extending SQL Server Data Platform to the Cloud
Database
Data SyncReference DataReporting Business
Intelligence
Symmetric Programming Model Data Hub Aggregation
Initial services – core RDBMS capabilities with SQL Azure Database, Data SyncFuture Offerings
Additional data platform capabilities: Reporting, BINew services: Reference Data
Pet-shop Using SQL Azure
Rick NegrinProgram ManagerMicrosoft Corporation
Demo
Customer Scenarios
Enterprise Departmental Applications
Departmental workgroup applications with low concurrency and cyclical usage patterns
Web Applications
Small customers or start ups with Web applications
of all scale that have simple RDBMS needs
Data Hubs
Data hubs that consolidate multiple data sources and enable access from multiple locations and
devices
ISV LOB Applications
Traditional ISVs extending offering or selling software hosted in the cloud
Benefits of SQL AzureDelivers the value of hosted relational database with the differentiated benefits of cloud service
Hosted RDBMS
Familiar relational model
Support existing code libraries and protocols
Ecosystem of familiar development and management tools
Cloud Service
Low-friction provisioning
High scale
Multi-tenant
Self-management
Automatic HA and DR
Jitendra Pal ThethiInfosysCarbon Footprint Calculator
partner
Infosys – Carbon Footprint Calculator
About the applicationOrganizations monitor and control carbon footprint based on their employees travel and energy consumption patterns
Challenges with existing applicationHave to be hosted on-premise at the customer data-center Lack of highly scalable relational storage
for large user populationLack of tenant separation among clients
SolutionASP.NET app hosted in Windows Azure and uses SQL Azure for data storageMulti-tenant model to keep customer data isolated
SQL Azure
TDS + TSQL
Carbon Footprint Calculator Web Application
Windows Azure
ADO.Net
HTTP
Mic
roso
ft D
ata
Cen
ter
App MetaData
Tenant Metadata
Org1
Cloud
Browser
Org 1
Browser
Org 2
Browser
Org 3
Org2
Org3 ….
Benefits of Using SQL Azure
Fully Azure hosted application – no infrastructure and management overhead for customerSQL Azure offers familiar relational SQL capability – existing app easily portedSQL Azure database can be easily provisioned per tenant with full isolation among themAchieve high scalability
Raheel RetiwallaClearwayGeoAnalyzer
partner
Clearway – GeoAnalyzer
About the applicationA location intelligence product that helps businesses visually analyze geographic data and filter it in many different ways inside Virtual Earth and SharePoint Online.
Challenges with existing applicationApplications hosted in SharePoint Online need a cloud based relational storeGeoAnalzyer currently uses SharePoint Online lists
SolutionStore geo-data in SQL AzureUse SQL Azure to build data-hub that enables reporting and analysis within SharePoint Online
SharePoint Online List
GeoAnalyzer
SharePoint Online Solution Today
GeoAnalyzer
SharePoint Online Solution with SQL Azure
SQL Azure
SSharePoint Online
SSharePoint Online
Benefits of Using SQL Azure
SQL Azure provides database capability in the Cloud
that enables LOB application to run in SharePoint OnlineEasy integration between SQL Azure and SharePoint OnlineSQL Azure offers familiar relational SQL capabilitySQL Azure allows Clearway to extend our applications to be consumed via any form (desktop gadget, SharePoint On premise, SharePoint Online, Mobile device)Allows Clearway to achieve fast time to market in getting our existing product portfolio to SharePoint Online
Roadmap
Invitation only CTP in AugustCommercial Availability with Windows Azure in 2009
MIX ‘09 TechEd WWPC
CTP1 CTP2 Commercial Availability
(V1)
Mar 09 May 09 Jul 09 Nov 09Sep 09Apr 09 Jun 09 Aug 09 Oct 09
PDC
InternalAdoption
Sign up for SQL Azure CTP! http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx
Key Takeaways – Why Should You CareThree ways to change your business with Azure services
Growing Revenue
Focus on the core application, delivering more value with less
Deliver More Value
Win New Business
Increase margins and find new sources of revenue
Build SaaS applications quickly to satisfy new and changing market needs
Recurring revenue streamsIncreases segment reachReduces administration costs
Benefits
Self-managed deploymentHigh Availability
Low cost of entry to marketQuick time to market
Benefits
Benefits
Take advantage of your existing knowledge and intellectual property
Leverage Your Existing Investment
Supports existing SQL protocolsTools support across on-premise and cloud
Benefits
SQL Azure Resources
Sign up for the Partner Quick start portal Sign up for the upcoming SQL Azure CTP (August 2009) hereGet more information about SQL Azure here including the latest news, feature developments and Whitepapers.FAQs hereForums, blogs hereVisit MSDN site
Comprehensive Resource to help you get started
Your Feedback is Very Important to Us
Or submit NOW on your Mobile Device at: http://www.mspartnerconference.com
Winners Every Hour!
$25 Conference
Store gift
certificate
Palm Treo
Pro Windows
Mobile Device!
Official Microsoft Gear: Bike Jerseys Bing Backpacks & Hats
Submit your Session Evaluation Online and Win! www.digitalwpc.com/evals
© 2009 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.