Transcript Rick Negrin Lead PM Microsoft DAT 202 Agenda Setting Context Value Proposition and Scenarios Concepts and Architecture Demo Abilities Wrap up.

Rick Negrin
Lead PM
Microsoft
DAT 202
Agenda
Setting Context
Value Proposition and Scenarios
Concepts and Architecture
Demo
Abilities
Wrap up
Data Platform: Device to Cloud
RDBMS
Service
Protection
Mining
Sync
Load
Caching
Analysis Query
Integration
Backup
Reporting
Search
Model and policy based development and management
Type
Place
In
Memory
Multi
Dim
Relational
BLOB
XML
File
Azure Services Platform
Extending SQL Data Platform to Cloud
Symmetric Programming Model
Data Hub Aggregation
• Initial services – core RDBMS capabilities as a service SQL Data
Services(SDS), Data Sync
• Future Offerings
• Additional data platform capabilities as a service: BI/DSS, DW
• New services: Reference Data, Secure Data Hub
The New SQL Data Services
Clear Feedback: “I want a SQL database in the Cloud”
Familiar SQL Server relational model
Uses existing APIs & tools
Friction free provisioning and reduced
management
Built for the Cloud with availability and scale
Focus on combining the best features of SQL Server
running at scale with low friction
Database Choices
Value Props:
Value Props:
Roll-your-own HA/DR/scale
Dedicated
Resources
On-premise
Value Props:
Hosted
SDS
Shared
Low
“Friction”/Control
High
Scenarios for V1
Departmental Applications
Simple application built by individual or department
Need simple deployment, self-management, IT: “Empowerment and
Governance”
Web Applications
Small business or startup that uses the cloud as their IT
Simple deployment, self-management, scale on demand
ISV
ISV hosting software on behalf of customer
Multi-tenant support for billing and isolation
Data Hub (Shortly After V1)
Sharing and aggregating of data across tiers and across enterprises
Centralized place for data, high scale, sync with existing data sources
V1 Application Topologies
SDS access from within MS Datacenter
(Azure compute – ADO.NET)
Application/
Browser
SOAP/REST
HTTP/S
SDS access
from outside MS Datacenter
(On-premises – ADO.NET)
App Code
/ Tools
ADO.NET Data Svcs/REST - EF
HTTP/S
App Code
(ASP.NET)
Windows Azure
T-SQL (TDS)
T-SQL (TDS)
SQL Data
Services
MS
Datacenter
Code Near
SQL Data
Services
MS
Datacenter
Code Far
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 and usage
Unit of authentication
Unit of Geo-location
Generated DNS based name
Each database has standard SQL objects
Database
Unit of consistency
Unit of multi-tenancy
Contains Users, Tables, Views, Indices, etc.
Most granular unit of billing
Architecture
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
SDS Provisioning (databases, accounts, roles, …, Metering, and Billing
Machine 4
SQL Instance
User
DB1
SQL DB
User
DB2
User
DB3
User
DB4
User
DB1
Machine 5
Machine 6
SQL Instance
SQL Instance
SQL DB
User
DB2
User
DB3
User
DB4
User
DB1
SQL DB
User
DB2
User
DB3
User
DB4
Scalability
andFailover,
Availability:Replication,
Fabric, Failover,and
Replication,
and Load balancing
Scalability and Availability:
Fabric,
Load balancing
Programming Model
Small Data Sets
Use a single database
Same model as on premise SQL Server
Large Data Sets
Partition data across many databases
Use parallel fan-out queries to fetch the data
Application code must be partition aware in v1
For v1 will publish best practices for scale out
Post-v1 we are looking at building an abstraction to hide
some of the complexities of partitioning
SQL Tooling and Development
Compatibility Goals
Support common application patterns
Logical administration
Patterns work for SDS and SQL
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
Connection Model
Use existing client libraries
ADO.NET, ODBC, PHP
Client libraries pre-installed in Azure roles
Support for ASP.NET controls
Clients connect directly to a database
Cannot hop across DBs (no USE)
Logical vs. Physical Administration
SDS focus on logical administration
Schema creation and management
Query optimization
Security management (Logins, Users, Roles)
Service handles physical management
Automatically replicated with HA “out of box”
Transparent failover in case of failure
Load balancing of data to ensure SLA
DBA role places more focus on logical management
Deployment
Support for basic deployment options
SQL scripts work (but not attach database)
Geo-location of Windows Azure compute and
SDS data
Support for Application and multi-server
management model
Support for application packages
Cloud or on-premise is a deployment time choice
Visibility of data across on-premise and the cloud
Support existing and new forms of deployment
Security Model
Uses regular SQL security model
Authenticate logins, map to users and roles
Authorize users and roles to SQL objects
Limited to standard SQL Auth logins
Username + password
Future AD Federation, WLID, etc. as alternate
authentication protocols
Security model is 100% compatible with on-premise SQL
Platform Readiness (EHA)
Exchange Hosted Archive (EHA) is high scale
archival service
Runs on SDS infrastructure
In production prior to SDS v1
Rebuilt to address cost and scale issues
http://go.microsoft.com/fwlink/?LinkId=145374
Reduced COGS with increased customer and business benefit:
 Larger scale (e.g. larger customers ~20TB+ each)
 More self-managing (e.g. fault-tolerance)
 Better query performance for fan-out
 Faster provisioning of new customers
SQL Services
Opportunities and Futures
Partitioned databases
Geo-location and geo-redundancy
Distributed query
Security w/AD, WLID, etc
Support for multiple levels of hardware and
software isolation
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
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:
http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx
Nov 09
Commercial
Availability (V1)
Key Takeaways
Delivery of rich relational database service – PDC ’09
Integrated part of the SQL Data Platform
Key capability of the Azure platform
SQL Server Word of the Day
Monday, May 11
POLICY-BASED
MANAGEMENT
*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
Become
a FREE
PASSorganization
Member: www.sqlpass.org/RegisterforSQLPASS.aspx
• More
about
the PASS
www.sqlpass.org/
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
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.