SQL Server 2005 has a lot of features and sometimes these additions are overlooked as a new way of configuring and managing your SQL Server environment.

One of these features is Peer to Peer  transactional replication.  In the past, people have used transactional replication for load balancing, to keep a read only version for reporting purposes or possibly for a failover solution.  Continue reading Peer to peer replication in SQL Server 2005 →