Menu ☰ Français

Featured Posts Presentations Resources

Python Salesforce Admineloping

About Store / Hire

Salesforce, Python, SQL, & other ways to put your data where you need it

Search

💬 EN

Tweet Share on LinkedIn

Found An Answer?

(Unless I sent you here as one of my job duties to educate you. Then thanks for the thought but no gifts, please!)

Newsletter

Subscribe for TL;DRs

Blog Archive

2026 (21)

April (5)

Azure Managed DevOps Pools cross-contamination
I haven't had a desktop query tool in years
Music, bird brains and LLM math
Pyramid summaries for LLMs
Let LLMs remember what mutation testing is

March (7)

Checkmarx auth into ADO for Feedback Apps needs work
TeamPCP hack and your CI/CD pipelines
This blog has an identity crisis
Salesforce nostalgia as career development
Open Observability Summit 2026 conference talk
IBM FileNet P8 code modules remind me of Salesforce Apex classes and triggers
Reflection serialization for private internal SDKs

February (4)

Wins of the week
It's hypermobility all the way down
Find the Entra security groups a colleague is in
How to test if Ansible is installed

January (5)

Entra has too many OAuth2 Scope Global Consent Grant Options
My Huong Kitchen shoutout
Tech folks, plan for ICE detainment with your friends
Granting OAuth2 AuthZ in Entra
Validate networking lines of sight

2025 (26)

December (4)

Parameterization best practices with Azure Data Factory
OIDC issuers: passwordless isn't trustless
Make automated software test results visible
Browser-based test automation: collaboration tips

November (6)

Microsoft-hosted public CI/CD runtimes
Adding Vitest and Playwright tests to Astro
Vendor support shapes how we learn IaC
Licensing E2E Testing Frameworks
Choosing Terraform vs. Ansible
Azure Blob Storage SAS reasoning via PowerShell Pester

October (4)

Censoring secrets from logs in infrastructure as code
Test-driven development for infrastructure as code
Infrastructure as code tool types
Notes from Designing Content Authoring Experiences

August (3)

Look, ma, I'm a language teacher!
LLM-assisted requirements analysis and scoping
E2E and Synthetic Testing Considered Harmful

July (2)

Frontend automated testing demystifier
Can usability testing be automated?

June (3)

What's the deal with IBM WebSphere Application Server?
Why use Ansible for infrastructure as code?
Windows Firewall and BrowserStack Local

May (1)

Securing authenticated agentic AI

March (2)

I don't use Python much anymore
Azure Managed DevOps Pools make life easier

February (1)

Buy then build

2024 (10)

December (2)

Use Git in the browser if you can
Configuring multiple Git accounts on my computer

November (2)

Add the Sitecore CLI to the Windows Software Center
Where are Sitecore's paper plates?

October (1)

Front of the frontend web development

May (1)

Low-Code Generation Z

February (4)

Entra RBAC Role Assignment FAQ
Azure RBAC Role Assignment FAQ
Entra App Registration FAQ
Entra/Azure System-Assigned Managed Identity FAQ

2023 (24)

December (3)

Code Review: My first Powershell function
Trunk-based Git branching
What is Azure DevOps?

October (1)

How many Entra App Registrations do I need?

August (1)

Variables and secrets for CI/CD pipelines

May (4)

Git best practices with Azure Data Factory
Reuse your Flows with Subflow
Quick -- I need a blank scratch org
Azure DevOps vs. GitHub repositories and pipelines

March (12)

Deploying a built webapp onto Azure App Service with ADO Release Pipelines
Provisioning Azure DevOps Service Connections that let ADO Release Pipelines leverage Azure AD Service Principals for sensitive CI/CD tasks
Provisioning Azure AD Service Principals that can deploy built webapps onto your Azure App Service resources
Provisioning Azure App Services to host your Hello World webapp
Provisioning an Azure Resource Group
Logging your command line into Azure
Failing Azure DevOps Pipeline builds if unit tests fail
Making Azure DevOps Pipelines build a Hello World webapp from Git-tracked source code changes
Protecting Git branches in Azure DevOps repositories
Locally unit-testing source code for a Node.js Hello World webapp
Source code that builds locally into a Node.js Hello World webapp
CI/CD get-to-know-you questions

