1.       Open up IIS and right-click on the Web Sites node and go to Properties. Click on the Service tab. As shown in FIGURE 1

1.       Check  compress application files checkbox

2.       Check  compress static files checkbox

3.       Go to the Web Service Extensions node. Right-click in the right pane, and click Add a new Web service extension

5.       Click on Add. Choose C:\WINDOWS\system32\inetsrv\gzip.dll (your path may be different, but that is doubtful), and click OK. Check the Set extension status to Allowed check box, and click OK.

6.       Open up Windows Explorer and go to C:\Windows\System32\inetsrv. Find MetaBase.xml and make a copy (you can just highlight it and do a Ctrl-C, then a Ctrl-P to make a copy of MetaBase.xml). Now open up MetaBase.xml in a text editor.

7.        Find the <IIsCompressionScheme/> section. Be careful, there are two sections here: one for deflate and one for gzip. We want gzip so the Location attribute of the element will have the following value:   Location ="/LM/W3SVC/Filters/Compression/gzip"

9.       Final step is to do an IIS shutdown and restart by right-clicking in Internet Information Services node and then click All Tasks, Restart IIS. You can test at http://www.pipeboost.com, as shown in FIGURE 4.

SQL Server 2005 provides three main types of replication: snapshot, transactional, and Merge.
Publications and Articles
Articles: database object
Publication: SQL Server group’s articles from the same database in a unit called a publication.
Server Roles
You can configure a server as Publisher, Distributor, and/or Subscriber.

• The Publisher is the original owner of the information that is published.
• A Publisher is the only place where data can be modified.
  

The Distributor is responsible for managing the distribution database which stores replication status data, metadata, and, in some replication scenarios, the actual data that SQL Server replicates

A single database server instance can act as both the Publisher and the Distributor.

The server that then receives copies of the publication and provides the data to end users and applications is called the Subscriber.

Subscribers have a read-only copy of the database; in other configurations, you can update information in the Subscribers and replicate those changes back to the Publisher.

Push and Pull Subscriptions

With a push subscription, the Distributor copies the data to the Subscriber database. With a pull subscription, the Subscriber retrieves the data from the Distributor.

When your communication infrastructure has stable and permanent connections among replication servers, a push subscription offers the advantage of providing a central management point to all replication agents that manage the replication process. This results in less administrative overhead and easier troubleshooting procedures.

However, when the replication configuration includes many Subscribers, the distribution process for push subscriptions can tax the hardware resources of a Distributor.

Furthermore, servers or clients that connect on demand are better configured as pull subscriptions.

Replication Types

Snapshot replication the easiest replication type to understand because it is conceptually similar to a full backup and restore.

Transactional replication

It makes an initial complete copy of the data, and then all subsequent copies transfer modified data only.

Transactional replication uses the transaction log to apply to the destination data the same transactions performed on the source data. Because the same modifications are applied at both ends, the information is identical at the Publisher and the Subscriber.
This replication type is frequently used for transactional tables, such as an Order Details table in a retail database.

Merge replication

When your environment requires the ability to support simultaneous data modifications in the Publisher and Subscriber databases, merge replication offers a solution.

Replication Agents

SQL Server uses a group of programs called replication agents to execute the replication process.