SQL Server and SQL Azure Hand-in-Hand: When and How to Extend Your Database to the Cloud?

1. SQL Server and SQL Azure Hand-in-Hand:When and How to Extend Your Database to the Cloud? Tara Seppa, CEE Application Platform Product Manager, Microsoft Luka Debeljak, CEE Windows Azure Product Manager, Microsoft

2. Agenda • Microsoft‘s Journey to the Cloud • SQL Server 2008 R2: What is it all about? • SQL Azure: Database in the Cloud • Key Scenarios For Extending Your Database to the Cloud • Extending SQL Server to the cloud: • SQL Data Synch, Moving your data to the Cloud • Virtual Network Functionality and Integration • Global availability and backup of your data • Business InteligenceIntegration • SQL Reporting On Premise and in the Cloud • What is PowerPivot all about? • Scaling Up vs Scaling Out: SQL Server vs SQL Azure • Summary

3. Too much focus on the basic management tasks Challenges Facing Today‘sIT • IT acts as a bottleneck: unable to respond to business requests in a timely manner • „Shadow IT“ increases IT management costs and puts the companies at risk

4. Cloud Impact REDUCED MANAGEMENT NEW ECONOMICS INCREASED OPPORTUNITIES • Pay for what you use • Lower and predictable costs • Shift from capex and opex • Accelerate speed to value No patching, maintenance Faster deployment Robust multi-layered security Reliability and fault-tolerance Latest software for users Internet collaboration Anywhere access Instant self-provisioning

5. Run Your Business, Not Your Infrastructure INFRASTRUCTURE PLATFORM SOFTWARE CUSTOMER & PARTNER APPS AS A SERVICE AS A SERVICE AS A SERVICE ITas a Service

6. The Microsoft Application Platform PC, Phone, Browser Your business applications alm and tools management tools Web Running on the Microsoft Application Platform Custom Packaged Applications Workflow On premises or in the cloud Composite Apps Application Server Enterprise Integration Middle Tier Reporting& Analysis Accessed by any client Data Warehousing Transaction Processing Database Managed by the same tools Identity & Access Security Networking One developer experience Infrastructure Virtualization On Premises Cloud

7. On Premises PC, Phone, Browser Cloud On Premises

8. In The Cloud PC, Phone, Browser On Premises Cloud

9. The Data Platform Scalable relational database platform Consistent, familiar model & tools Self-managed, highly available cloud services Managed Self-Service BI Multi-Server Management Virtualization & Live Migration

10. Agenda • Microsoft‘s Journey to the Cloud • SQL Server 2008 R2: What is it all about? • SQL Azure: Database in the Cloud • Key Scenarios For Extending Your Database to the Cloud • Extending SQL Server to the cloud: • SQL Data Synch, Moving your data to the Cloud • Virtual Network Functionality and Integration • Global availability and backup of your data • Business InteligenceIntegration • SQL Reporting On Premise and in the Cloud • What is PowerPivot all about? • Scaling Up vs Scaling Out: SQL Server vs SQL Azure • Summary

11. What’s New in SQL Server 2008 R2 • Business Intelligence: • Managed Self-Service Business Intelligence • PowerPivot for SharePoint (Project Gemini) • VertiPack • VertiScan • Data Visualizations in Reporting Services • Other Feature Areas: • Master Data Services • Stream Insight • Multi-server Management

12. Managed Self-Service BI with PowerPivot PowerPivotfor Excel PowerPivotfor SharePoint Analyzing Massive Data Volumes in Excel With a few mouse clicks, a user can create and publish intuitive and interactive self-service analysis solutions.

13. Master Data Management ROLE SECURITY VERSIONING WORKFLOW APPROVAL HIERARCHY MGMT Purchasing DB CRM HR Doc ERP Asset Mgmt

14. StreamInsight Platform from Microsoft for continuous and incremental processing of event streams from multiple sources based on declarative query and pattern specifications with low latency EVENT TARGETS EVENT SOURCES APPLICATION Pagers & Monitoring devices Devices, Sensors MSFT CEP Engine Input Adapters Output Adapters Web servers KPI Dashboards, SharePoint UI Event stores & Databases Trading stations Stock tickers & News feeds Event stores & Databases PLATFORM FOR KEY MARKET OPPORTUNITIES KEY SOLUTION REQUIREMENTS • Manufacturing: Process monitoring i.e. scheduling, control, inventory • Financial: algorithmic trading, compliance monitoring, fraud detection • Web: Click stream analysis ,ad-delivery model • Utility: Grid monitoring • Healthcare: Patient Monitoring • Networking: traffic monitoring ,security intrusion detection • Telecom: Network monitoring • Oil and Gas: Geological data analysis, process control • Event driven • Low latency processing (< milliseconds) • High volume (>100,000 events /second) • Correlated events from multiple sources • Time interval oriented standing queries

15. Agenda • Microsoft‘s Journey to the Cloud • SQL Server 2008 R2: What is it all about? • SQL Azure: Database in the Cloud • Key Scenarios For Extending Your Database to the Cloud • Extending SQL Server to the cloud: • SQL Data Synch, Moving your data to the Cloud • Virtual Network Functionality and Integration • Global availability and backup of your data • Business InteligenceIntegration • SQL Reporting On Premise and in the Cloud • What is PowerPivot all about? • Scaling Up vs Scaling Out: SQL Server vs SQL Azure • Summary

16. Introducing the Windows Azure Platform The Windows Azure platform is an internet-scale cloud services platform, hosted in Microsoft data centers around the world, that provides a simple,reliable, and powerfulplatform for creating web applications and services. • Developer Experience • Use existing skills and tools. Relational data Compute VMRole, Admin Access Storage Management CDN Connectivity Caching Access control Reporting Data Sync

17. Data and Storage Options in Azure SQL Azure Relational Database Structured Storage Unstructured Storage NTFS Drive Asynchronous Service Communication Windows Azure Tables Windows Azure Blobs Windows Azure Drive Windows Azure Queues

18. Microsoft SQL Azure Benefits Self-managed Elastic Scale Developer Agility Build cloud-based database solutions on a familiar relational model Build on existing developer skills and familiar Transact-SQL syntax Explore new data application patterns Easy provisioning and deployment Auto High availability and fault tolerant Self-managing and self-healing • Database as a utility with pay as you grow scaling • Rely on Business-ready SLAs • Enable multi-tenant solutions • Manage multiple servers

19. Extending SQL Server to the Cloud • Distributed “scale-out” database service • Abstracts OS and hardware management • Low-friction provisioning, multi-tenant • Automatic high-availability and data replication • Pay-as-you-go and commitment offers • Enterprise-class “scale-up” data platform • Multiple hardware platforms and deployment options • Deploy as dedicated server in customer datacenter, VM or 3rd party • Typically licensed per-server or per processor Symmetry with Traditional RDBMS • Familiar T-SQL relational model • Support existing code libraries and protocols • Ecosystem of familiar development and management tools

20. Provisioning Model Account • Each account has zero or more servers • Establishes a billing instrument • Each server has one or more databases • Logical concept equal to a master DB • Unit of authentication, geo-location, billing, reporting • Generated DNS-based name • Each database has standard SQL objects • Users, Tables, Views, Indices, etc • Unit of consistency Server Database

21. Architecture • SQL Server 2008 as core DB engine • 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 Machine 4 Machine 6 SQL Instance SQL Instance SQL Instance SQL DB SQL DB SQL DB UserDB1 UserDB1 UserDB1 UserDB2 UserDB2 UserDB2 UserDB3 UserDB3 UserDB3 UserDB4 UserDB4 UserDB4 Provisioning (databases, accounts, roles, …), Metering, and Billing Scalability and Availability: Fabric, Failover, Replication, and Load balancing

22. DEMOWindows Azure Portal & Solution

23. Agenda • Microsoft‘s Journey to the Cloud • SQL Server 2008 R2: What is it all about? • SQL Azure: Database in the Cloud • Key Scenarios For Extending Your Database to the Cloud • Extending SQL Server to the cloud: • SQL Data Synch, Moving your data to the Cloud • Virtual Network Functionality and Integration • Global availability and backup of your data • Business InteligenceIntegration • SQL Reporting On Premise and in the Cloud • What is PowerPivot all about? • Scaling Up vs Scaling Out: SQL Server vs SQL Azure • Summary

24. SQL Azure Scenarios • Cloud Hub Data Collaboration • Scale-out Enterprise Applications SQL Azure • Software as a Service Business Inteligence Departmental Applications

