Skip to content

Instantly share code, notes, and snippets.

View DaveFlynn's full-sized avatar

Dave Flynn DaveFlynn

View GitHub Profile
@DaveFlynn
DaveFlynn / Mark-CorruptedPackages-Absent.ps1
Created May 15, 2026 03:52
Fixes Windows Update error 0x80073701 by resetting stuck CBS package states (Staged / Resolve Pending) to Absent.
# WARNING:
# Directly modifies CBS package states in the registry.
# Tested on Windows Server 2022 for resolving Windows Update error 0x80073701.
# Reboot after running and retry Windows Update.
# Run at your own risk.
# Packages stuck in:
# 0x40 = Staged
# 0x50 = Resolve Pending
#
@DaveFlynn
DaveFlynn / functions.php
Last active July 21, 2025 05:45
Enhance Advanced Custom Fields (ACF) Relationship Search Field for WordPress
<?php
/**
* Enhance ACF Relationship field search to include title, a specific custom field, and publish date.
*
* Replace 'your_relationship_field_name' with the ACF field name you're targeting.
* Replace 'your_post_type' with the ACF CPT you are targeting.
* Replace 'custom_field_key' with the meta_key you want to search.
*/

About the Author


Dave Flynn

I build and fix things when the tooling gets in the way, and write about practical problems and how to deal with them.

Most recently, that means pulling apart AI-generated apps, inspecting their databases, and figuring out what’s actually going on in the data. If something looks right in the UI, I’ll usually go check the data anyway.

Recce is the data validation toolkit for data engineers and non-technical stakeholders to review and interpret data change together

Validate data modeling work, review data change, and work as a team to speed up the QA process on data project pull requests, and significantly reduce time-to-merge.

Find Out More

@DaveFlynn
DaveFlynn / impact-validation-checklist.md
Last active June 26, 2024 03:25
Data Impact Validation Checklist

Impact validations

  • The scope of impact as has been checked (no unintentional modifications)
  • I have validated my modeling change (Show examples of how data change expectation was validated)
  • I have checked for critical downstream models
  • I have checked the data integrity of critical models (and attached holistic check results)
  • I have spot checked rows from critical models against prod to ensure data consistency (examples attached)
@DaveFlynn
DaveFlynn / Makefile
Created June 13, 2024 07:28
Makefile boilerplate for dbt projects
include .env
export
# Phony targets
.PHONY: build seed test snapshot run debug clean help
# Environment variables
TARGET ?= $(TARGET)
PROFILE ?= $(PROFILE)
@DaveFlynn
DaveFlynn / mattermost-pr-analysis.md
Last active February 6, 2024 08:13
Mattermost PR Analysis by Even Wei
old new
# pr 1043 128
# closed pr 34 (3.6%) 16 (12.5%)
# merged pr 1009 112
# model changed 3455 366
avg model changed 3.42 3.27
max model changed 30 29
avg merge time (seconds) 44016 292329
avg commits 15.3 9.1

Read In the Pipeline for more articles from Dave

Dave is Senior Technical Advocate for Recce, the cross-env data validation tool for dbt data projects. To understand more about Recce, or for help getting set up, get in touch at one of the links below:

Recce is your data validation toolkit

Recce is a cross-environment data-modeling validation tool for dbt projects.

Validate your work and create an all signal, no noise PR comment by curating a list of validation checks to speed up the QA process on data project pull requests, and significantly reduce time-to-merge.

@DaveFlynn
DaveFlynn / data-project-pr-comment-template.md
Last active November 13, 2025 16:15
PR Comment Template for dbt Data Projects