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 7
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 Get a list of databases from named SQL Instances
Dbatools Powershell

Get a list of databases from named SQL Instances

Quick script to help you find databases on named SQL Instances.

Aug 18, 2020
1 minute read
Featured image of post Using Get-WinEvent to look into the past
Powershell

Using Get-WinEvent to look into the past

Troubleshooting incidents - use PowerShell and Get-WinEvent to help collect windows event logs.

Aug 04, 2020
4 minute read
Featured image of post Truncate all the Tables in a Database with PowerShell
Dbatools Powershell

Truncate all the Tables in a Database with PowerShell

Some scripts to help us truncate all the tables in a database

Jun 30, 2020
5 minute read
Featured image of post Using T-SQL to Aggregate Strings
T-SQL

Using T-SQL to Aggregate Strings

Sharing a really great T-SQL aggregate function that I had no idea existed.

Jun 23, 2020
2 minute read
T-Sql-Tuesday

T-SQL Tuesday #127 – Non SQL Tips & Tricks

A few tips and tricks for managing tabs when you're a tab hoarder...

Jun 09, 2020
3 minute read
1 … 9 10 11 … 20
© 2018 - 2025 Jess Pomfret
Built with Hugo
Theme Stack designed by Jimmy