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
Amazon Relational Database Service
Backup
fanout
fan-out
Federated Tables
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
Web Scale
Archive
Archives
May 2012
(2)
April 2012
(2)
March 2012
(2)
February 2012
(10)
January 2012
(4)
December 2011
(4)
November 2011
(3)
October 2011
(4)
August 2011
(2)
July 2011
(2)
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)
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
Database Scaling Done Right!
Posted
10 days ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
FullScale 180 folks have a great post on windrows azure blog today. Trent’s post provides great insight into what it takes to building large scale database solutions and how sharding gets simplified with SQL Federations. Want to read more… Here is the...
Your Data in the Cloud
ID Generation in Federations in Azure SQL Database: Identity, Sequences, Timestamp and GUIDs (Uniqueidentifier)
Posted
18 days ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
Identity and timestamp are important pieces of functionality for many existing apps for generating IDs. Federation impose some restrictions on identity and timestamp and clearly we need alternatives for federations that can scale to the targets of scale...
Your Data in the Cloud
Scale-First Approach to Database Design with Federations: Part 2 – Annotating and Deploying Schema for Federations
Posted
1 month ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
In part 1, I focused on modeling your data for scale. That was the first step in the scale-first design process. Scale-first data modeling focuses on table groups that needs scale and federations and federation keys that help surround these table groups...
Your Data in the Cloud
AzureWatch for Monitoring Federated Databases in SQL Azure
Posted
1 month ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
AzureWatch has a great new experience now for watching Federations. With AzureWatch it gets easier to monitor the whole deployment in an aggregate view for the following resource dimensions; Database Size Number of open transactions Number of open connections...
Your Data in the Cloud
Inside SQL Azure – Self-healing, Self-governing, Massively Scalable Database service in the Cloud.
Posted
2 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
This is a talk I did a few weeks ago that will take you under the hood of SQL Azure. I cover the gateway to SQL Azure that manager billing, connectivity and some parts of T-SQL as well as Engine and surrounding services like load balancing and node governance...
Your Data in the Cloud
Countdown is over for SQL Server 2012… That means Scaling on-demand with Federations gets easier!
Posted
2 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
Today SQL Server 2012 is released to web and now we have a new set of bits that provide great enterprise class data management capabilities that stretches the boundaries of SQL Server to the public and private cloud. With SQL Server 2012, moving back...
Your Data in the Cloud
Scale-First Approach to Database Design with Federations: Part 1 – Picking Federations and Picking the Federation Key
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
1
Comments
Scale-first approach to database design refer to the approach used when designing data models that has scalability as their primary concern. To recap the purpose of federations I talk about 2 properties: unlimited scale and the best economics. These are...
Your Data in the Cloud
What would you like us to work on next?
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
4
Comments
10 weeks ago we shipped federations in SQL Azure and it is great to see the momentum grow. This week, I'll be spending time with our MVPs in Redmond and we have many events like this where we get together with many of you to talk about what you'd like...
Your Data in the Cloud
Teach the old dog new tricks: How to work with Federations in Legacy Tools and Utilities?
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
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...
Your Data in the Cloud
OData and Federations: yes you can… Just ask Maxim
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
In case you guys have not seen this; Maxim Glukhankov has a new sample on codeplex that shows how to set up OData on top of SQL Azure Federations. Just go under “Source Code” at the top and download! http://odatafederation.codeplex.com/ Not every tool...
Your Data in the Cloud
Implementing MERGE command using SQL Azure Migration Wizard by @gihuey
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
Well I am sure you noticed that federation’s support SPLIT AT and DROP AT commands but not MERGE AT yet today. What would this MERGE command do? It would do the symmetric opposite of SPLIT. SPLIT introduces a new split point into the federation. So MERGE...
Your Data in the Cloud
The New Pricing Model for SQL Azure Explained!
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
1
Comments
The new pricing model is an amazing improvement over the original model. In 60 seconds here are the 2 major improvements you will notice: #1 - New 100MB Option: Smaller databases has been a big ask. If you do not have a multi-tenant database tier,...
Your Data in the Cloud
Great new post on Federations in SQL Server Management Studio: Simplified development and management for the whole app lifecycle with Federations.
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
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...
Your Data in the Cloud
Want to demo federations to your boss? Here is the full package: Slides & the AdventureWorks database fully scaled-out with Federations
Posted
3 months ago
by
Cihan Biyikoglu - SQL Azure
0
Comments
What a great day! first there is some great news on SQL Azure pricing changes and now the AdventureWorks database is out with a new version for SQL Azure and it contains a flavor that is scaled-out with Federations. Thanks to Scott we now have a scalable...
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
3 months 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
4 months 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
4 months 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
4 months 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
4 months 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
4 months 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
5 months 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
5 months 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
5 months 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
5 months ago
by
Cihan Biyikoglu - SQL Azure
9
Comments
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...
Your Data in the Cloud
Federation Metadata in SQL Azure Part 3 – Monitoring Ongoing Federation Operations
Posted
6 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...
Page 1 of 4 (81 items)
1
2
3
4