ALL COVERED TOPICS

NoSQL Benchmarks NoSQL use cases NoSQL Videos NoSQL Hybrid Solutions NoSQL Presentations Big Data Hadoop MapReduce Pig Hive Flume Oozie Sqoop HDFS ZooKeeper Cascading Cascalog BigTable Cassandra HBase Hypertable Couchbase CouchDB MongoDB OrientDB RavenDB Jackrabbit Terrastore Amazon DynamoDB Redis Riak Project Voldemort Tokyo Cabinet Kyoto Cabinet memcached Amazon SimpleDB Datomic MemcacheDB M/DB GT.M Amazon Dynamo Dynomite Mnesia Yahoo! PNUTS/Sherpa Neo4j InfoGrid Sones GraphDB InfiniteGraph AllegroGraph MarkLogic Clustrix CouchDB Case Studies MongoDB Case Studies NoSQL at Adobe NoSQL at Facebook NoSQL at Twitter

NAVIGATE MAIN CATEGORIES

Close

SQL Azure: All content tagged as SQL Azure in NoSQL databases and polyglot persistence

SQL Azure Federation... Aka Sharding

One of the exciting new features in the just-released SQL Azure Q4 2011 Service Release is SQL Azure Federation. In a sentence, SQL Azure Federation enables building elastic and scalable database tiers.

We all know the benefits of sharding so why calling it differently? NIH?

Original title and link: SQL Azure Federation… Aka Sharding (NoSQL database©myNoSQL)

via: http://blogs.msdn.com/b/windowsazure/archive/2011/12/13/building-large-scale-elastic-database-tiers-with-sql-azure-introducing-federations.aspx


SQL Server and SQL Azure Comparison

SQL Azure provides relational database functionality as a utility service. Cloud-based database solutions such as SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead.

If you are ready for the cloud — keep in mind this is not an easy question as proved by Netflix cloud migration and Reddit’s experience, going from on-premise SQL Server to SQL Azure doesn’t seem to involve drawbacks.

But what I’m really curious about is how SQL Azure compares to Amazon RDS.

maol.ch

Original title and link: SQL Server and SQL Azure Comparison (NoSQL databases © myNoSQL)

via: http://social.technet.microsoft.com/wiki/contents/articles/comparing-sql-server-with-sql-azure.aspx


The NoSQL Gene in SQL Azure Federations

[SQL Azure] Federations bring great benefits of NoSQL model into SQL Azure where it is needed most. I have a special love for RDMSs after having worked on 2, Informix and SQL Server but I also have a great appreciation for NoSQL qualities after having worked on challenging web platforms. These web platforms need flexible app models with elasticity to handle unpredictable capacity requirements and needed the ability to deliver great computational capacity to handle peaks and at the same time deliver that with great economics. NoSQL does bring advantages in this space and I’d argue SQL Azure is inheriting some of these properties of NoSQL through federations.

The way I read it: “we’ve scaled SQL Server as much as we could. Now we need to look at how other scalable distributed systems are built to get us over the deadends we’ve hit”.

Original title and link: The NoSQL Gene in SQL Azure Federations (NoSQL databases © myNoSQL)

via: http://blogs.msdn.com/b/cbiyikoglu/archive/2011/03/03/nosql-genes-in-sql-azure-federations.aspx


Forrester report: SQL Azure Raises the Bar on Cloud Databases

Got the link to this Forrester report about SQL Azure (PDF) authored by Noel Yuhanna from the SQL Azure - The Year in Review:

Most customers stated that SQL Azure delivers a reliable cloud database platform to support various small to moderately sized applications as well as other data management requirements such as backup, disaster recovery, testing, and collaboration. Unlike other DBMS vendors such as IBM, Oracle, and Sybase that offer public cloud database largely using the Amazon Elastic Compute Cloud (Amazon EC2) platform, Microsoft SQL Azure is unique because of its multitenant architecture, which allows it to offer greater economies of scale and increased ease of use. […] Application developers and database administrators seeking a cloud database will find that SQL Azure offers a reliable and cost-effective platform to build and deploy small to moderately sized applications.

There are a couple of inconsistencies in the document, but the SQL Azure case studies section is worth reading.

Back to the fun part. In the pros section:

High availability at no extra effort or cost. […] In addition, SQL Azure automatically offers built-in server and storage redundancy, a data replication solution for built-in high availability, and transparent application failover to ensure minimal disruption.

The cons section:

Zero downtime availability. Although SQL Azure supports failover architecture should a database server fail, there is some downtime, ranging from a few seconds to minutes, associated with switching the application over to another server.

Back to pros:

Scale-out capacity growth via a sharded data platform. SQL Azure offers the ability to shard data into hundreds or even thousands of logical databases, which developers can use collectively for a given application.

and in the cons:

Automatic sharding of data for extreme scalability. SQL Azure does not automatically shard data into various partitions to scale across physical servers.

Just focus only on the three case studies included in the paper (PDF).

Markus ‘maol’ Perdrizat

Original title and link: Forrester report: SQL Azure Raises the Bar on Cloud Databases (NoSQL databases © myNoSQL)