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

Simple Automation Example using Orion SDK

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.

Read more