Fan-out Querying for Federations in SQL Azure (Part 2): Scalable Fan-out Queries with TOP, ORDER BY, DISTINCT and Other Powerful Aggregates, MapReduce Style!

Welcome back. In the previous post: Introduction to Fan-out Querying, we covered the basics and defined the fragments that make up the fan-out query namely the member and summary queries. Fan-out querying refer to querying multiple members. We looked at queries examples in the previous post with member queries with no summary queries, that is…


Introduction to Fan-out Queries for Federations in SQL Azure (Part 1): Scalable Queries over Multiple Federation Members, MapReduce Style!

Happy 2012 to all of you! 2011 has been a great year. We now have federations live in production with SQL Azure. So lets chat about fanout querying. What is a fan-out query? Federations provide a model for partitioning parts of your schema over to multiple member databases for harnessing scalability of many nodes. However…


SQL Azure Federations is open for business!

Wooohooowwwy! Finally the day arrives! The year end update to SQL Azure is live and you can now use federations across all geographies of SQL Azure. There also a great new surprise we have been working on; we are making Federations available through open specification promise. OSP (open specification promise) is a promise not to…


Pricing and Billing Model for Federations in SQL Azure Explained!

Note: the article has been updated with the new pricing model that went into effect in Feb 2012. Now that Federations is live in production, lets talk about how the billing model works for federations. Good news is the model is very simple; With federations, every member can be considered a regular SQL Azure database….


Federation Repartitioning Operations: Database SPLIT in Action

Repartitioning operations is a large part of the value of federations. The ability to repartition databases enable elasticity in the database tier. With federations online repartitioning operations, database tiers can be made even stretch-ier. Scheduling downtime not required! So apps can expand and contract to engage larger of fewer nodes any time for the database…


TechEd 2011 (Video) – Introducing SQL Azure Federations: Big data and Big Scale…

Here is the session I did this week at Atlanta on SQL Azure Federations. SQL Azure Federations: Big Data, Big Scale… SQL Azure provides an information platform that you can easily provision, configure and use to power your cloud applications. In this session we explore the patterns and practices that help you develop and deploy…


Great New Whitepaper on SQL Azure and Sharding

Just out… This whitepaper summarizes the sharding technique and highlights the new application modeling best practices for best scalability and economics. Most importantly it focuses on how you can build sharded applications today on SQL Azure. http://social.technet.microsoft.com/wiki/contents/articles/sharding-with-sql-azure.aspx Happy reading…


Database Copy Command & Handling Asynchronous Execution in T-SQL

Database Copy T-SQL command in SQL Azure, provide the ability to create a identical copy of a database through a pure server side process. You can think of database copy as a backup followed by a restore of a database rolled into a single command. General documentation provides the details and use cases… Database Copy…


Power Tools for Migrating MySql Database from Amazon AWS – Relational Database Service (RDS) to SQL Azure – Part 2: Migrating Databases to SQL Azure

Migration Assistant team will be releasing a great power tool that can help you move your MySql databases directly into SQL Azure. The tool works against MySql instances hosted at Amazon’s Relational Database Service (RDS) as well. Here is a quick video that shows you how to move a database in Amazon AWS RDS service…


Pricing for the New Large SQL Azure Databases Explained

SQL Azure updated the pricing model in Feb 2012. With the recent update, this article no longer applies. Please refer to my new post for updated information; http://blogs.msdn.com/b/cbiyikoglu/archive/2012/02/16/the-new-pricing-model-for-sql-azure-explained.aspx Announcement at TechEd 2010 With TechEd 2010 in New Orleans this week, we announced the pricing structure for the large SQL Azure databases. The informational is available…