25. Extending Reach of data assets to facilitate greater collaboration between partners, branch officers, remote workers and mobile devices. Cloud Hub – Data Collaboration SQL Azure • Challenges Today • Extending data trapped within firewalls to partners and branch offices • Extending reach of data to new devices and applications • Organizational silos resulting in multiple copies of data • Consolidating and streamlining data for multi-party collaboration • SQL Azure Benefits • Secure and easy extension or consolidation of data into cloud • Ability to expose data from SQL Azure with existing frameworks • Data Sync keeps on-premises and cloud database synchronized • Scenario Cases • B2B Supply/Value chain collaboration using information hub • Easy data sharing to public and partners • Mobile applications and remote workers accessing data that is extended to the cloud GCommerce “Today, an end-to-end special order takes 15 seconds instead of 15 minutes, thanks to Windows Azure, SQL Azure, and the Virtual Inventory Cloud from GCommerce.” Steven Smith President and Chief Executive Officer GCommerce Associated Press “Capacity planning is the thing that stands out as the biggest advantage of the Microsoft cloud model. The Windows Azure platform takes that out of the equation for us, unlike the other cloud providers.”

26. Applications which use relational database in the cloud to benefit from easy provisioning and management, scale and reduced TCO Scale-out Enterprise Applications • Challenges Today • Efficiently utilizing resources for predictable business patterns • Difficult to roll out extra capacity quickly • Enable new solutions at scale without additional investment • SQL Azure Benefits • Fully managed, highly scalable, cloud-based relational database as a service with pay as you go model • Built-in high availability, fault tolerance and automated management (no VMs) • Ability to handle spikes in demand and scale up or scale down on demand Kelly Blue Book Using Windows Azure …. we will see $100,000 in savings each year—a number that will increase because we would normally continue to add servers to that data center as we grow. Andy Lapin Director of Enterprise Architecture, Kelley Blue Book • Scenarios • Enterprise building scalable web application in cloud to benefit from greater flexibility. • Enterprise uses cloud database to handle unpredictable variations in demand

27. Departmental Applications Streamline resources by consolidating existing departmental databases in the cloud and/or quickly provision databases in the cloud to meet departmental needs • Challenges Today • Data loss or compliance concerns due to data scattered across organization • Lack of agility in provisioning databases for departmental needs • SQL Azure Benefits • Self –managing, highly scalable relational database as a service built on SQL Server technology • Easy web-based provisioning and fully automated relational database as a service • Ability to connect from existing Access front-end applications to data stored in SQL Azure • Familiar programming model and tools to build, migrate and manage databases. • Scenario Cases • Migration/consolidation of data into a more managed cloud environment. • Allowing central IT to “upsize” data into more managed scalable cloud databases. • Departmental applications created to be quickly and efficiently provisioned. KRAFTKraft Foods evaluated options for flexible spend management of 350 departmental application portfolio based on usage.

28. Expand business opportunities and reach new markets by building SaaS applications quickly and efficiently Software-as-a-Service (SaaS applications) • Challenges Today • Geo-expansion and reaching new markets faster • Monetizing IP more effectively and expanding reach • Reliably and efficiently scaling to meet customer and business needs • Flexibility to pay as you grow without large upfront hardware investments • SQL Azure Benefits • Create multi-tenant service with easy scale up and scale down • Self-managed, highly available and fault tolerant service with a pay-as-you-go model • Familiar programming model and tools • Scenario Cases • Enhancing traditional on-premises deployments. • Building multi-tenant offering to scale and compete with more options to customers. • Enabling solutions to provide more options to customers and partners for different needs and deployment. ESRI “By freeing customers from having to make large hardware, software, and staffing investments up front, we’re helping lower the cost of GIS entry and increase the return on investment.” Arthur Haddad Development Lead and Architect, ESRI

29. Developing solutions providing new insight into business performance and processes through integration with existing data and/or 3rd party private and public data with familiar tools Business Intelligence • Customer Challenges • Quickly building solutions that enable analysis of internal and external information. • Integrate 3rd party data to provider deeper and richer analysis in a seamless manner. • SQL Azure Benefits • Native data connectivity from SQL Azure to Office. • Ability to combine data in SQL Azure with third party • Scenario Cases • An enterprise using data in SQL Azure and integrating with on-premises tools. • Multi-party solution provides opportunity for end-to-end visibility and analysis. • Enterprise leveraging SQL Azure BI to create reports and perform analysis over their data GCommerce “SQL Azure is a perfect solution for housing inventory data, in contrast with a traditional data warehouse model. We can post data to a common repository that has huge scalability and redundancy.” Jason Popillion Chief Technology Officer GCommerce

