Main slider - Background

Transactional Replication and Stored Procedure Execution: Silver Bullet or Poison Pill?

Replication latency is usually the result of large transactions and the number of rows they insert into the distribution database. There's a way around that, though. A very dangerous way, it turns out.

Read
Main slider - Background

Where’s Drew, April 2017 Edition

April showers bring May presentations (and blog posts).

Read
Main slider - Background

Transparent Data Encryption and Replication: SQL Server’s Rear Window

You think your SQL Server data is encrypted? If you use replication, you might be in for a nasty surprise.

Read
Main slider - Background

Monitoring SQL Server Replication With Extended Events

It's 11 PM. Do you know what's going on your subscribers and distributors? Extended events can help you find out.

Read