extend your application to the cloud with sql azure database

21

Upload: kyle-cressman

Post on 18-Jan-2015

2.357 views

Category:

Technology


6 download

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 applications

TRANSCRIPT

Page 1: Extend Your Application to the Cloud with SQL Azure Database
Page 2: Extend Your Application to the Cloud with SQL Azure Database

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

Page 3: Extend Your Application to the Cloud with SQL Azure Database

Enter to Win a Dell Inspiron Netbook

Page 4: Extend Your Application to the Cloud with SQL Azure Database

Extend Your Application to the Cloud with SQL Azure

Rick NegrinNiraj Nagrani

AP005

Page 5: Extend Your Application to the Cloud with SQL Azure Database

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

Page 6: Extend Your Application to the Cloud with SQL Azure Database

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

Page 7: Extend Your Application to the Cloud with SQL Azure Database

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

Page 8: Extend Your Application to the Cloud with SQL Azure Database

Pet-shop Using SQL Azure

Rick NegrinProgram ManagerMicrosoft Corporation

Demo

Page 9: Extend Your Application to the Cloud with SQL Azure Database

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

Page 10: Extend Your Application to the Cloud with SQL Azure Database

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

Page 11: Extend Your Application to the Cloud with SQL Azure Database

Jitendra Pal ThethiInfosysCarbon Footprint Calculator

partner

Page 12: Extend Your Application to the Cloud with SQL Azure Database

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 ….

Page 13: Extend Your Application to the Cloud with SQL Azure Database

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

Page 14: Extend Your Application to the Cloud with SQL Azure Database

Raheel RetiwallaClearwayGeoAnalyzer

partner

Page 15: Extend Your Application to the Cloud with SQL Azure Database

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

Page 16: Extend Your Application to the Cloud with SQL Azure Database

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

Page 17: Extend Your Application to the Cloud with SQL Azure Database

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

Page 18: Extend Your Application to the Cloud with SQL Azure Database

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

Page 19: Extend Your Application to the Cloud with SQL Azure Database

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

Page 20: Extend Your Application to the Cloud with SQL Azure Database

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

Page 21: Extend Your Application to the Cloud with SQL Azure Database

© 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.