sql azure pass
DESCRIPTION
TRANSCRIPT
SQL Azure Database: Present and FutureMaor David-Purhttp://blog.maordavid.comMicrosoft Israel
Agenda
SQL Azure Overview Service Roadmap SQL Azure Database Future SQL Azure Future
Software plus Services
The Freedom of Choice
ON-PREMISES CLOUD SERVICES
Deployment Choice
Seamless Experience
SERV ICESSOFTWARE
Developer Tools
Programming Model
Application Services
Relational Database
Operating System
Applications “BPOS”
The Microsoft Platform
Announcing…
Scale-Out Elastic Computation Automated service management Storage at a massive scale
Compute StorageManagement
Windows Azure Data Centers
North Central
USA
South Central
USA
Northern Europe
Western Europe
Eastern Asia
Southeast Asia
2010
2010
2010
2010
Database
Business AnalyticsReporting Data Sync
The Power of the SQL Data Platform in the cloud
Leverages existing skills and rich tooling ecosystem
Enables database applications with new, “cloud” capabilities
SQL Data Platform as a Service – beyond hosting
Announcing beta availability…
Service Bus Connecting between services in the cloud Connecting the cloud to on premise resources Interoperability with other cloud environments as
well.
Access Control Authentication and Authorization for Cloud
Services
ServiceBus
AccessControl
SQL Azure Database
Customer Value Props
Self-provisioning and capacity on demand
Symmetry w/ on-premises database platform
Automatic high-availability and fault-tolerance
Automated DB maintenance (infrastructure)
Simple, flexible pricing – “pay as you grow”
MSDatacente
r
Windows Azure
Compute
Browser
SOAP/RESTHTTP/S
T-SQL (TDS)
App Code(ASP.NET)
SQL Server Report Server
(on-premises)
ADO.NET/REST - EDMHTTP/S
- AD Federation (LiveId /AppFabric AC)
SQL AzureDatabase
T-SQL (TDS)
Relational database service
• SQL Server technology foundation
• Highly symmetrical
• Highly scaled
• Highly secure
Database “as a Service” – beyond hosting
Highly scaled out relational database as a service
Database
SQL Azure Service Provisioning> Each account has zero or more servers
> Azure wide, provisioned in a common portal
> Billing instrument
> Each server has one or more databases> Contains metadata about the databases
> Unit of authentication and security
> Unit of Geo-location
> The server is a logical grouping of your DBs
> Each database has standard SQL objects> Unit of consistency
> Contains users, tables, views, indices, etc…
Account
Server
Database
SQL Azure Database
demo A view from tools & Portal
• South Central USA• North Central USA (Dec-2009)• Southeast Asia• North Europe
Additional sub-regions will be deployed in lock-
step with Windows Azure Platform
Timeline
Global Availabilit
y
Service Update
Service Update
Service Update
Rhythm
PDC 2009Ready for Go-Live
1/1/2010Start Billing
2/1/2010End Free Period
Service Update
Service Update
Service Update
Service Update
First half of the year
Second half of the year
Our goal is to provide the best end-to-end experience forenterprise departmental apps and SaaS ISV scenarios
Improve Tools• For Developers & Designers to build apps• For Administrators to manage the database lifecycle
SQL Azure Database: Future
Tools, Clients, Languages
Today With the existing SQL Server ecosystem we have a fantastic start for our V1 offering VS, SSMS, ADO.NET, ADO.NET Data Services, PHP,
Java…
But we are also making huge investments for the future
Our goal is to provide the best end-to-end experience forenterprise departmental apps and SaaS ISV scenarios
Improve Tools• For Developers & Designers to build apps• For Administrators to manage the database lifecycle
SQL Azure Database: Future
Improve the operational model for enterprise users and SaaS providers• Backups, integration with on-prem…
Database BackupsFailure Scenario Solution When Responsible
Party
HW and Media failures
Multiple replicas of all databases with automatic failover. System backups for additional protection
Today SQL Azure - Built-in to the base service
Customer application or administrator errors leading to data loss
Use BCP, SSIS or other custom tools to backup data Today Customer
Database clone to create on-demand, backups of databases in the local or remote SQL Azure region
• Cloning is done with transactional consistency
• When clone operation is complete the replica is accessible as a normal database
1H 2010
Customer
South Central US
abc.database.windows.net
Dev1Maste
r
xyz.database.windows.net
prod1Maste
r
CREATE DATABASE xyz.prod2clone AS CLONE OF xyz.prod2 CREATE DATABASE efg.prod2clone AS CLONE OF xyz.prod2
prod2cloneprod2clone
prod2cloneprod2clone
North Central US
efg.database.windows.net
DR1Maste
rprod2cloneprod2clone
CREATE DATABASE abc.prod2clone AS CLONE OF xyz.prod2
Database Clone
Prod2
Our goal is to provide the best end-to-end experience forenterprise departmental apps and SaaS ISV scenarios
Improve Tools• For Developers & Designers to build apps• For Administrators to manage the database lifecycle
SQL Azure Database: Future
Improve the operational model for enterprise users and SaaS providers• Backups, integration with on-prem…
Improve the application programming model• Simplify the building of highly scalable applications• Further improve symmetry with on-premises SQL Server
Scale-out Support - Today
Classic scale-out challenges addressed by SQL Azure:
Highly available service on top of commodity hardware Zero administration cost of cluster HW, OS and SW No downtime Access to elastic pool of resources Pay as you grow No-friction provisioning of databases Create databases without ever running out of HW
SQL Azure
Castellan
Castellan Venue
DB
Castellan Venue DB’s
Venue 1Partition(
s)
Castellan Venue
DB
Castellan Venue DB’s
Venue 2 Partition(
s)
Castellan Venue
DB
Castellan Venue DB’s
Venue N Partition(
s)
One application DB, many venue DB’s – each partitioned in to many parts (40+)
...
Azure Roles
http:// TicketDirect .* Dynamic Worker(tasks
uploaded as blobs)
Partitioner Worker
Azure StorageQueues for communication between clients and roles
-- - --- - -
-- - --- - -
Tables to record server & partition information
Blobs to store web and worker role resources
Client Applications
Castellan.old (VB6)
Castellan.Azure• Box Office sales• Ticket Printing • System Administration • Venue/Event Management• Partitioning
.Net Service Bus
WCF
On PremiseSQL Server
Castellan Venue
Distributed Cache Worker
MemCache
TicketDirect Architecture
More Scale-out Support
o Dynamic database splits
o Ability to merge databases
o Improved schema management across group of databases
o Additional database size options
G1 G2
G4
G7
G5
G8
G3
G6
G9 G10
Connecting On-Premises to the Cloud
Windows Azure Platform
Sync
On-Premises Applications
Sync
Why you need sync: Incremental changes Unreliable and/or slow network Conflict detection and resolution Topology flexibility
How to get sync: Build it yourself, but sync is not easy! Use Microsoft Sync Framework
Synchronization
Sync Framework
On-Premises Applications
Sync
SyncSync
Offline-Capable Cached ModeApplications
Sync
Sync
Sync
Sync
Browser Clients
Business-to-
Business
Windows Azure Platform
Summary
Database as a service
Lower TCO
Automatic High Availability
Automatic maintenance
Instantly scale up or down databases as needed
Metered by database
Secure database with familiar AuthN/AuthZ model
Mission-critical SQL Server foundation