Monday, December 12, 2011

SQL Azure new Capabilities and Benefits


Capabilities and Benefits of SQL Azure

No physical administration required

  • SQL Azure is a managed service - you do not have to install, patch or manage hardware or software.
  • There is no need for you to create virtual machines or manually manage high availability. Every SQL Azure database has built-in high-availability, failover, and redundancy.

Scale On-Demand

  • SQL Azure Federation gives you the flexibility to scale out depending on your needs while paying only for what you use.
  • You can rely on business-ready SLAs and global datacenters to offer highly available services to users.

Innovate faster

  • SQL Azure does not require new skillsets, programming models or tools - it works with the same SQL Server tools and APIs you use today.
  • Use an existing ecosystem of developer and management tools.
  • Enable new scenarios with services like Data Sync and Reporting to connect to mobile devices, HTML5 web applications, and location-aware services.
  • Consume or monetize premium datasets from commercial data providers and government sources with Windows Azure Marketplace.

Pricing and Metering for SQL Azure Database

SQL Azure supports a flexible subscription-based pricing model and supports both a pay-as-you-go and 6 month commitment offer. SQL Azure can be purchased independently or with other Windows Azure platform products. You can provision multiple SQL Azure databases for your application(s) and can use either the Web or Business Edition offering. A single Web Edition database can support up to 5 GB of data and uses billing increments of 1GB. A Business Edition database will support up to 150 GB, and uses 10 GB billing increments.


Web Edition (up to 5 GB) : $9.99 per 1 GB of database per month

Business Edition (up to 150 GB) : $99.99 per 10 GB of database per month  (Maximum charge of $499.95 per database)*

*This maximum amount is calculated based on the accumulated charges for each database you deploy over the entire billing month.

Customers are billed based on the peak database size in a day, rolled up to the next billing increment. SQL Azure Database is charged as a monthly fee for each database, but that database fee is amortized over the month and charged on a daily basis. This daily fee is dependent on which database type used (Web Edition or Business Edition). For example, if a customer utilizes three 10 GB Business Edition databases for 1 day in a billing month, their daily usage for that day would show a little less than 0.1 10 GB Business Edition database (3 databases / 31 days).
Visit to get in-depth information on SQL Azure and SQL Server for public and private cloud scenarios.


SQL Azure Federation

SQL Azure Federation is a core feature of SQL Azure that enables the database tier to be elastically scaled out across multiple nodes. This new feature makes it dramatically easier for you to set up an elastic database tier that can repartition based on application workloads. SQL Azure Federation provides you unlimited scale, great price-performance and simplified multi-tenancy for modern cloud applications.


Capabilities and Benefits of SQL Azure Federation

Unlimited Scalability

  • Federations enable horizontal partitioning or ‘sharding’ of data across many nodes to gain unlimited scalability in the application.

Elasticity for the best price-performance

  • The online repartitioning of the database tier combined with the pay-as-you-go model in SQL Azure enables administrators to easily optimize cost and performance by changing the number of databases/nodes they engage for their database workload at any given time.

Simplified multi-tenancy

  • With federations, applications can repartition to promote any tenant of a multi-tenant database to a single database node per tenant without incurring downtime for the reconfiguration.

SQL Azure Data Sync

Microsoft SQL Azure Data Sync is a cloud-based data synchronization service which provides uni-directional and bi-directional data sync. Data Sync allows data to be easily shared between SQL Azure and on-premises SQL Server databases, as well as between multiple SQL Azure databases.

Capabilities and Benefits of SQL Azure Data Sync

Managed service

  • There is no need to write complex database logic to synchronize and transfer data between databases.
  • Use the point-and-click portal to quickly configure and schedule synchronization.

Control synchronization

  • Specify exactly what tables and columns to synchronize, setup filters to sync only a subset of rows, set the conflict resolution policy for two-way sync, and specify how frequently data should be synchronized.

On-premises and cloud

  • Enables multiple synchronization scenarios spanning both cloud and on-premises databases.
  • Enable one-way as well as bi-directional data movement across SQL Azure and on-premises SQL Server databases.

Cloud-to-cloud synchronization

  • Data can be shared between multiple databases, irrespective of whether the databases are in the same data center or span multiple geographic regions.

No comments: