Tests and thoughts on asynchronous IO vs. multithreading

May 13th, 2013 19 Comments
Asynchronous I/O has been present in the .Net Framework from version 1.0, through the Begin/End methods, but it’s only in the recent years when it became a popular topic. There were probably two main reasons for that. One of them was the raise in popularity of node.js which has continuously advertised the event-driven, non-blocking IO … Continue reading

Choosing between Windows Azure SQL Database and Windows Azure VM hosted SQL Server

July 12th, 2012 0 Comments
Recently, Windows Azure has entered in the Infrastructure as a Service (IaaS) territory by announcing Windows Azure Virtual Machines (VMs), currently in public preview. Along with VMs came the possibility to host SQL Server databases directly inside Azure cloud. Previously, the only option for relational databases inside Windows Azure was represented by Windows Azure SQL … Continue reading

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 1 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 5 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

Performance vs. scalability

December 13th, 2011 0 Comments
With the growing interest over cloud computing in the last years, scalability has become one of the buzzwords of the day. However, with its increase in popularity, some of the confusions around it have also become more popular, probably the most common being the one according to which performance and scalability relate to the same … 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

New features in C# 4.0

August 3rd, 2011 1 Comments
With this post I will try to continue my series of articles dedicated to the new fetures added to C# in each of its new versions. As in the previous cases, I will not only try to provide an overview of the features, but also bring you up to speed with them. Dynamic types Every … Continue reading

Transaction log recovery in SQL Server

September 18th, 2010 0 Comments
How to use the transaction log of a database in order to perform a recovery operation, when is that possible, when should it be used and what are the advantages? In this post I will try to provide an answer to the above questions. Continue reading