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 […]
Author: stefanroth
Azure Log Analytics – Testing JOINs Part 1
Azure Log Analytics offers you a powerful language to analyze your data. I am not a SQL query specialist but as far I can tell there are many similarities between SQL language and (New) Azure Log Analytics query language. One cool thing we can do is using joins. If you look up what a join […]
Azure Log Analytics – Get Data Types
In Azure Log Analytics you get to juggle with your data, turn and twist it the way you need to finally get your insights you want and need it. I just love Azure Log Analytics, there is so much to discover and once you started to explorer the language you figure out how much power […]
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 – Hash Table Get That Value
When writing scripts I like to use PowerShell ISE or VSCode a lot. It simplifies a lot of your daily scripting tasks like IntelliSense or Snippets. But sometimes these little helper don’t tell always the truth. Why? Well, I show you an example which is quite common. On problem there is if you are working […]
DSC – xRDSessionDeployment Server Keeps Rebooting
Some time ago I had been doing some interesting deployments using SMA and DSC in a push scenario. What does that mean? SMA is an engine that executes PowerShell (Workflows) at a scalable level and it is THE automation engine for on-premise scenarios, its counterpart in Azure is Azure Automation. DSC is Microsoft’s future way […]
PowerShell – Create a Credential Object with NULL Password
In one of my automation tasks I had the need to create a credential object with a $null password – an empty / NULL password. One easy way to do is, create just instantiate a new secure string object using the new() constructor from the .Net class like this: or using New-Object cmdlet like this […]
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 […]
Azure Dashboard – Execute Azure Log Analytics Queries
Building good, meaningful dashboards for monitored components is one of the hardest disciplines in a monitoring guys life – at least in my opinion. One little known hero in the Azure dashboard world is the “Markdown” tile… It has the power of running HTML fragments inside as you can see in the sample text provided… […]
OMS – OMS Gateway Chaining
I had an interesting question few weeks ago, which I could not answer for sure. I was asked, if it is possible to chain OMS gateways. I would have said yes in the first place, because they are just proxies. But so far I haven’t tested it. So, I decided to build this scenario in […]