clip_image008.png

SCOM – Part 1 Create Excel 2013 PowerView Dashboard

Last week I had to travel to China. So far, I haven’t had any experience with Asian countries nor culture, except of the local Chinese restaurant in Switzerland. What I learned, that there are different ways to visualize common scenarios and how important it is to make the visualization readable and understandable, also for foreigners. […]

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