PowerShell April 26, 2017 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 more 24466 2 0
Administration, Replication April 11, 2017 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 more 7778 3 0
Nonsense April 3, 2017 Where’s Drew, April 2017 Edition April showers bring May presentations (and blog posts). read more 2768 0
Replication March 15, 2017 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 more 9191 1 0
Administration, Replication March 8, 2017 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 more 7321 2 0
Nonsense, SQL Saturday March 6, 2017 Where’s Drew, March 2017 Edition Here's what I'm up to in March! read more 3574 0
Automation, PowerShell February 20, 2017 Updating Google Domains Dynamic DNS with PowerShell If you use Google Domains, you can use PowerShell to manage your Dynamic DNS entires and I'm going to show you how. read more 16658 1 5
Administration, PowerShell February 13, 2017 I contributed to dbatools, and you can too Want to learn how to contribute to an awesome community PowerShell project? It's easier than you think! read more 5552 2 0
Nonsense, PowerShell, SQL Saturday January 12, 2017 Where I’ll be: GroupBy, PASS PowerShell VC, and SQL Saturday Cleveland New year, new and exciting engagements! read more 3121 0
Administration January 9, 2017 DROP TABLE and replication in SQL Server 2016 SP1 and 2014 SP2 Are you constantly getting bitten by DROP TABLE statements throwing errors because an object is replicated? There's a solution. Sort of. read more 7908 3 0
