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.
Yesterday, I wrote about how I setup SQL Servers Virtual Machines using PowerShell and PowerCLI. Now that I’ve got the SQL Server imaged, it’s time to format the disks and prep the Page File. Let’s dig in.
I’m trying to automate as much as possible in my lab and part of that is building SQL Servers. I’ve taken to trying to scripting this out. For me, that involves using PowerShell to build out this machine.
A few months ago, I really stated digging into the Orion SDK and I wanted to know more about ways to automate adding nodes to Orion. Sure, I can wait for the Network Discovery to kick off, but I’m impatient. I’ve gotten many of the parts together over time, but this is my first post where I put everything together. For this version, I use the PowerShell Snap-In. I will add an additional post later using the PowerOrion Module.