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 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
Featured image of post Run ActiveDirectory PowerShell commands against another domain
powershell

Run ActiveDirectory PowerShell commands against another domain

Active Directory groups are used all over our IT estates. They can be used to simplify managing SQL Server access as well as for other applications.

Jul 07, 2022
2 minute read
Featured image of post Log Shipping – Pre-stage database backups with dbatools
dbatools powershell

Log Shipping – Pre-stage database backups with dbatools

Log shipping is a SQL Server feature used for disaster-recovery where the transaction log backups are ‘shipped’ from your production instance to a secondary instance.

May 24, 2022
3 minute read
Featured image of post Using Extended Events to determine the best batch size for deletes
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.

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