Variable reference is not valid. ':' was not followed by a valid variable name character. Consider using ${} to delimit the name

How to fix Azure DevOps “Variable reference is not valid. ‘:’ was not followed by a valid variable name character. Consider using ${} to delimit the name”

This article explains one possible reason why you might run into an error like “Variable reference is not valid. ‘:’ was not followed by a valid variable name character. Consider using ${} to delimit the name” when using a PowerShell task in an Azure DevOps pipeline. Confusingly, the offending line might be this: Write-Host (‘##vso[task.debug]$LASTEXITCODE: {0}’ -f $LASTEXITCOD … Not something you even have in your script! What gives? Problem…Continue reading How to fix Azure DevOps “Variable reference is not valid. ‘:’ was not followed by a valid variable name character. Consider using ${} to delimit the name”

Microsoft Graph g-raph (giraffe) - the spirit animal of Microsoft Graph

One way to fix “Unsupported or invalid query filter clause specified for property” for your Microsoft Graph API queries

This article explains one possible fix to an annoyingly generic exception thrown by the Microsoft Graph API (namely, “Unsupported or invalid query filter clause specified for property”) or an even more generic exception thrown by PnP PowerShell (“Exception of type ‘PnP.PowerShell.Commands.Model.Graph.GraphException’ was thrown.”) when you’re trying to query Graph API with what’s called “Advanced query capabilities” (operators like less than or equal, greater than or equal) instead of just checking…Continue reading One way to fix “Unsupported or invalid query filter clause specified for property” for your Microsoft Graph API queries

An accurate depiction of a NuGet package factory

How to fix NU3028 and NU3037 errors in Azure DevOps builds?

This article explains a solution to a rather annoying issue, where certificate validation for builds trying to fetch NuGet packages published by Microsoft fails when using .NET 5. This happens at least with Docker build when you’re relying on some Microsoft-provided images… But probably also in a lot of other cases. Problem When running an Azure DevOps pipeline with any task that does any Docker stuff, your build fails. Or…Continue reading How to fix NU3028 and NU3037 errors in Azure DevOps builds?

PostgreSQL everywhere

How to store a complex object as JSON in a PostgreSQL database using Entity Framework (Npgsql)?

Okay, that’s a title and a half. But let’s see – what are we actually doing and why? In my particular case, I had to store a Dictionary<string, string> in a Postgres database. By default, that’s not something Entity Framework handles. But as usual, there’s a way around that – and the same concept we’ll take a look at below should work for other complex data types or objects too!…Continue reading How to store a complex object as JSON in a PostgreSQL database using Entity Framework (Npgsql)?

I secretly automated my whole job with PowerShell

How to use Microsoft.Online.SharePoint.PowerShell with PowerShell 7?

This article explains an annoying extra step (or a really nifty trick – depending on how you choose to look at it!) that you can take to make sure your PowerShell 7 is able to import a module that was developed for .NET Framework, instead of .NET Core. This is super helpful when you run into weirdness with some of the more, let’s call them CLASSICAL, PowerShell modules. Such as…Continue reading How to use Microsoft.Online.SharePoint.PowerShell with PowerShell 7?

Entity Framework - am I right?

How to fix another weird Entity Framework Core dependency issue?

Okay – so that’s a non-descriptive title if I’ve ever written one – I apologize for that! I just couldn’t figure out a way to shorten the error when “Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore” is referencing “Microsoft.AspNetCore.Http.Abstractions”, and even though you’re not referencing that dependency directly, you get an error where you have both 3.x and 5.x or 6.x major versions of the assembly in use. Which, in layman’s terms, is no good. What…Continue reading How to fix another weird Entity Framework Core dependency issue?

Azure DevOps - Always Be Shipping!

How to configure Azure IoT Edge deployments in Azure DevOps pipeline?

So some time ago, I needed to configure my first Azure DevOps pipeline for an Azure IoT Edge project. I needed to figure out which tasks to use, how to handle variables – all that good stuff. And let’s call it a learning experience. Pro tip: AzureIoTEdge task is not the way to go :) This article has actually been more than a year in the making, but as usual,…Continue reading How to configure Azure IoT Edge deployments in Azure DevOps pipeline?

I'm not saying it was built with Azure Functions, but it was definitely built with Azure Functions.

How to fix “The listener for function was unable to start. Out of retries creating lease for partition 0”

Here is another pretty quick one – trying to debug Azure Functions fails with a confusing error message about failing to create a lease for a partition. But as usual, the fix is (probably) simple, and this article explains what to do :) So, hey future me, finding this article on Google! 🙋‍♂️ Let’s get to it, then! Problem When trying to debug your Azure Function, you get an error…Continue reading How to fix “The listener for function was unable to start. Out of retries creating lease for partition 0”

Everything is broken (a delicious lego meme)

The simplest fixes to “500 (Internal Server Error)” from Azurite

This quick blog post explains a couple of very simple fixes – essentially, user errors – to a simple problem that you might run into with Visual Studio when developing the latest of your cool Azure bits. Well, to be fair, a few simple fixes and one heavyweight. A final ditch effort to learn to live with Azurite. But we’ll get to it. So, let’s embark on a journey, to…Continue reading The simplest fixes to “500 (Internal Server Error)” from Azurite

PostgreSQL everywhere

How to configure Azure PostgreSQL to allow Cloud Shell connections?

I was setting up a PostgreSQL database in Azure, to be used by a cutesy little Azure Function storing telemetry from a bunch of Azure IoT Edge Devices. But when everything was (supposed to be) configured successfully, my Azure Function failed to store anything anywhere because of a missing database… Oh, right. Entity Framework can’t create PostgreSQL databases, as the connection is made to an existing database – so it…Continue reading How to configure Azure PostgreSQL to allow Cloud Shell connections?