30. Database Migration to the Cloud • SQL Azure Data Sync Tool for SQL Server • SQL Server Migration Assistant • Moving any database to SQL Azure • SQL Server 200x, MySQL, Oracle, Access • SQL Server 2008 R2 • Management Studio: Generate Script Wizard • Integration Services • Data-Tier Application Component (DAC) Packages • „MSI for you database“ • SQL Azure supports deployment of DACs • Supported in Visual Studio 2010 • SQL Server Migration Wizard • Available on CodePlex Portal • …. Other 3rd party tools i.e. DBbest

31. DEMODatabase Migration Tools

32. Database Copy North Europe South Central US efg.database.windows.net xyz.database.windows.net DR1 Master Master prod1 Prod2 prod2 copy prod2 clone prod2 clone prod2 copy abc.database.windows.net Master Dev1 prod2 copy prod2 clone CREATE DATABASE efg.prod2clone AS COPY OF xyz.prod2 CREATE DATABASE xyz.prod2clone AS COPY OF xyz.prod2 CREATE DATABASE abc.prod2clone AS COPY OF xyz.prod2

33. SQL Azure Data Sync • Features: • Synchronization of data spanning on-premises with cloud and mobile scenarios • Manageability of data movement providing fine grained scheduling of data exchange • Data sub-setting allowing control of tables to be synchronized • Core scenarios: • Sync SQL Azure instances • Sync SQL Server to SQL Azure • Sync offline apps to SQL Azure • Enable geo-replication of data On-Premises Cloud Offline Clients

34. SQL Azure Data Sync – V1 Overview SQL Azure Database CTP1 Sync Sync Data Sync Service For SQL Azure Remote Offices Retail Stores Sync Sync Sync Sync Sync CTP2 On-Premises (Headquarters)

35. DEMOSQL Azure Data Sync

36. Windows Azure Connect • Secure network connectivity between on-premises and cloud • Supports standard IP protocols • Enables hybrid apps access to on-premises servers • Allows remote administration of Windows Azure apps • Simple setup and management • Integrated with WA Service Model • Web, Worker and VM Roles supported Windows Azure Enterprise

37. Agenda • Microsoft‘s Journey to the Cloud • SQL Server 2008 R2: What is it all about? • SQL Azure: Database in the Cloud • Key Scenarios For Extending Your Database to the Cloud • Extending SQL Server to the cloud: • SQL Data Synch, Moving your data to the Cloud • Virtual Network Functionality and Integration • Global availability and backup of your data • Business InteligenceIntegration • SQL Reporting On Premise and in the Cloud • What is PowerPivot all about? • Scaling Up vs Scaling Out: SQL Server vs SQL Azure • Summary

38. Business Intelligence as a ServiceEnabling intelligence from on-premise to the cloud • Native data connectivity from SQL Azure to Office • Ability to combine data in SQL Azure with third party Coming soon • Reporting Services (CTP 2010) Future • Analysis Services • Integration Services • Data cleansing service SQL Server Analysis Services (SSAS) SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS)

39. DEMOSQL Azure and PowerPivotProject „Crescent“

40. Agenda • Microsoft‘s Journey to the Cloud • SQL Server 2008 R2: What is it all about? • SQL Azure: Database in the Cloud • Key Scenarios For Extending Your Database to the Cloud • Extending SQL Server to the cloud: • SQL Data Synch, Moving your data to the Cloud • Virtual Network Functionality and Integration • Global availability and backup of your data • Business InteligenceIntegration • SQL Reporting On Premise and in the Cloud • What is PowerPivot all about? • Scaling Up vs Scaling Out: SQL Server vs SQL Azure • Summary

41. SQL Server 2008 R2 TRUSTED, SCALABLE PLATFORM IT & DEVELOPER EFFICIENCY MANAGED SELF-SERVICE BI Enterprise-level security, scalability High-scale, complex event processing Data consistency across heterogeneous systems Multi-server management Virtualization & Live Migration Accelerated development& deployment Self-service analytics Self-service reporting Streamlined collaboration& management COMPREHENSIVE PLATFORM FOR IT VALUE MPP support for 10s-100s TB DW Highly scalable appliances Seamless BI Integration Scalable relational database platform Consistent, familiar model & toolsSelf-managed, highly available cloud service