DBI 210 Cloud and BI Overview Integrating cloud

DBI 210

Cloud and BI Overview Integrating cloud within BI BI services in the cloud

Provisioning, deploying and managing servers at scale Enabling faster and more efficient development of applications with existing knowledge and toolsets Infrastructure costs grow as a percentage of total IT spend

NEW ECONOMICS REDUCED MANAGEMENT INCREASED OPPORTUNITIES

Microsoft Information Platform HTML 5 and Nextgen Web Mobile and Client Devices Appliance “Denali” Data Sync Common Tools OData Rich Insight & Visualization

Questions to Consider Data Size Scale out vs Scale up App Dependencies Latency Requirements Data Sensitivity SLA Requirements Regulation & Compliance

Demo

General Purpose Programing Languages Windows Azure Platform Compute Storage Management CDN

Multiple Physical Replicas Replica 3 DB Replica 2 Replica 1 Single Logical Database Reads are completed at the primary Writes are replicated to a quorum of secondaries

Web Role Reporting o Interactive and tabular reporting o Data visualizations: charts, graphs, mapping, gauges

Demo

Simple distribution Developers IWs ISVs Information marketplace Easy discovery and sign up Data providers

Demo

• Connectivity to on-premises sources • Connectivity to other cloud LOBs and odata • SQL Azure Analysis • Office 365 Reporting and Analysis 17

microsoft. com/sqlserver

Connect. Share. Discuss. http: //northamerica. msteched. com Sessions On-Demand & Community Microsoft Certification & Training Resources www. microsoft. com/teched www. microsoft. com/learning Resources for IT Professionals Resources for Developers http: //microsoft. com/technet http: //microsoft. com/msdn

Scan the Tag to evaluate this session now on my. Tech • Ed Mobile

B 2 B Supply/Value chain collaboration using cloud information hub “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 SQL Azure

“The Windows Azure platform is uniquely well-suited to a ticketing business. Now we can achieve better elastic scale by turning on and turning off capacity at will and only paying for what we use. ” Chris Auld Director of Strategy and Innovation, Intergen

“Most cloud providers provide infrastructure as a service…Microsoft is truly unique in that they provide platform as a service ” Dominic O’Hanlan, Chief Strategy Officer, MYOB