SQL Server 2005 Peer-to-Peer Replication (A peek inside Microsoft)

Peer to Peer Replication made its SQL Server debut in SQL Server 2005 and just got even stronger in 2008. I found an interesting article recently that talks about how MSFT uses peer-to-peer internally and thought I would share: http://www.microsoft.com/technet/technetmag/issues/2006/07/InsideMSFT/default.aspx. It talks about how Peer-to-Peer replication with SQL Server 2005 is used internally at Microsoft to implement a type of SQL Server load balancing.

An interesting read... Another good article is here: The Growing Importance of Peer to Peer Replication.

By the way, you might want to check out LearnItFirst's SQL Server 2005 replication training videos and SQL 2000 replication videos while you're here.