availability-groups dbatools powershell

Collating index usage stats across Availability Group replicas

A useful script to collate index usage stats across multiple AG replicas to help ensure you don't drop indexes that are unused on the primary, but vital on the secondary.

powershell t-sql-tuesday

T-SQL Tuesday #143: Short code examples

A quick code snippet to help find members of the local admin group.

t-sql-tuesday

T-SQL Tuesday #141: Work/Life balance

Managing work/life balance - something I'm not great at, but I have some tips.

dbatools powershell

Searching Stored Procedures for a pattern made easy with dbatools

Using dbatools to find patterns within your database code.

azure powershell

Keeping track of Azure resources with tags – Part 3

Part 3 in my Azure tags series. This time using Azure Functions to automatically tag resources with a DateCreated tag.