February (3)

Running UI tests in GitHub Actions
Azure Static Web Apps minimum viable build
I'm a DevOp!

2022 (40)

December (2)

What is Salesforce Flow?
Our sales rep territories

November (6)

DevOps vs. ITSM Maturity
Should CI testing always be automated?
Securing CI/CD pipelines
Use Subflow EVERYWHERE
SFDX and Git exercises for beginners
Git and GitHub exercises for beginners

October (1)

Jitterbit: replace a non-breaking space

September (6)

CumulusCI Minimum Viable Build
Download your org schema with CumulusCI
Compare Flow versions in VSCode for Salesforce
Multiple Pardot accounts sending from the same domain
Jitterbit: backfill Salesforce ID into a database
Find and replace Pardot PML with HML

August (9)

Save button missing in Pardot Marketing Data Sharing Rules
Formula Fields work fine for Pardot Marketing Data Sharing Rules
Pardot Opportunities need Contact Roles to sync
Prevent Pardot from syncing Leads
Block all Pardot syncing with Marketing Data Sharing Rules
Can eProcurement reach Banner?
Jaggaer - Banner Sync Series
Transforming CommonApp into Salesforce EASY question responses
UNPIVOT to key-value pair in Oracle SQL

July (2)

Cover letter workshop - WITness Success / Minnebar
Welcome to Minneapolis, Salesforce!

June (2)

Skyvia test - Salesforce to database
Enterprise application diary

May (2)

Pulumi & AWS minimum viable build
SSH or SFTP into a Linux server from a Windows machine with key-based authentication

April (2)

Find a library job with Python
Check a URL with Selenium IDE

March (1)

Loop through Trigger.new all you want

February (2)

Cover Letter Examples
Cover Letter Flowchart

January (5)

SFTP and SSH authentication patterns
Connect to a database from Windows
Read an NDJSON file with anonymous PL/SQL
SvelteKit Minimum Viable Build
Salesforce Apex lets you use external IDs

2021 (56)

December (1)

How I set up VSCode for a new Salesforce project

November (1)

Localhost HTML with Python on Windows

October (3)

WCOnline API explainer
How I added Algolia search: front-end
Inspecting an existing 11ty project

September (5)

Document Salesforce TDTM to avoid dev-admin handoff issues
Customizing Sanity Studio beyond the schema
But WHY do you need a database?
Jekyll doesn't do components? Liar!
Naomi Kritzer will be blogging some Minnesota 2021 candidates again

August (5)

Learn static site generation with Stackbit
A dumb Python mistake
Next.js Minimum Viable Build
ETL QA is interpersonal communication
Next.js for novices and dabblers

July (4)

Database fiscal year in review: 2020/2021
Random handy CumulusCI notes
Open a Salesforce scratch org in a different browser with CumulusCI
Adding Tailwind to a Jekyll site on Windows

June (3)

Jamstack live preview tooling
Growing link underline, in Tailwind CSS
SEO savings, one bubble tea at a time

May (2)

Hello world, it's the AWS parameter store
A git feature commit squashing approach

April (2)

Tailwind JIT starter for Gatsby
Big Data: What to learn

March (18)

Checking a password against Troy Hunt's list
Anonymous PLSQL subquery from a file
Tailwind JIT starter for 11ty (play fast!)
Off-by-one errors in Python API pagination
A Lyris to Marketing Cloud imaginary architecture
Can 11ty host my podcast for free?
Stackbit can teach you web development
Data Development and Integrations (official Salesforce Developers podcast appearance)
What's a docking station?
Using OBS as a virtual webcam for Zoom conference calls
Using your phone or iPad as a webcam
PiP webcam + screen sharing
Record 2 videos using the same microphone
Using a Behringer UCA202 with Windows, Android, or iOS
Listening to computer sound through an Audient iD14
Recording an Audient iD14's sound in Windows
Intro to streaming and recording concepts
My video editing software

