install

SMA – Error “Root element is missing”

While I was building SMA runbooks in the past couple of months I bumped into this rather strange error. So happen few days ago, I tried to call (invoke) a child runbook, from a parent runbook function. SMA returned an error “Root element is missing” I simplified the structure so it looks like this… Function […]

PowerShell – Create “Clean” Custom Objects From DataTable Object

I recently had a need to create “clean” PowerShell custom objects out of a DataTable object. What does that mean? Well, let me explain. When you try to get data out of SQL Server using PowerShell there are many ways to do it. Either you use Invoke-SQLCmd, SQL Server PowerShell (SQLPS), SQL Server Management Objects […]

SCOM – SQL Server Event ID 28005, AEM Wizard Runs Forever, Reporting Services Not Working

I like to automate things, creating batches and scripts. Well at least I like to create them myself and then I know what they do. In a small project I needed to install SCOM 2012 SP1 to show Agentless Exception Monitoring. Because larger environment need a managed way to install IT systems identically they often […]