Transcript COS310: Microsoft SQL Azure Overview: Tools, Demos and

COS310
Single Logical
Database
Multiple Physical
Replicas
Replica 1
DB
Replica 2
Replica 3
http://msdn.microsoft.com/en-us/library/ff394102.aspx
http://blogs.msdn.com/b/bharry/archive/20
10/10/28/tfs-on-windows-azure-at-thepdc.aspx
SQL Azure
Database Services
2010 Q1
2010 Q2
2010 Q3
2010 Q4
• TSQL support
• Tooling Support (SSMS,
VS)
• High Availability
• Self-Management
• Elastic Scale-out
• Increased DB size to
50GB
• Spatial data
• MARS Support
• Developer &
management experience
improvements
(Support life-cycle of DB
deployment)
• Database copy
• QoS Enhancements
• New Integrated developer portal
integrated with Windows Azure
• Project “Houston” (Web-based
management tool)
Data Sync Service (CTP1)
• Cloud-to-cloud sync
Data Sync Service (CTP2)
• On premises/cloud spanning
Reporting CTP
Data
Market
DataMarket CTP
Data Market GA
• New partners, new
content
• OData and VS support
• Billing, Payouts
• Enhanced marketplace
• Publication Experience
Billing | Nina Hu | Sign Out
Windows Azure Platform
Save
Create
Discard
Add
De-activate
Remove
Data Sync Service
Unregister
Database
Sync Group
Manage Changes
Remove from
Sync Group
Sync Group Name: Sales Data
Status: Activated
(Edit Name)
Sync Groups
Last synced at 12:00pm, Feb 24 2011 | Next sync in 21 minutes
Sales Data
Customer Data
HR Data
Topology:
Table View
Sales_Europe
Europe | Online
1.3 GB/4GB
Databases
Cloud
Sales_Asia
Japan | Online
2.3 GB / 4GB
Click to add a
new SQL Azure
database
Conflict Resolution:
Last Writer Win
Sync Direction:
Bi-directional
Sync Schedule:
Wirgccmqxs
Sync Scope:
Sales_Cloud
Synced Tables:
HR_Cloud
Hub
On-Premises
Agent_NY
Sales_Cloud
North Center US | Online
1GB / 4GB
Column Name
ID
Cloud
On-Premises
Home
Agent_NY
Offline
Agent_LA
Online
Database
Every 30
Minutes
Edit Scope Setting
Customer
Synced Columns:
Sales_Data
Hosted Service, Storage,
Accounts and CDN
Configuration:
Name
State
Address
Phone
Filter Value
WA
Click to add a
new On-Premises
database
Data Synchronization
Reporting
Service Bus, Access
Control & Caching
Virtual Network
Sales_Data_NY
Unkown
Sales_Data_LA
Online
Take me back to the old portal | © 2010 Microsoft Corporation Privacy Statement Term of User | Feedback
Traffic Manager
Application
Application
Data Sync
Now Open! Federations Technology Preview Program
Nominations
http://blogs.msdn.com/cbiyikoglu/
MANAGED SERVICE
SCALE ON DEMAND
FASTER INNOVATION
Enterprise Readiness and
Manageability
Scalability and Performance
Higher level Services & Developer
Agility
Data Protection/Recovery
Scale-out with Federation
• Local Backup/PIT Restore: to recover from users/app
errors
• Geo Backup/Disaster Recovery from data
center/geographical disasters
• Scale to virtually unlimited size to host very large
databases across multiple servers
• Better support for multi-tenant applications with numerous
tenants
New Data Movement
Capabilities
• DB Import/Export of data and schema between SQL
Azure and SQL Server
• Migration support to SQL Azure from Sybase, in
addition to existing support for Access, MySQL, Oracle
Enhanced Management
Experiences
• Enhanced portal-based management
• Multiple DB administrators per subscription to support
enterprise scenarios
Scale-up & Scale-down
Databases
• Scale beyond 50GB, less than 1GB
Performance Predictability
• Reserve compute capacity with Resource SLA
Enhanced multi-tenancy support
• API level support for multiple DB server per subscription,
provisioning & de-provisioning
Rich Insights With Reporting
as a Service
• Ability to author rich reports, host in Azure and view
in on-premises or cloud apps
Spanning Apps With Sync
Service
•
Synchronize data between SQL Azure DBs and
between SQL Azure & SQL Server DBs
Rich Developer Experiences
•
•
•
•
Professional Devs: VS “Juneau”
Departmental Devs: VS LightSwitch
Java Devs: supported JDBC driver
International Devs: Localized Azure Portal
DataMarket Enhancements
• International Rollout
• Enhanced Content Management
• Integration with Denali, Office, CRM
DBI323 | Using Cloud (Microsoft SQL Azure) and PowerPivot to Deliver Data
and Self-Service BI at Microsoft
Tuesday, May 17 | 1:30 PM - 2:45 PM | Room: C208
DBI313 | Microsoft SQL Azure Advanced Administration: Backup, Restore and
Database Management Strategies for Cloud Databases
Tuesday, May 17 | 5:00 PM - 6:15 PM | Room: B407
DBI314 | Microsoft SQL Azure Performance Considerations and
Troubleshooting
Wednesday, May 18 | 1:30 PM - 2:45 PM | Room: B312
DBI375-INT | Microsoft SQL Azure: Performance and Connectivity Tuning and
Troubleshooting
Wednesday, May 18 | 3:15 PM - 4:30 PM | Room: B302
Blue Section
http://www.microsoft.com/cloud/
http://www.microsoft.com/privatecloud/
http://www.microsoft.com/windowsserver/
http://www.microsoft.com/windowsazure/
http://www.microsoft.com/systemcenter/
http://www.microsoft.com/forefront/
http://northamerica.msteched.com
www.microsoft.com/teched
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn