Transcript David Robinson Senior Program Manager Microsoft DAT316 Liam Cavanagh Senior Program Manager Microsoft Building Applications with SQL Data Services and Windows Azure Session Agenda Introduction to SQL Data Services What.

David Robinson
Senior Program Manager
Microsoft
DAT316
Liam Cavanagh
Senior Program Manager
Microsoft
Building Applications with SQL Data Services
and Windows Azure
Session Agenda
Introduction to SQL Data Services
What is a Data Hub and What Problems Does it
Solve
SQL Data Services Architecture
SDS Application Architectures
Scaling out with SQL Data Services
Data Platform: Device to Cloud
RDBMS
Service
Protection
Mining
Sync
Load
Caching
Analysis Query
Integration
Backup
Reporting
Search
Model & policy based development and management
Type
Place
In
Memory
Multi
Dim
Relational
BLOB
XML
File
Azure Services Platform
The Microsoft Platform Stack
OS
Data
Application
Mobile
Desktop
Server
Cloud
Extending SQL Data Platform to Cloud
Symmetric Programming Model
Data Hub Aggregation
• Initial services – core RDBMS capabilities as a service (SDS), Data Sync
and Data Hub
• Future Offerings
• Additional data platform capabilities as a service: BI/DSS, DW
• New services: Reference Data, Secure Data Hub
• Enable new uses of data to deliver differentiated business value
Compatibility Goals
Support common application patterns
Logical based administration
Patterns work for SDS and SQL
Multi-tenancy considerations
Throttling and load balancing
Limits on DB size, duration of transaction, etc
V1: Address the needs of 95% or more web and
departmental application
Sample of SQL Compatibility
In Scope for 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
Service Provisioning Model
Each account has zero or more servers
Account
Azure wide, provisioned in a common portal
Billing instrument
Each server has one or more databases
Server
Contains metadata about the databases
Unit of authentication
Unit of Geo-location
Each database has standard SQL objects
Database
Unit of consistency
Contains users, tables, views, indices, etc…
Hello SQL Data Services
David Robinson
Senior Program Manager
Microsoft
Data Hub
“An aggregation of Enterprise, Partner, Desktop,
and Device data within SQL Data Services”
Windows Azure
Enterprise
On-premises
App
Azure App
SQL Data
Services
Enterprise
User
Management
Device
Management
Business
Logic / Rules
Device
Desktop
Sync
Gateway
Client App
Client App
Sync Client
Sync Client
Data Hub – Project “Huron”
Customer Segment
Small and medium sized businesses
Enterprise – rapid prototype
Both Microsoft (v1) and Non-Microsoft device (post v1)
Common Patterns
Mobile device access to corporate data
Business to business sharing
Secure digital data hub / partner extranets
Governmental data (searchable encryption)
Data Hub – Project “Huron”
Value Props
Lower operational expense and capital expenditure
Self-healing
Highly available
Out-of-the-box support for SQL Server and SQL Compact
Extensible to non-MS devices and data sources (post v1)
Data Sync Service
Analytical
Sync Framework
SDS Provider
TDS
SQL Data Services
Data Sync
Publish API
Subscribe API
Reporting
Online
Sync API
3rd party platforms
Sync
Service
Proxy
Client
Data
Provider
Client Library API
Sync
Framework
Windows
Desktops
&
Devices
Sync
Framework
Client Library API
Sync
Service
Proxy
Client
Data
Provider
3rd party
DB
Data Hub – Sync Services
Liam Cavanagh
Senior Program Manager
Microsoft
SQL Data Services Network Topology
Application
Applications use standard SQL
client libraries: ODBC,
OLEDB, ADO.Net, …
TDS (tcp:1433)
Load Balancer
Load balancer forwards ‘sticky’
sessions to TDS protocol tier
TDS (tcp: 1433)
Gateway
Gateway
Gateway
Gateway
Gateway
Gateway
TDS (tcp: 1433)
Data Node
Data Node
Data Node
Data Node
Data Node
Data Node
Scalability and Availability: Fabric, Failover, Replication and Load balancing
Performance Considerations
The distance your application travels to perform data
access will affect performance
SDS Application Architectures
SDS access from within MS Datacenter
(Azure compute – ADO.NET)
Browser
SDS access
from outside MS Datacenter
(On-premises – ADO.NET)
App Code
/ Tools
SOAP/REST
HTTP/S
Astoria/REST - EF
HTTP/S
App Code
(ASP.NET)
Windows Azure
T-SQL (TDS)
T-SQL (TDS)
SQL Data
Services
MS
Datacenter
SQL Data
Services
MS
Datacenter
Topology supported
for some apps
Code Far Applications
Data is typically located outside the firewall from
where your application runs
Design your application to handle latency
Pre-fetch as much data as possible to provide a rich
experience to your users
Cache data locally
Code Near Architecture
Application Code runs within the same network that
your data resides on
Windows Azure provides a scalable hosting and
compute platform for hosting your applications
SQL Data Services and Windows Azure provide a
“better together” experience
Scaling Out With SQL Data Services
How can I gain maximum performance from
my data tier?
What if my application has large data
storage requirements?
Scaling out with SQL Data Services addresses these requirements
An Example Scale Out Architecture
ASP.Net
Application
Partition
Aware
App Tier
Data
Partitions
“Shards”
Customer
123
Scaling out with SQL Data Services
David Robinson
Senior Program Manager
Microsoft
What Can I Do To Get Ready For SDS?
Download SQL Server Express today
Architect your applications for Scale Out
Consider where your data access will live
Watch for CTP Announcement Coming Soon!!!
What Did We Learn?
SDS data platform is real and in production
Built using SQL Server 2008 codebase
Delivery of rich relational database service – PDC ’09
Relational database is key capability of the Azure
platform
SDS design and architecture supports a wide range of
scenarios
Cloud Data Hub’s are a convenient place to consolidate
and share data
Release Plan
MIX ‘09
Mar 09
TechEd
Apr 09
Internal
Adoption
May 09
WWPC
Jun 09
Jul 09
Migration
Aug 09
SDS Invitation
CTP
Sep 09
PDC
Oct 09
Azure
Invitation CTP
Nov
09
Commercial
Availability
SDS Invitation CTP – On-board invitation-only customers + some current
Azure Invitation CTP – On-board early adopters onto the Azure platform
Commercial Availability with Windows Azure in 2009
Sign up for notification of our CTP
SQL Server Word of the Day
Wednesday, May 13
DATA
COMPRESSION
*Game cards may be picked up at the SQL Server booths in the TLC
SQL Server Community Resources
The Professional Association for SQL Server (PASS) is an independent,
not-for-profit association, dedicated to supporting, educating, and
promoting the Microsoft SQL Server community.
• Connect: Local Chapters, Special Interest Groups, Online Community
• Share: PASSPort Social Networking, Community Connection Event
• Learn: PASS Summit Annual Conference, Technical Articles, Webcasts
• More about the PASS organization www.sqlpass.org/
Become a FREE PASS Member: www.sqlpass.org/RegisterforSQLPASS.aspx
Learn more about the PASS organization www.sqlpass.org/
Additional Community Resources
SQL Server Community Center www.microsoft.com/sqlserver/2008/
en/us/community-center.aspx
TechNet Community for IT Professionals
http://technet.microsoft.com/en-us/sqlserver/bb671048.aspx
Developer Center
http://msdn.microsoft.com/en-us/sqlserver/bb671064.aspx
SQL Server 2008 Learning Portal
http://www.microsoft.com/learning/sql/2008/default.mspx
Additional Resources
•
•
SDS Team Blog: http://blogs.msdn.com/ssds
SDS Forum: http://social.msdn.microsoft.com/forums/enUS/ssdsgetstarted/threads/
External Resources
MSDN Dev Center: http://msdn.microsoft.com/enus/sqlserver/dataservices
SQL Server 2008 Business Value Calculator:
www.moresqlserver.com
Adventure Works Cycles
Small bicycle manufacturer
Experiencing a growth spurt
SQL 2005 Database hosted on premises
WPF on the desktop for employees
ASP.Net website for customers hosted on premises
Adventure Works Cycles v2
Microsoft Sync Services made it easy for us to move the DB
to the web
We now have a working Data Hub
Enforce data hub value prop 1
Enforce data hub value prop 2
Enforce data hub value prop 3
Adventure Works Cycles v3
Hosting our ASP.Net app in Windows Azure enable the code to
run near the database
Enforce SDS Azure value prop 1
Enforce SDS Azure value prop 2
Enforce SDS Azure value prop 3
Windows Azure and SDS
Blah, blah, blah
Value prop, value prop, value prop
Migrating
Adventure Works ASP.Net to Windows Azure
David Robinson
Senior Program Manager
Microsoft
Accessing SDS via HTTP/REST
Where did REST access in SDS go
Why
ADO.Net Data Services
ADO.Net DS Value Prop 1
ADO.Net DS Value Prop 2
ADO.Net DS Value Prop 3
ADO.Net DS Value Prop 4
ADO.Net DS Value Prop 5
Accessing SDS from ADO.Net Data Services
Liam Cavanagh
Senior Program Manager
Microsoft
David Robinson
Senior Program Manager
Microsoft
High Level Architecture
SQL Data Services Gateway Tier
Protocol
Parser
Protocol
Parser
Protocol
Parser
Protocol
Parser
Protocol
Parser
Protocol
Parser
Protocol
Parser
Management
Services
Management
Services
Management
Services
Management
Services
Management
Services
Management
Services
Management
Services
Partition
Services
Partition
Services
Partition
Services
Partition
Services
Partition
Services
Partition
Services
Partition
Services
SQL Data Services Back End
SQL Server
SQL Server
SQL Server
SQL Server
SQL Server
SQL Server
SQL Server
Distributed
Data Fabric
Distributed
Data Fabric
Distributed
Data Fabric
Distributed
Data Fabric
Distributed
Data Fabric
Distributed
Data Fabric
Distributed
Data Fabric
Mgmt.
Services
Mgmt.
Services
Mgmt.
Services
Mgmt.
Services
Mgmt.
Services
Mgmt.
Services
Mgmt.
Services
Addressing Latency With Windows Azure
Windows Azure is co-located in the same datacenter as
SQL Data Services
Windows Azure provides
Point 3
Resources
www.microsoft.com/teched
www.microsoft.com/learning
Sessions On-Demand & Community
Microsoft Certification & Training Resources
http://microsoft.com/technet
http://microsoft.com/msdn
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
Microsoft Certification and Training Resources
Complete an
evaluation on
CommNet and
enter to win!
© 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.