February (7)

11ty Markdown -- group pets by color
Responsive, accessible navigation 5: HTML structure
Responsive, accessible navigation 4: Preventative troubleshooting
Responsive, accessible navigation 3: Constraining width
Responsive, accessible navigation 2: 11ty
Responsive, accessible navigation 1: Intro
Insert, update, and delete from a database to Salesforce

January (5)

5 things you need to know about Jekyll vs. 11ty Liquid includes
APIs are for admins: texting your colleagues with Salesforce Flow (Cactusforce 2021)
The first JavaScript I ever wrote
Clean up old node_modules in Windows 10
How to use Jekyll SSG with Headless CMS

2020 (63)

December (5)

How to break (and rebuild) the Jamstack
Hello World on Netlify Functions, Cloudflare Workers, & Vercel Functions
Passwordless Auth0 and Netlify functions: backend
Add users to Netlify Identity with Postman
A starter for Netlify Functions with 11ty

November (2)

Wanted: mirrorless camera & lens for livestreaming
Drupal vs. 11ty with kittens & puppies

October (9)

Movable page builder components in Sanity CMS
Infrastructure as code homework #2
Algolia attributes are flexible
Ellucian Banner fan wiki, OMG
Re-indenting with Notepad++ regex replace
Anonymous PL/SQL to write a CSV from SQL
ORA-29283 hello world
ORA-29283 salut le monde
Setting up Windows Store Python with Pandas in VSCode

September (6)

Infrastructure as code homework #1
Configuring public-private key pairs so 2 Linux machines can talk
Study plan for GraphQL in Salesforce Marketing Cloud
Sanity datatable serializer for 11ty sites
Sep. 9: Content creation panelist on Whiskey Wednesday podcast
Intro to XML, JSON, & YAML: the book

August (10)

Reading a datetime with miliseconds into an Oracle DATE
Choosing a headless CMS without losing your head
Why do bloggers love Markdown? Why use MDX? And other notes from MDXConf 2020
Qu'est-ce qu'un générateur de site statique ?
Qu'est-ce que l'hébergement web statique ?
What is a static site generator?
What is static web hosting?
Heroku live previews for Gatsby + Sanity sites
Set plugin names and default visibility in Canvas course navigation menus
HowToGraphQL.com Notes

July (6)

Rate-limiting API requests in Python with a decorator
Gatsby Cloud live previews for Sanity-based sites
Educators and students - get Figma graphic design software free
PL/SQL Nested Queries
Gatsby Minimum Viable Sanity Template
Sanity CMS Minimum Viable Build

June (9)

Why WYSIWYG static site CMS's love Gatsby
How I brought my Google Page Speed from 80 to 91 in 5 minutes
Gatsby React WYSIWYG CMS-Friendly Markdown
Gatsby React Minimum Viable Markdown Template / Component
Audient iD14 sound check for iOS and Windows
Gatsby Minimum Viable Build
Gatsby for novices and dabblers
Jamstack Conf takeaways and Hopin thoughts
Virtual Conference Live Music

May (2)

Boolean 'OR' in DemandTools MassImpact formulas
Le 'ou' booléen aux formules MassImpact de DemandTools

April (5)

Recompile dependent PL/SQL code after changes
Writing & graphics for scheduled Facebook Live videos
Livestreaming Music Diary - Facebook Live
Jitterbit Hosted API Tutorial: 302 Redirect with Cloud Studio
Jitterbit Hosted APIs: Hello World tutorials

March (1)

What is #FlattenTheCurve? Why is everything cancelled?

February (5)

Netlify CMS Jekyll Minimum Viable Build
Door Prize: Excel VBA code for turning your ex-PMI into principal payments
Excel VBA code to compute when a mortgage will be free of PMI (Private Mortgage Insurance)
Python NumPy code to compute when a mortgage will be free of PMI (Private Mortgage Insurance)
Salesforce Classic slow in Chrome? Use Firefox until Spring '20

