Sign In
Your Data in the Cloud
Cihan Biyikoglu [twitter @cihangirb]
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Tags
data dependant routing
Database Size
fanout
fan-out
Federation directory
Federation key
Federation members
Federation Scheme
Federations
Horizontal Partitioning
Internet Scale
MapReduce
merge
Multi-tenancy
Multi-tenant
Partitioning
Performance
Scalability
Scale-out
Scale-Out Databases
Sharding
split
SQL Azure
Throttling
Web Scale
Archive
Archives
February 2012
(2)
January 2012
(4)
December 2011
(4)
November 2011
(3)
October 2011
(4)
August 2011
(2)
July 2011
(2)
June 2011
(1)
May 2011
(1)
April 2011
(3)
March 2011
(3)
January 2011
(1)
December 2010
(2)
November 2010
(2)
October 2010
(2)
September 2010
(1)
August 2010
(1)
July 2010
(1)
June 2010
(4)
May 2010
(1)
April 2010
(1)
March 2010
(1)
February 2010
(1)
January 2010
(1)
December 2009
(1)
March 2007
(1)
December 2006
(1)
November 2006
(1)
April 2006
(1)
March 2006
(1)
November 2005
(1)
October 2005
(1)
September 2005
(1)
June 2005
(1)
May 2005
(2)
April 2005
(2)
March 2005
(2)
February 2005
(1)
January 2005
(4)
MSDN Blogs
>
Your Data in the Cloud
Follow @cihangirb
Tweet #sqlfederations
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Your Data in the Cloud
Connection Pool Fragmentation: Use Federations and you won’t need to learn about these nasty problems that come with sharding!
Posted
1 day ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
Sharding has been around for a while and I have seen quite a few systems that utilize SQL Azure with 100s Databases and 100s of compute nodes and tweeted and written about them in the past. Like this case with Flavorus; Ticketing Company Scales to Sell...
Your Data in the Cloud
SQL Azure Migration Wizard: Fantastic tool for moving data to and from SQL Azure Federations
Posted
7 days ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
If you worked with federations, I am sure you are already know about the online tools like SQL Azure Management Portal that give you the ability to orchestrate your federations with repartitioning operations or resize member MAXSIZE and edition. In episode...
Your Data in the Cloud
PHP and Federations in SQL Azure - Sample Code from Brian
Posted
11 days ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
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
Your Data in the Cloud
How much overcapacity are you running with today? I bet SQL Azure Federations can trim that!
Posted
16 days ago
by
Cihan Biyikoglu - SQL Azure
2
Comments
I know I already posted a whole bunch on “ why use federations ” or “ what are federation for ” but most conversations on federations, I get the question on ‘why’? so I wanted to go back to basics and what the combination...
Your Data in the Cloud
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!
Posted
22 days ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
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...
Your Data in the Cloud
Accessing Federations in SQL Azure using Entity Framework
Posted
1 month ago
by
Cihan Biyikoglu - SQL Azure
4
Comments
Entity Framework is a popular these days in many web applications and I get EF support in federations question a few times a week these days… Here is a quick collection of of articles on the topic; This post just came out on the Entity Framework and Federations...
Your Data in the Cloud
Introduction to Fan-out Queries for Federations in SQL Azure (Part 1): Scalable Queries over Multiple Federation Members, MapReduce Style!
Posted
1 month ago
by
Cihan Biyikoglu - SQL Azure
1
Comments
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...
Your Data in the Cloud
…So Isn’t the Root Database a Bottleneck for Federations in SQL Azure?
Posted
1 month ago
by
Cihan Biyikoglu - SQL Azure
1
Comments
Dan posted a great comment to my previous blog post and I think the question he is raising is worth a blog post! Thanks for the question Dan! Here is Dan’s question: Dan - Tue, Dec 13 2011 11:57 AM Cihan, thanks for keeping us all posted all the way until...
Your Data in the Cloud
SQL Azure Federations is open for business!
Posted
1 month ago
by
Cihan Biyikoglu - SQL Azure
9
Comments
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...
Your Data in the Cloud
Pricing and Billing Model for Federations in SQL Azure Explained!
Posted
1 month ago
by
Cihan Biyikoglu - SQL Azure
9
Comments
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. In fact, sys.database in master...
Your Data in the Cloud
Federation Metadata in SQL Azure Part 3 – Monitoring Ongoing Federation Operations
Posted
2 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
In part 2 we talked about federation metadata history views. Federation history views only report operation that completed. For monitoring ongoing operations federations provide a separate set of dynamic management views under sys.dm_federation_operation...
Your Data in the Cloud
Great work Herve!
Posted
2 months ago
by
Cihan Biyikoglu - SQL Azure
1
Comments
Not sure if you all know Herve Roggero but he has been a great community leader and MVP driving scalable programming models for the cloud. Here is a quick video he and I recorded to thank him for all the work he put in on SQL Azure and especially on federations...
Your Data in the Cloud
Federation Metadata in SQL Azure Part 2 – History Tables
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
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...
Your Data in the Cloud
Federation Metadata in SQL Azure Part 1 – Federations and Federation Members
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
One of the great value propositions of federations is the ability to represent all the data distribution on the server side for both your schema (for example which parts of your schema you want to scale out and using what keys etc) and your runtime layout...
Your Data in the Cloud
Coming up at the end of the year in 2011 with SQL Azure...
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
Hi everyone, hope you enjoyed the keynote this morning on SQL Azure. You can watch the azure section of the keynote here at the 1:25:00 mark. You can also look at that great 3D pie chart over and over again! Had to put that in there! 5 mins taking you...
Your Data in the Cloud
New sample shows how to build multi-tenant apps with Federations in SQL Azure
Posted
4 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
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...
Your Data in the Cloud
SQL PASS in Oct, SQL Rally and SQL Server Days in Nov
Posted
4 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
Federations is on its way out the door with the next update of SQL Azure. With that, I’ll be on the road performing. Here is the schedule. Stop by, say hi and speak up to talk about your own “federation” stories! SQL PASS – Seattle, WA – Oct 11...
Your Data in the Cloud
Federations Migration Wizard Now Available!
Posted
5 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
One of the most popular tools for migrating your databases to SQL Azure is the SQL Azure Migration Assistant. Good friend George Huey finished off the extensions to it recently and now, it has a version of the tool that can help move large data into SQL...
Your Data in the Cloud
Quick Tip - Federations in SQL Azure: How to automatically maintain the federation distribution key in federated tables with FILTERING connections.
Posted
6 months ago
by
Cihan Biyikoglu - SQL Azure
5
Comments
In federations, federations member contain part of the data that is in a federation. The range of data contained in a federation member depends on the layout of the partitioning you have in your federations. There could be 10s or 100s of federation members...
Your Data in the Cloud
Strict vs Eventual Consistency Model - Referential Integrity with Federations in SQL Azure
Posted
6 months ago
by
Cihan Biyikoglu - SQL Azure
1
Comments
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...
Your Data in the Cloud
Shipping Software Fast and Scoping It Right: Story of Sharding to Federations-v1 in 12 months
Posted
7 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
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...
Your Data in the Cloud
ID Generation in Federations in SQL Azure: Identity, Sequences and GUIDs (Uniqueidentifier)
Posted
7 months ago
by
Cihan Biyikoglu - SQL Azure
1
Comments
This discussion came up today in the preview program aliases today and I wanted to summarize some of our thinking on the topic; Federations in SQL Azure provide the ability to setup a distributed database tier with many member databases. Scaling in distributed...
Your Data in the Cloud
Federations Product Evaluation Program Now Open for Nominations!
Posted
9 months ago
by
Cihan Biyikoglu - SQL Azure
2
Comments
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...
Your Data in the Cloud
Federation Repartitioning Operations: Database SPLIT in Action
Posted
9 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
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...
Your Data in the Cloud
Considerations When Building Database Schema with Federations in SQL Azure
Posted
9 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
When working with federations, database schema requires a special consideration. With federations, you take parts of your schema and scale it out. With each federation in the root database, a subset of objects are scaled-out. You may create multiple federations...
Page 1 of 3 (69 items)
1
2
3