Use DBATools Powershell module for MigrationsHappy Thanksgiving! If you're not familiar with DBAtools.io I suggest you head over to the site and see what you're missing. The amount...
TriggersWhat is it? A trigger is almost like a command/function that executes automatically in response to another transaction that has executed....
Script to Kill Blocked ProcessesYou might be turning the gun on yourself if you ever have to implement this. Disclaimer: I would never suggest running this in a...
Powershell: Failover a SQL Service in a Failover ClusterIs this where clusters go when they die? A great way to test failover or to simply move disable a clustered SQL Service is to utilize...