Related Articles
Azure Log Analytics – Testing JOINs Part 2
Posted on Author stefanroth
In part 1 we got a pretty good understanding how joins work and what the results are. To make this a complete series we will now work on the remaining join types. Full Outer The fullouter join is a join that shows in addition to the inner matches, there’s a row for every row on […]
PowerShell – Create “Clean” Custom Objects From DataTable Object
Posted on Author stefanroth
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 […]
SMA – Migrating SMA Runbooks (SMART Toolkit) Annoying Confirmation
Posted on Author stefanroth
To migrate SMA runbooks from one environment to another you probably want to use SMA Runbook Toolkit to export and import the runbooks and assets, you can find the download here. This toolkit is a collection of PowerShell scripts which are few years old but still work perfectly with SMA 2016. After you downloaded the […]