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.
Uncategorized
Installing Utilities Folder with PowerShell
Just stashing this here in prep for a larger article. As written the above will install the utilities in C:\UTILS. However, some workstations may block these types of installs. In that event, I’ve added a flag ($IsMachine) which can be flipped to False and install in the current user’s profile.
Installing the Latest Notepad++ with PowerShell
I just needed a place to stash this and my GitHub didn’t seem appropriate. I make no guarantees that this will work and it’s only been tested on one system so far. I added the -Unique flag to the end of the download URL detection as indicated in a below message. (Again, nice catch!)
Protected: Chicago SWUG Presentations
There is no excerpt because this is a protected post.
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).
SAM script templates (Windows Scripting, PowerShell, Perl, Python, whatever) require two things – a statistic and an exit code.
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
Wedded Bliss!
So, I’m getting married in just a few hours. I get to marry my best friend. She has been my rock and is helping me make more of myself every day. Though the ceremony will be small, you can share in our excitement by joining us online. Check it out here.