by mheydt
18.
November 2009 02:45
>
SQL Azure Database
- Highly scaled out relational database as a service
- Accessible via TDS
- SOAP/REST/ADO.NET/EDM/HTTP/HTTPs
- On premise access via SSRS
Customer value props:
- Self provisioning and capacity on demand
- Symmetry with on promesis database
- Automatic high availability and fault-tolerance
- Automated DB maintenance
Provisioning:
- Account as zero or more servers, billing instrument
- Each server contains one or more database
- Metadata
- Unit of security
- Unit of geo-location
- Logical grouping of DBs
- Each database has standard objects: unit of consistency, users, tables, views, indices, etc..
Free period ends 2/1/2010
Future:
- Improve tools
- Improve operational model
- Improve application programming model
Saas:
- Mention of provisioning API's outside of the portal
- Template databases
- Metadata tracking
- Additional billing scenarios
Single unit for deployment and upgrades
Data Synch
Upgrade and downgrade options between SKU's
Read only databases
Scale out support:
- Today
- workload partitioning
- but cluster managmeent is difficult
- Scale out addressed today:
- high availability
- Zero admin
- No downtime
- Elastic resources
- Pay as you grow
- No friction provisioning
- Never run out of hardware
- Future
- More scale out
- Dynamic database splits
- Ability to merge databases
- Improved schema management across groups of databases
- Additional database size options
- multiple database connection management
- Support for fan-out query
- Recent requests from customers
- Profillers, DMVs
- Spatial data types
- Full text support
- Change tracking
- CLR
- BI
- Encryption
- WIF
3c8031cb-6916-45f3-9a40-3068f910c70e|0|.0
Tags:
Azure | Cloud