image_thumb.png

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 […]

PowerShell – Convert Special Character String Into Numbers

Do you know the situation where you have to handle strings / string data that has a lot of complex characters? In certain situation it is just a pain to deal with strings that have special characters like “*ç%&/()=`è or even an entire Export-CliXML output content. Recently I had the need to embed such data […]

Azure Log Analytics – Get Windows Event Description

There are cases where Microsoft tries to make our live a bit harder than it needs to be. One thing I always struggled with in the old SCOM days and also in the present Azure Log Analytics (ALA) days are Windows event descriptions. I just had a need to get the event description for a […]