Scripting SQL Server Installation

This is where I show that I’m really not a DBA.  I’m an Accidental DBA at best, and a nuisance at worst.  SQL Server already has the capability to be installed via command line parameters or a configuration file.  If I setup the machine the same way every single time, this would be fine, but since I need to change the placement of certain file types, I need to have the ability to change on the fly.

Read more

SAM PowerShell Scripting Template

I write a lot of PowerShell scripts.  Like a lot, a lot.  I write them for any manner of things, but recently I’ve been tasked to help out with a few Server & Application Monitor templates.  These are some of the most interesting things that SAM has to offer.

Looking at each of the scripts, I decided it was worth revisiting based on some of my newly acquired PowerShell superpowers (cape not included).

Read more

PowerShell function to suppress HTTPS self-signed certificate errors

I’ve been working frequently with the Invoke-WebRequest and Invoke-RestMethod functions recently against my SolarWinds Orion infrastructure.  I’d normally use the Swis Snapin, but instead wanted to get a little more experience with JSON and XML. Now, when I try to make that call to port 17778 on any machine except the Orion server itself, I … Read more

End of an Era

So today was my last day with my current employer.  I’m off to new and exciting things, but hope to keep being able to share some of my insights with the community at large.  Don’t expect too many posts in the near future, but I promise that I’ll try to add more posts as soon as I get my feet under me.

Thanks for reading and until next time…