Azure DevOps throwing "Unexpected token < in JSON at position 4"

Azure DevOps throwing “Unexpected token < in JSON at position 4"

This article documents one of the simplest solutions to one of the simplest issues you might ever encounter with Azure DevOps. Still: it’s a pretty annoying one, and the solution – as simple as it is – seems worth documenting for the next time I’m googling this fervently as I’m afraid of losing my unsaved changes again… :) Essentially, your editor view in Azure DevOps times out and you risk losing any changes you’ve done, and it’s all due to clumsy authentication implementation by Microsoft.…Continue reading Azure DevOps throwing “Unexpected token < in JSON at position 4"

Microsoft. Word.

How to copy a table in Microsoft Word (Office app)?

This article will document a super simple solution to an infuriating and stupid issue you might run into in Microsoft Office Word. Or maybe you might not, but I did. Can you tell I’m just sharing my own pains and whatever I needed to google and didn’t find a solution for? Yeah, another one of these. But hey – maybe that’ll be useful to someone else, too! Problem Long story short – copy-pasting this: Becomes this: WHAT – that’s not a table. That’s just weirdly…Continue reading How to copy a table in Microsoft Word (Office app)?

T-SQL, yes please!

How to (easily) move data between SQL databases

Every now and then, you will run into a situation where you need to overwrite a database’s contents with those of another database. Maybe you’ll need to update a staging environment with a partial data import from production, or perhaps you have a new developer coming in who needs some data – I don’t know. But this should be a run-of-the-mill action. Something you can do in a minute. The bottom line is – this shouldn’t be complicated. And it should be documented really well.…Continue reading How to (easily) move data between SQL databases

Everything is broken (a delicious lego meme)

How to fix a Logic App deployment that failed with error “UsageConfigurationNotSupportedInSubscription”?

This article explains a quick and dirty fix when you get an error somewhat like this: “UsageConfigurationNotSupportedInSubscription” when you’re deploying an Azure Logic App from a template. The same fix will probably apply to a number of other issues – but don’t hold me accountable for this :) Anyway – on to the topic of the day! Problem Can you tell by some of my recent blog posts that I’ve been deploying a few Logic Apps recently? :) Today, my Azure Logic App deployment from…Continue reading How to fix a Logic App deployment that failed with error “UsageConfigurationNotSupportedInSubscription”?

Using Azure CLI to assign an AD group to multiple resource groups at once

This article describes a solution to an age-old question of mine: how can I add an Azure Active Directory group – like a security group – to multiple resource groups at once? I’ve had to do this multiple times, and manual work takes quite a while. And who likes multiple manual steps? To be fair, this article could also be called something like: “Using Azure CLI to spend a lot of time unnecessarily complicating a mind-numbingly boring task of adding one Azure AD group to…Continue reading Using Azure CLI to assign an AD group to multiple resource groups at once

Powershell is hell

Solving “Unable to find repository ‘https://www.powershellgallery.com/api/v2’.”

So, you’re running a PowerShell command that requires a connection to PowerShell gallery, but you run into an error message, somewhat like this: “Unable to find repository ‘https://www.powershellgallery.com/api/v2’. This can happen when you’re running something like Install-Module or Update-Module. This pretty much blocks you from doing anything that would require the use of new modules – so, quite a lot. Worth fixing, then. 😁 Problem The whole error message might be somewhat like this: What gives?

Azure Logic Apps logo

How to move your Microsoft PowerAutomate Flow to Logic Apps?

This article explains how you can export a Microsoft Power Automate Flow from, well, Microsoft Power Automate, and nicely and easily import it to Azure Logic Apps. I’ll explain the process step-by-step, and also explain solutions to a few hurdles you might run into! But first, let’s take a look at why you might want to consider taking this step in the first place, shall we? Why move to Logic Apps? Ah, a valid question. There are plenty of possible reasons why you might want…Continue reading How to move your Microsoft PowerAutomate Flow to Logic Apps?

RCC out of control

Resolving an incredibly pointless struggle with RCC

Okay, this might be my least general, and overall most pointless article ever, but I felt the need to document it anyway. Maybe it’ll help someone with a similar gadget, despite being a bit off-topic on this blog. Apologies to any regular visitors! So, what am I talking about, then? Recently I bought a radio-controlled projector clock as a gift for my wife. I reasoned that such a device would never require any fiddling with (due to its automatic nature), and hence be the one…Continue reading Resolving an incredibly pointless struggle with RCC

Better blame TLS 1.0 for this one.

How to force an outdated .NET project to use TLS 1.2?

This article explains a kind of weird fix to a pretty annoying issue with a legacy service. And I’m not just calling it legacy because it’s WCF – I’m calling it legacy because it’s old. The particular piece of software was developed about 7 years ago (2014-ish)! It had worked for quite a while – but now it was down. I know, I know – 2014 is not THAT old. There’s surely COBOL that’s been running since the 70s, if not before. But in the…Continue reading How to force an outdated .NET project to use TLS 1.2?

Everything is broken (a delicious lego meme)

How to fix a Logic App deployment that failed with the error “ApiNotFound”?

This article explains a quick and dirty fix when you get an error somewhat like “ApiNotFound” when you’re deploying an Azure Logic App from a template. This seems to be a very typical hurdle to run into when you’re trying to deploy a PowerAutomate Flow you’ve exported. I guess despite being built on the same platform, Flow developers took some liberties and the migration is not quite as painless as one would hope… :) Anyway – on to the topic of the day! Problem This…Continue reading How to fix a Logic App deployment that failed with the error “ApiNotFound”?

While only a few countries use absurd date formats (such as the Month-first approach adopted by some former European colonies), there's no shortage of different date formats out there. Source: John Harding/Mona Chalabi

