Main slider - Background

Installing The SQL Server Module from the PowerShell Gallery

Say goodbye to needing SSMS to get the PowerShell module, and the required SMO libraries.

Read
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