In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out one issue / bug we found with CU5.  Read more...

One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.  Read more...

Replication can be confusing to many new SQL Server DBAs and some of the optmizations are not well described in Books Online. SQL Server replication expert and trainer Andy Warren brings us a technique for initializing replication without a snapshot.  Read more...

Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.  Read more...

Continuing with his look at transactional replication, Andy Warren looks at the various delivery options with a detailed analysis of what happens under various configurations.   Read more...

Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean.   Read more...

There are some issues associated with managing identity columns with replication in your SQL Server database. As with previous releases of software, SQL Server 2005 requires that database administrators use special care when replicating tables with identity columns.  Read more...

How schema changes can propogate in SQL Server 2005's Replication Architecture.   Read more...

Robyn Page delves into all the things you need to know, rather than want to know, about SQL Server replication.  Read more...

SQL Server 2005 has changed replication dramatically and one of the changes is that subscriber tables have the identity column. SQL Server guru Andy Warren takes a look at what impact this has on transactional replication.   Read more...

Web synchronization in SQL 2005 enables highly secure synchronization of your merge subscriptions. This feature has been in high demand for many years, and Microsoft has finally delivered. This feature is difficult to deploy, however, so Hilary Cotter provides a tutorial on how to set up this complex feature.   Read more...

SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. SQL Server 2005 exposes some parameters through graphical interface that were available only from command line or through agent job steps in previous releases. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.   Read more...