SQL Merge Replication

A specific type of replication that is powerful for distributed environments is merge replication. The power of merge replication is that it enables multiple subscribers to update back to the publisher database. This means that you can have multiple replicas of the same database (or parts of it using filters) at different dispersed locations. These…


SQL Mirroring And Replication

Database Mirroring Database Mirroring between two SQL server instances is designed to have a mirror of your main database. The mirror server database is capable of handling all the database activities as the main server database in case of the main server’s failure. In a mirroring scenario, the main database server is called the principle…


Configuring Windows Network Load Balancing

Network Load Balancing (NLB) is commonly utilized with Web Applications and SharePoint deployments to load balance the web traffic across multiple servers and to increase the availability of the solution. The most common SharePoint 2007 deployment is the 5-server farm which includes 2 SharePoint Front End servers that are load balanced. Load balancing web servers…