Automating ODBC DSN Management with PowerShell Remove-OdbcDsn
Orphaned DSNs and the Ticket That Started It All The ticket read: “Application can’t connect to the database.” After remoting into the server, I ran Get-OdbcDsn and found seventeen ODBC…
PowerShell For, ForEach, and While Loops Explained
Six Hours of Copy-Paste, Gone in One Loop Last quarter we inherited a client environment with 140 Windows servers. The previous admin had been manually checking disk space on each…
GitHub CI/CD Automation: Stop Deploying Like It’s 2012
The Problem Nobody Admits to Having A dev team we inherited during a client onboarding was doing manual deployments via FTP. In 2025. One guy held all the credentials. He’d…
PowerShell Automation Readiness Audit for IT Teams
I used to spend two hours every Friday manually reviewing scripts before they hit production. Scan for error handling. Check the logging. Run through a mental list of twelve items…
PowerShell Parameters, Validation & Dynamic Parameters
Related reading: PowerShell Automation Readiness Audit for IT Teams | PowerShell Scripts, Functions, and Script Blocks Guide PowerShell parameter design determines whether a script is a reliable production tool or…
PowerShell Scripts, Functions, and Script Blocks Guide
PowerShell scripts, functions, and script blocks are the three core building blocks of IT automation for system administrators. Knowing which to use – and how to structure each one correctly…