Avatar 🦄

Jess Pomfret

Database Engineer with a Passion for Automation

  1. Archives
  2. Buy the Book!
  3. Finding Data Friends
  4. Search
  5. Dark Mode

Archives

2023 2
2022 2
2021 17
2020 25
2019 23
More

Categories

powershell t-sql-tuesday dbatools personal dsc presenting azure dbachecks data-compression pester

Tags

powershell dbatools tsql2sday tsqltuesday dsc t-sql-tuesday presenting data-compression desired-state-configuration dbachecks
Featured image of post Collating index usage stats across Availability Group replicas
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.

Nov 16, 2021
3 minute read
Featured image of post T-SQL Tuesday #143: Short code examples
powershell t-sql-tuesday

T-SQL Tuesday #143: Short code examples

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

Oct 13, 2021
2 minute read
Featured image of post T-SQL Tuesday #141: Work/Life balance
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.

Aug 10, 2021
4 minute read
Featured image of post Searching Stored Procedures for a pattern made easy with dbatools
dbatools powershell

Searching Stored Procedures for a pattern made easy with dbatools

Using dbatools to find patterns within your database code.

May 25, 2021
5 minute read
Featured image of post Keeping track of Azure resources with tags – Part 3
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.

Mar 31, 2021
6 minute read
1 2 3 … 17
© 2018 - 2023 Jess Pomfret
Built with Hugo
Theme Stack designed by Jimmy