Transcript Introduction to SQL Azure

From
Windows Azure
From Outside
Microsoft Datacenter
Application / Browser
App Code / Tools
From Outside
Microsoft Datacenter
& Windows Azure
App Code / Tools
SQL Azure
Data Sync
Windows
Azure
Microsoft
Datacenter
SQL Azure
Code Near
Microsoft
Datacenter
Windows
Azure
SQL Azure
SQL Azure
Code Far
Hybrid
Microsoft
Datacenter
!
Replica 1
DB
Replica 2
Replica 3
Replica 4
Apps use standard SQL client
libraries: ODBC, ADO.Net, PHP, …
Application
Internet
TDS (tcp)
Load balancer forwards ‘sticky’
sessions to TDS protocol tier
LB
TDS (tcp)
Gateway
Gateway
Gateway
Gateway
Gateway
Gateway
Gateway: TDS protocol gateway, enforces AUTHN/AUTHZ policy; proxy to backend SQL
TDS (tcp)
SQL
SQL
SQL
SQL
SQL
Scalability and Availability: Fabric, Failover, Replication, and Load balancing
SQL
Account
Server
Database
DBA role places more focus on logical management
Support existing and new forms of deployment
Security model is 100% compatible with on-premise SQL
Web Edition: 1 GB @ $9.99/month | 5 GB @ $49.95/month
Business Edition: Up to 50 GB @ $99.99/10 GB/month
10 GB @ $99.99 | 20 GB @ $199.98 | 30 GB @ $299.97 | 40 GB @ $399.96 | 50 GB @ $499.95
https://www.sqlazurelabs.com
Benefits
SQL
Azure
Sync
Group
SQL
Azure
SQL
Azure
• Scale-out read or
read/write
• Geo replication of data
• Edge network data
distribution