Did you know that you can enable system-versioned temporal tables on something that's marked for replication, even though it isn't supported? Yeah, me either. Here's what happened, and how you can fix it. read more
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