Experiment: DateTime formats

Okay. So I needed to figure out what locales certain machines support, and what kind of DateTime formats those would produce. Being the crafty coder I am, I set out to copy-paste some readymade code from docs.microsoft.com. As a side note, after Microsoft opened the docs out to community contributions, I have had far less need to browse StackOverflow for my carefully curated code snippets of questionable quality. I’m going to regard that as a minor victory on the path to friendlier developer communities. Preface…Continue reading Experiment: DateTime formats

"This is fine" - a fine meme, I mean.

How to fix “LinkedAuthorizationFailed” when deploying an Azure Logic App?

This article explains one possible fix to “LinkedAuthorizationFailed” when you’re deploying a Logic App from an Azure Automation template. Maybe it’ll apply to other cases, too – but in my case, it helped me fix a broken template I had exported from Power Automate and was bringing into Logic Apps. Problem So, another fun issue to solve! The actual error you run into might be something along these lines: The client has permission to perform action ‘Microsoft.Logic/integrationAccounts/join/action’ on scope ‘/subscriptions/[your subscription id here]/resourcegroups/[your app resource…Continue reading How to fix “LinkedAuthorizationFailed” when deploying an Azure Logic App?

Visual Studio logo

How to fix a build configuration that’s not available as a build directive in Visual Studio?

This article describes how to fix and tweak your pre-build directives in Visual Studio – just in case they refuse to work properly. Because yeah, apparently that sometimes just randomly happens. But fear not – there’s a stupid and ugly, but definitely thoughtful workaround available! Also, sorry for the confusing title. I’m taking suggestions for a more descriptive one – but this one was kind of difficult to word clearly. Anyway – on to the topic of the day! Problem So you’re either trying to…Continue reading How to fix a build configuration that’s not available as a build directive in Visual Studio?

Always ship Azure DevOps.

How to access invisible packages in Azure DevOps artifact feed?

Let’s go with a very simple “note-to-self” kind of a blog post today. Plenty of those to go around on this blog, and I am sure that there will be plenty more! This one is another case that should be really obvious, but isn’t, and should just work, but doesn’t. Namely, when you have run a pipeline in Azure DevOps expecting it to publish a package in your internal NuGet feed so that all of your friends can use it. And Azure DevOps is great…Continue reading How to access invisible packages in Azure DevOps artifact feed?

Printer's misbehaving? Nothing a bit of PowerShell wouldn't fix!

How to change printer paper size using PowerShell?

This article explains (with conveniently copy-pasteable code samples) how you can query your printers using PowerShell and modify properties, such as paper size, for one or more of them. This is very useful if you have multiple printers and multiple computers that you use. AND if you frequently move between continents, you might face the same, totally typical and widespread issue: Your favorite printer might default to using “Letter” paper size, but you’d really need to get it printed in that sweet, sweet “A4” instead.…Continue reading How to change printer paper size using PowerShell?

"This is fine" - a fine meme, I mean.

Guide: How to take over and kill a viral AAD tenant?

Rogue Azure Active Directories don’t sound like a huge and widespread problem, but Microsoft’s approach of generating unmanaged, viral AAD tenants whenever they encounter the tiniest reason to do so MUST be driven by some weird internal scorecard where “number of tenants” has a lot of weight, because you do get an Azure AD tenant really easily, and getting rid of one is surprisingly laborious. This guide aims to explain what’s the quickest way to remove one. Background Unmanaged directories can be troublesome because they…Continue reading Guide: How to take over and kill a viral AAD tenant?

PowerShell not loading them DLLs

How to list all of the assemblies loaded in a PowerShell session?

In this article, I’ll do my best to explain how to list all loaded assemblies in a PowerShell session. You see, PowerShell is great at caching assemblies in the weirdest possible way, so ending up with all kinds of mismatches in loaded DLL versions is pretty common. Or just being plainly blocked from loading a new one as you already have a cached reference. I mean, I’ve run into all kinds of issues even if I only use PowerShell occasionally. Maybe that’s the reason. Anyhow,…Continue reading How to list all of the assemblies loaded in a PowerShell session?

Of Course I Still #ValoLove You

Long story short: My 6-year career with Valo is now coming to an end. Today was my last day at Valo. This is the longest I’ve ever worked at a company, and I’ve had the time of my life in the many positions I’ve held within Valo / Blue Meteorite. Rarely does a company offer you so many different possibilities and options – and let you grow into the role that you’re looking to fill, with any support you might need. Anyway – to take…Continue reading Of Course I Still #ValoLove You

Entity Framework Core logo

Fixing “No database provider has been configured for this DbContext” in Entity Framework Core

I’m using Entity Framework in most of the projects that I’m working on – and for the most part, it’s a pleasure to work with. But as always, there are plenty of chances to run into issues – so obviously, I stumble into all of the rare stuff that IS broken! This one I hadn’t really seen before – “No database provider has been configured for this DbContext”. This time I encountered the issue while setting up a new project and getting started working on…Continue reading Fixing “No database provider has been configured for this DbContext” in Entity Framework Core

Azure DevOps - Always Be Shipping!

How to run Robot tests on an Azure DevOps hosted agent?

This short article simply documents how to install the dependencies for running Robot Framework on Azure DevOps’ hosted agents. This simple tip comes in handy when you need to run any UI testing for your project after build, as Robot Framework is a great and widely used tool for that. Let’s quickly take a look at the background of the issue, after which I’m sharing a highly copy-pasteable piece of YAML for your convenience. Well – and mine. Background So I got a question about…Continue reading How to run Robot tests on an Azure DevOps hosted agent?