When someone asks about SQL Server architecture, the reflexive answer is usually 'High Availability,' as if it's a requirement rather than a choice. But after 20 years of managing SQL Server environments, I've found that HA often creates more problems than it solves, especially in certain types of organizations.
The …
Read MoreTL;DR: In Windows, many AI CLI tools (Aider, Claude Code, Gemini, etc.) work unreliably with PowerShell's standard output capture. The solution is write to temp files instead of variables or add a
-Rawflag for when you need the tool to actually commit changes instead of just previewing them or hanging forever.The …
Read MoreTLDR: dbatools is moving to Azure Trusted Signing, which means Microsoft backs our reputation and dbatools won't trigger as many antivirus false positives.
Users upgrading from older signed versions will need
-SkipPublisherCheckonly once during the initial transition. PowerShell users with strict ExecutionPolicies …
Read MoreRecently, I wrote about a system I created that automatically classifies SharePoint documents, but only briefly touched on the most important part—the Azure Function that does all the heavy lifting.
This post walks through the technical part of this document processing engine and demos how to build an Azure Function …
Read More- Getting users to enter metadata is THE challenge when managing SharePoint document libraries. The moment we set up custom columns for proper document classification, we create a burden for our users who just want to upload files and move on. As an on-again/off-again SharePoint dev, I find metadata super useful but even …
Read More If you read my post on asking tiny questions, you're already familiar with how structured output turns LLMs into pretty reliable data processors. We saw how requesting boolean responses or specific JSON formats made local LLMs actually useful for automation tasks.
In this article, we're taking that same structured …
Read More- For the longest time, I thought AI would never apply to me as a developer. I don't excel at math, and AI is pretty much all math. But then I realized that I don't need to understand the math to use AI effectively - there's plenty of applied intelligence that's directly relevant to what I do every day with PowerShell. …
Read More - This is the first installment in a series of posts that show actually useful use-cases for AI in automation. Most of the content will revolve around "structured output," which is basically JSON-formatted AI output. You'll learn more about structured output in-depth later on, but in this post, I wanted to give …
Read More - Recently, I was trying to figure out if the content of two headlines overlapped. I needed a script that would answer if Pacific Palisades is part of Los Angeles, but I couldn't use regex because there's no pattern that matches "Pacific Palisades is part of Los Angeles." There's also no simple string …
Read More If you're like me and have a hard time wrapping your mind around how AI works, Microsoft's AI Toolkit for Visual Studio Code makes it unusually approachable. Recent versions work on Windows, Linux AND macOS too!

I didn't expect LLM engines to be "just" binary files, but the VS Code extension helped me better …
Read More