Xevents

Using Extended Events to determine the best batch size for deletes

Use Extended Events to easily measure the duration of queries with different batch sizes, so you can find the optimal.

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.