A Load Balanced Federated Database Solution
If you have a very high load on your database, but no specifically massive tables you may want to look into a fully load balanced solution for your database. This solution falls somewhere between your normal replication solution, and a federation solution. It’s not truly a federation as no one table is spread across several […]
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 […]