Browse by Tags

If you are a doctrine fan, now you can scale doctrine on Azure SQL DB with Federations. Details are published here; http://blogs.msdn.com/b/interoperability/archive/2012/06/29/doctrine-supports-sql-database-federations-for-massive-scalability-on-windows-azure.aspx -cihan

We have been working heads down on some new improvement to federations around disaster recovery and ease of working with a group of databases. We are ready to demo one key improvement we are building for federations to you at PASS 2012: the new SWITCH statement that make it easy to manipulate a group...

Finally, EF is open source and anyone can contribute. Many folks have been asking for EF to support federations. EF is the first to take this open source route in our data APIs and federations support is your chance to make your mark. You up for it? http://weblogs.asp.net/scottgu/archive/2012/07/19/entity...

Federations have been available for 6 months in SQL Azure (now called Windows Azure SQL Database) as of today! In this post, I’ll first cover few of the improvements we have made to the SQL Database Federations and talk about a few of the announcement we made at Teched this week on what’s...

I started programming on mainframes and all of us would have thoughts these mainframes would be gone by now. Today, mainframes are still around as well as many Windows XPs, Excel 2003s and many more Reporting Services 2008s out there. Doors aren't shut for these tools to talk to federations in SQL Azure...

Ambrish posted a great new article on the Windows Azure Team Blog on new functionality coming in SQL Server 2012 Management Studio for Federations. Here is the full writeup; http://blogs.msdn.com/b/windowsazure/archive/2012/02/15/managing-federations-in-sql-azure-with-the-sql-server-management-studio...

Brian has a tone of samples on PHP and Federations in this post right here... Another great one! http://blogs.msdn.com/b/silverlining/archive/2012/01/18/using-sql-azure-federations-via-php.aspx -cihan

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...

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...

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...

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...

In the previous post , I talked about how the federation metadata is formed to let you traverse the whole federation relationship within a database. In part 2 we will take a look at how you can basically go back in time to look at all the changes on federation metadata within the database with the federations...

Nice fresh sample from Full Scale180’s guys called Cloud Ninja. “The Cloud Ninja - SQL Azure Federations Project is a sample demonstrating the use of SQL Azure Federations in creating multi-tenant solutions. SQL Azure Federations can be a useful tool for migrating existing single tenant solutions to...

Referential Integrity in Federations Federation provide a great scale-out model with independent member databases. Even thought many local referential integrity rules are supported, federations place restrictions on costly referential integrity rules across federation members. Let me expand on that sentence;...

We first talked about SQL Azure Federation in Nov 2010 at PDC. We are getting ready to ship federations before the end of the calendar year 2011. It has been an amazing journey and with over a 100 customer in the federation technology preview program, we are fully charged. Thanks for a great deal of...

Recent Update: the program is at full capacity and nomination survey is now closed. Thank you for the great number of nominations. For questions about the program details, you can contact us at SAPESupport@Microsoft.Com. Microsoft SQL Azure Federations Product Evaluation Program nomination survey...

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...

In an earlier post I talked about how federations provide a robust connection model. I wanted to take a moment to drill into the great ability of the filtering connections and how it makes taking a classic on premise database model known as; single-tenant-per-database model to a fully dynamic multi-tenant...

In this post I wanted to focus on connectivity enhancements that come with SQL Azure Federations. SQL Azure Federation comes with a special FILTERING connection option that makes is safe to work with federated data and is critical for the fully-available-repartitioning component of federations. We’ll...

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...

In previous posts I talked about scaling options and techniques and introduced the concepts for SQL Azure federations. Let’s solidify the concepts with a few sample scenarios that showcase federations. Don’t expect an exhaustive list... I am sure you all can come up with many other examples of how to...

In the previous post , I described the rationale for scale-out vs scale-up. Explained why scale-out was the best thing after sliced bread and also why specifically sharding or horizontal partitioned wins as the best pattern in the world of scale-out. I also talked about the advantages of using SQL Azure...