image.png

Power BI – Introduction Part 1

I had already written in the past, that I like to combine new technologies to build new solutions. There are new technologies coming which might get not that attention yet they would deserve. My recent attention got caught by Power BI. I had some sort of idea what Power BI would be but not in […]

PowerShell – Change Windows Service Login to Group Managed Service Account

Group Managed Service Accounts (gMSA) are an awesome way to have Active Directory taking care of password changes for the service accounts. How to create Group Managed Service Accounts and how to assign them to Windows services you will find plenty of articles and blog posts on the internet. Group Managed Service Accounts solve you […]

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