Powershell Triggers

Disable all Triggers on a Database

PowerShell snippet to disable all triggers on a database.

T-Sql-Tuesday

T-SQL Tuesday #117 – When Have You Used MOT Tables?

Spoiler alert: I haven't, but we look at a few of the restrictions that have been removed.

Dbatools Powershell

Aggregating Data with PowerShell

Using Group-Object to aggregate data with PowerShell.

Dsc Powershell

Desired State Configuration: Troubleshooting in Push Refresh Mode

Some details on how to troubleshoot DSC errors.

Dbatools Powershell

Getting OS and SQL Version information with dbatools

One of my favourite posts - use dbatools and ImportExcel to get an overview of what versions you have in your estate.