SQL Server with Mr. Denny:

Scaling Out

1

September 25, 2008  11:00 AM

A Load Balanced Federated Database Solution



Posted by: Denny Cherry
Federated Database, Scaling Out

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

September 22, 2008  11:00 AM

The full replication federation



Posted by: Denny Cherry
Federated Database, Scaling Out

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


September 18, 2008  11:00 AM

The Pyramid Federation



Posted by: Denny Cherry
Federated Database, Scaling Out

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


September 15, 2008  11:00 AM

Scaling the database out, not up.



Posted by: Denny Cherry
Federated Database, Microsoft Cluster Service, Scaling Out

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


September 4, 2008  11:00 AM

Speaking about Federated Databases at the San Diego SQL Users Group



Posted by: Denny Cherry
Federated Database, In Person Events, Scaling Out

I've been asked to come back to the San Diego SQL Server Users Group on September 18, 2008.  This time around I'll be speaking about Federated Databases, and some various techniques which...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: