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 more
It's 11 PM. Do you know what's going on your subscribers and distributors? Extended events can help you find out. read more
Want to learn how to contribute to an awesome community PowerShell project? It's easier than you think! read more
Are you constantly getting bitten by DROP TABLE statements throwing errors because an object is replicated? There's a solution. Sort of. read more
The Get-SQLErrorLog cmdlet is a nice addition to the SQL Server PowerShell module, but the tools team "mustn't be afraid to dream a little bigger, darling." read more
All you ever wanted to know about using DNS to manage per-database connections. Also, music! read more