Diagnose and fix SQL Server Kerberos authentication issues from PowerShell. Audits SPNs across a farm of instances, identifies missing or duplicate registrations, and applies fixes — without touching Active Directory by hand.
Hello, I'm
Keith Ramsey
The PowerShell-First DBA
I'm a SQL Server DBA who reaches for PowerShell before SSMS. When you're managing a farm of instances and running the same task 30, 50, or 100 times, the GUI just doesn't cut it — so I automate.
Things I've built
Git in plain English for PowerShell users. Twenty-one commands — Save-Work, Find-CodeChange, Show-History — that replace four-step Git sequences with one verb. No jargon. Credential-safe by design.
Automated validation for SQL Server Failover Cluster Instance configurations — catch misconfigurations before they cause an incident. Real answers, no guessing.
The company behind the tools — PowerShell-first automation for SQL Server DBAs. Home base for everything I build.
Turns source code into structured wiki documentation. AI agents, CI/CD pipelines, and Confluence — docs that update themselves.
21 plain-English git commands, available as MCP tools. Connect once — branch, commit, and push without leaving your AI client.
MCPatrol probes every MCP server you register, day and night, and puts the incident on your phone or in your browser before your users hit it — health, latency history, and alerts when a server's tools change, not just when it goes down.
Coming soon: a corner of the web that's quite literally full of wikis — WikiMint included.
Recent writing
View all →5 min readPester for Beginners
Announcing "Pester for Beginners" — the whole 25-part series, all at once
A complete beginner-to-confident series on testing PowerShell with Pester 5 — written offline, finished first, and released as one full set.
- PowerShell
- Testing
- DevOps
- Beginners
7 min readPester for Beginners · Part 25
Putting It Together: A TDD Workflow + Common Pitfalls (Capstone)
You have all the pieces. Now turn them into a habit: the red-green-refactor TDD loop in PowerShell, a checklist drawn from all six sections, the beginner pitfalls to dodge, and where to go next.
- PowerShell
- Pester
- Testing
- TDD
- Beginners
- Capstone
6 min readPester for Beginners · Part 24
Running Pester in CI/CD (GitHub Actions & Azure Pipelines)
Tests that only run when you remember them protect nothing. Wire the Pester 5 configuration object into GitHub Actions and Azure Pipelines so your suite runs on every push, publishes results, and fails the build on red.
- PowerShell
- Pester
- Testing
- CI/CD
- GitHubActions
- AzurePipelines
- Automation