Avatar 🦄

Jess Pomfret

Database Engineer with a Passion for Automation

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

Archives

2025 5
2024 6
2023 4
2022 3
2021 17
More

Categories

Powershell Dbatools T-Sql-Tuesday Personal Dsc Presenting Azure Dbachecks Data-Compression Replication

Tags

Powershell Dbatools Tsql2sday Tsqltuesday Dsc T-Sql-Tuesday Presenting Data-Compression Desired-State-Configuration Azure
Featured image of post Find Databases where the T-Log is bigger than the data
T-SQL UsefulQueries

Find Databases where the T-Log is bigger than the data

A quick blog to share a useful query to find databases where the transaction log is bigger than the total data file sizes.

Jan 23, 2024
2 minute read
Featured image of post PSHTML Email Reports
Powershell Dbatools

PSHTML Email Reports

Using the PSHTML PowerShell module to send beautiful email reports, and of course dbatools to get the data from SQL Server

Nov 18, 2023
8 minute read
Featured image of post Foldable SQL Regions
T-SQL Azure-Data-Studio Vscode

Foldable SQL Regions

Using foldable regions in VSCode or Azure Data Studio to make our T-SQL easier to navigate.

Jun 09, 2023
3 minute read
Featured image of post Availability Group Error - Local Node is not part of quorum
Powershell AvailabilityGroup FailoverCluster

Availability Group Error - Local Node is not part of quorum

How to resolve 'The local node is not part of quorum and is therefore unable to process this operation' errors when your WSFC is setup and looks good.

Feb 12, 2023
3 minute read
Featured image of post Welcome to 2023
Personal Presenting

Welcome to 2023

This is a post that quickly recaps 2022 and introduces this new blog design and a few 2023 goals.

Jan 03, 2023
6 minute read
1 2 3 4 … 19
© 2018 - 2025 Jess Pomfret
Built with Hugo
Theme Stack designed by Jimmy