The full replication federation
Another type of database federation is what I call the full replication federation. This is where you place all the dimension tables (sticking with our data warehouse example from last time) on all servers of the federation. In addition to having the dimension tables on all the servers in the federation, we also allow all […]
Great Turnout At the San Diego SQL Server Users Group Last Night
I’d like to say thanks to the San Diego SQL Server Users Group for inviting me to speak last night. I had a great time speaking to the group, and just like last time the questions were all excellent. The slide deck for last night session on Federated Databases is now available. I believe that […]
The Pyramid Federation
There are several techniques which can be used to federate your database. The first of which, which we will be talking about is the Pyramid Federation (I have no idea if that what it’s actually called, but that what I’ve named it). In a pyramid federation we have a single server which holds the bulk […]
Scaling the database out, not up.
When your database has grown beyond the performance capabilities of a single SQL Server, there are still ways get increase the system performance. This requires using a technique called a Federating the database, this is also known as scaling the database out. Read on to learn more about Federated Databases.