USE FEDERATION statement gets improved performance

June 17th, 2012 0 Comments
During the presentation held at the 2012 TechEd event and later on his blog, Cihan Biyikoglu made the announcement that the Windows Azure SQL Database team (former Azure SQL team) has recently improved the latency of the USE FEDERATION statement. That was possible by implementing two layers of caching. The first layer is a connection … Continue reading

Backup strategies for Sql Azure Federations

March 26th, 2012 0 Comments
One of the greatest features of Sql Azure is the built in redundancy. For each Sql Azure database, besides the live instance, at any moment there are at least two replicas, one of them being transactionally consistent with the live one. This means that data stored in Sql Azure databases is pretty much bullet proof … Continue reading

SQL Azure prices drop for big DB sizes make federating more challenging

February 15th, 2012 0 Comments
Microsoft has recently announced a massive price drop for SQL Azure databases, which of course is a great thing. The new price rules are as follows: Database Size Price Per Database Per Month 0 to 100 MB Flat $4.995 Greater than 100 MB to 1 GB Flat $9.99 Greater than 1 GB to 10 GB … Continue reading

Benchmarking throughput and scalability on Sql Azure Federations

January 25th, 2012 0 Comments
Recently I have developed a benchmark for testing the number of queries per second that Sql Azure with its recently launched Federations feature can provide. In this article I will present the methodology I have used for benchmarking, the benchmark results as well as a few personal considerations. Purpose of the benchmark and disclaimer There … Continue reading

SQL Azure Federations – true scalability is almost here

December 7th, 2011 1 Comments
The Windows Azure platform has been with us for a few years now, providing the means to develop and deploy highly available and scalable applications. That being said, the delivered scalability was only half of what real life applications needed. Let me explain why. At the highest level, the server side of each application is … Continue reading