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.
Windows Server Failover Cluster and SQL Server FCI validation your AI agent can call — a .NET MCP server that does the work, plus a thin PowerShell client for plain cmdlets. 16 read-only diagnostic phases cover quorum and witness, shared storage and SCSI-3 reservations, MPIO, networking and heartbeat, hotfix parity, service accounts, time drift, and a wrapped Test-Cluster run. Runs where your clusters run; nothing leaves your network.
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 →3 min read
MCPatrol is live: because a dead MCP server doesn't tell anyone
The Android app is on Google Play and the web console is open at app.mcpatrol.com. What MCPatrol watches, and why an MCP server needs more than a ping check.
- mcp
- monitoring
- android
- detent-point
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