January (3)

Tutorial: Flow External Services for Salesforce Admins
Salesforce Spring '20 Community Guest User Apocalypse
Flow Invocable Apex with Any Salesforce Object Type

2019 (45)

November (4)

Migrating my Salesforce org backups from Eclipse to VSCode without messing up Git
Workaround: Salesforce Flow Picklist-Related Invalid Type Error
A Jitterbit Case Study: Higher Education Adventures in Salesforce
Solved: 2 Salesforce ETL Errors

October (3)

Clearing A Jitterbit FillDataElements Error
S'occuper d'une erreur FillDataElements en Jitterbit
Better Salesforce Insert/Update Operations with Jitterbit Caching

September (3)

Disabling Lightning Experience w/ Python and Selenium in Salesforce
Recalculating Salesforce Formula Fields in Apex
Recalcul des champs de formule Salesforce en Apex

August (2)

No-Permissions Salesforce Profile w/ Python and Selenium
Python Pandas For Excel on vBrownBag - show notes

July (2)

Forcelandia 2019 XML & JSON Conference Talk Resources
Salesforce Apex Performance: new ID map vs. for loop

June (2)

Tutoriel : types de données définis par Apex pour admins Salesforce
Intro to HTTP

May (2)

Tutorial: Flow Apex-Defined Data Types for Salesforce Admins
XML for Salesforce Administrators: DemandTools Configuration

April (7)

Intro to XML and JSON #7: Recap & Real World Use
Intro to XML and JSON #6: JSON
Setting up VSCode to edit Salesforce metadata
Logging into Salesforce's Pardot API (w/ Python)
Intro to XML and JSON #5: XML/CSV Conversions
Intro to XML and JSON #4: XML Values
Intro to XML and JSON #3: XML Items & Keys

March (6)

Intro to XML and JSON #2: Data's Shape
Intro to XML and JSON
Salesforce REST APIs: A High-Level Primer
Python pour Salesforce: compte -> campagne
Setting up Python on Windows with Anaconda
Setting up Python on Windows with Miniconda by Anaconda

February (7)

Logging into Salesforce's Marketing Cloud API (w/ Python or Postman)
Git and SourceTree setup with AWS federation on Windows
Studying programming by writing glossaries
Cleaning bad Pardot data with Python
Git brain dump
Telling Sourcetree about one of my GitHub repositories
Modification des données CSV / XLSX en Python pour admins Salesforce : vidéo et notes

January (7)

Python for Salesforce: List unique values found across similar Salesforce fields
Python pour Salesforce: Énumérer les valeurs uniques à travers plusieurs champs Salesforce
9 fév: Démonstration de Python pour admins Salesforce (FR)
Feb. 9: FRENCH-language demo of Python for Saleforce admins!
Proper-Casing CSV/XLSX Data With Python
Filter a large CSV file with Python
Filtrer un gros fichier CSV avec Python

2018 (7)

November (5)

Dedupe Salesforce NPSP Emails with Python
Python for Salesforce Real-Life Challenge: NPSP Email Deduping
Every SQL Join You'll Ever Need
Why & How Should I Learn PL/SQL? (…T-SQL…PL/pgSQL…)
Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…)

October (2)

Salesforce Custom Metadata vs. Custom Objects
Salesforce: métadonnées personnalisées v. objets personnalisés

apex api architecture astuces aws azure bases de données beginner canvas conferences csv custom metadata databases demandtools devops digital garden développement web eclipse excel feuilles de calcul flow git graphql health instructure integration intermediate jamstack jitterbit json linux marketing cloud minimum viable build music métadonnées personnalisées pandas pardot powershell professional development prompt engineering python questions salesforce salesforce saturday samedi salesforce security selenium spreadsheet sql tips triggers tutorials tutoriels videography vscode web development windows xml yaml