All projects
January 2025

Install Automation

Standing up a new system meant installing SQL Server, Management Studio and Reporting Services, then setting collation, service accounts, named pipes and mixed-mode authentication, and picking the right 32 or 64-bit build. About an hour of careful clicking, every time.

  • PowerShell
  • SQL Server
  • Windows

What I Built

PowerShell scripts brought that to 20 to 25 minutes, then went into an executable that takes a few inputs, shows progress as it runs, and logs what it did. It matters most when ten to fifteen systems need setting up at once. I am still extending it.