Windows · PowerShell · WSL · Claude Code
Notes from a working
SQL Server DBA
I am a Database Reliability Engineer in Edinburgh looking after critical SQL Server estates. This is where the Windows, PowerShell, WSL and Claude Code side of that job gets written down: things I worked out once and have needed again since.
Start here
Four guides organise everything on this site. Each one collects the posts by task rather than by date.
- wsl32 postsWSL: The Complete GuideInstalling it, working with files across Windows and Linux, managing distributions, and fixing it when it sulks.open guide
- powershell65 postsPowerShell: The Complete GuideFiles and folders, CSVs, the Windows Firewall, scheduled tasks, and the cmdlets worth knowing by heart.open guide
- windows43 postsWindows Administration: The Complete GuideBuilding servers, domains and DNS, installing the tools you actually use, and the built-in commands that answer most questions.open guide
- claude-code18 postsClaude Code on Windows: The Complete GuideInstalling it natively or in WSL, the VS Code extension, CLAUDE.md and permissions, hooks, MCP, skills and subagents, and running it from PowerShell.open guide
Looking for the SQL Server material?
It moved to a site of its own. sqldba.blog has 150+ documented DBA scripts, a paste-your-error library, a page for practically every wait type, and the SSMS guide.
Visit sqldba.blog →
Latest posts
Newest first. 203 posts here since 2017.
- Check an AI-Written PowerShell Script Before You Run It
- Store API Keys Safely in PowerShell
- ConvertTo-Json Depth: Why Nested JSON Shows System.Collections.Hashtable
- How to Shut Down a Computer with PowerShell and CMD
- How to Check the Last Reboot Time of a Windows Computer
- Claude FM: The /radio Command in Claude Code
- Kill a Process by Name or ID in PowerShell
- Search Your PowerShell Command History with Ctrl+R
- Find Which Process Is Using a Port in PowerShell
- Top Processes by Memory in PowerShell (Get-Process)
- Fix “UnicodeEncodeError: ‘charmap’ codec can’t encode character” in Python on Windows
- Check Free Disk Space in PowerShell (Get-Volume)
- Copy PowerShell Output to the Clipboard (Set-Clipboard)
- Base64 Encode and Decode a String in PowerShell
- Claude Code: Missing “mcpServers”, found “servers” instead
- Check if PowerShell Is Running as Administrator
Browse by topic
Every post rolls up into one of these.
Not sure where to start?
Most people arrive here from a search for one specific thing. If that is you, the guide covering it will have the rest of the answer, and a few neighbours worth knowing.