Microsoft Azure logo

How to refresh all Az CLI subscriptions?

This article explains how to “reactivate” all of your accounts stored in your az account by refreshing your sessions. You might need this if you suddenly run into a script that needs to iterate all of your subscriptions without you being there to sign in to each one of them. Having a recently active session for each will help, and you can run your massive script unattended overnight or something like that :) But let’s take a step back – what’s the issue we’re dealing…Continue reading How to refresh all Az CLI subscriptions?

How to CTRL+ALT+DEL into RDP?

This is going to be another one of those really quick and short reminders to myself. I don’t use remote desktop connections that much, when I occasionally need to – and the computer asks me to press Control, Alt, and Delete for whatever reason, I’ll just hit them and bring up the stupid system screen on my own laptop. Yes, apparently I’m that guy. Anyway, let’s… Uh.. Get to it, then? How to CTRL+ALT+DEL into your RDP window instead of your own machine? CTRL+ALT+END References…Continue reading How to CTRL+ALT+DEL into RDP?

How to roll back an Azure IoT Edge layered deployment?

Have you ever wondered how you could roll back the latest layered Azure IoT Edge deployment? I have – it’s actually pretty useful. But what for? Well, perhaps it’s useful as the last step or whatever interesting Azure DevOps pipelines you have to deploy changes to an Edge device, run tests, and then remove the deployment. You could possibly have it as an optional parameter in case you want to do a dry run for the deployment – see if everything works well but not…Continue reading How to roll back an Azure IoT Edge layered deployment?

Pipeline overloading the poor $edgeAgent

Azure IoT Edge order of deployment operations

This article tries to bridge a gap in Microsoft’s documentation for the Azure IoT Edge deployment model. Namely – all different ways to deploy modules or module configurations to your Azure IoT Edge devices, and which takes precedence over which. Problem The documentation for Azure IoT Edge is surprisingly immature. As you go about your first projects, you will run into all kinds of gaps. One of the things I ran into that definitely required some clarification was which deployment takes priority when you deploy…Continue reading Azure IoT Edge order of deployment operations

SOLVE ALL THE ERRORS!

How to fix “This file does not have an app associated with it for performing this action” in Windows 10/11?

Another fun Windows-related debugging article! This time, I had to dive in to find a fix to an error along the lines of “This file does not have an app associated with it for performing this action.” constantly popping up on my Windows 10 workstation. While I had this error constantly popping up, the same fixes should apply to the situation when the error only comes up when you’re actually trying to open a file. Problem The error looks somewhat like the below: This file…Continue reading How to fix “This file does not have an app associated with it for performing this action” in Windows 10/11?

SOLVE ALL THE ERRORS!

How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

Have you run into this puzzling error? It comes in a couple of flavors, but it boils down to you failing miserably when you run the create_hypertable() function on your PostgreSQL TimescaleDB database server! Annoyingly, it might mean that the whole function is missing (extension is not installed or loaded) or that your parameters are not properly parsed (an issue with your command). I know, that it sucks. I have been there. That’s why I wrote this article! Problem You’re trying to transform your PostgreSQL…Continue reading How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

Docker is the unfortunate future

Solving “invalid reference format.” when trying to run “docker whatever”

So another simple one. (I just seem to run into all of the issues whenever I try to do the simplest thing with Docker!) Or with anything, I guess – but yeah, that’s another article then! Problem I was trying to run a Docker container called Syslog-ng, and had to add quite a few parameters in order to map the volumes and ports that I needed. Any time that I would run it, I’d get a really non-descript error message. This is what I ran:…Continue reading Solving “invalid reference format.” when trying to run “docker whatever”

Not sure if a bug or a feature

Azure DevOps incoming webhook just won’t fire? Easy (stupid) fix!

This article documents a simple but annoying fix to an issue with Azure DevOps. In this particular case, an incoming webhook (configured as a service connection) would fail to fire, no matter what. It turns out that it’s a bug in Azure DevOps – who would have thought :) Luckily, there’s a fairly simple workaround available! Problem A colleague was configuring a new pipeline in Azure DevOps. It was supposed to fire based on an external webhook that was defined as a service connection to…Continue reading Azure DevOps incoming webhook just won’t fire? Easy (stupid) fix!

IIS 10 welcome splash

How to install IIS (Internet Information Services) on Windows 10?

It’s the roaring twenties again, cloud is the hot stuff, and nobody needs a server anymore. Right? Nope! I’ve been involved in more on-prem or hybrid projects in the last 12 months than in the last 3-4 years combined. There are plenty of industries and valid uses for still setting up on-prem servers. And quite often, that includes setting up IIS (Internet Information Services) on said machines. And of course, there’s the classic use case – local development. Depending on what you’re trying to achieve,…Continue reading How to install IIS (Internet Information Services) on Windows 10?

Home Assistant logo

How to move the Home Assistant SQLite database in Docker on Windows?

This article explains how you can move your Home Assistant’s SQLite database files to another location by mapping them to another volume in Docker. Using Docker on Windows. Which might not be a smart move, but it’s one I went with anyway. The article will explain how to do this with docker-compose, but the steps pretty much apply to vanilla docker as well. With that said – let’s move on! Background Like so many times before, I was quite annoyed by the relatively small number…Continue reading How to move the Home Assistant SQLite database in Docker on Windows?

Azure IoT Edge is just Docker containers all the way

Azure IoT Edge gotchas – and how to overcome them!

This article describes the gotchas and weird one-offs that I’ve encountered with Azure IoT Edge so far. Consider them not-too-thoroughly tested quick fixes that aren’t significant enough to warrant an actual blog post themselves :) Okay – let’s get to them gotchas, then! Posts Related to “Azure IoT Edge gotchas – and how to overcome them!”:Azure IoT Edge order of deployment operationsHow to configure Azure IoT Edge deployments in Azure DevOps pipeline?How to update application settings of an Azure Functions App in Azure DevOps Pipeline

PostgreSQL everywhere

How to run SQL commands in a Postgre SQL Docker container?

This article will explain how to run your arbitrary SQL commands against a Postgre SQL database running in a Docker container in Windows. That should be super simple, but since I never remember anything like this by heart, I had to google it – and turns out, either I didn’t know how to google this properly or people haven’t bothered to document this. So, let’s fix that. But first, why did I need to do this, again? Problem So – I meant to run some…Continue reading How to run SQL commands in a Postgre SQL Docker container?

Damn you, WordPress!

How to modify CORS settings using a .htaccess file

Recently, I needed to host a web-based thingamajiggy in WordPress and needed to include a couple of custom libraries. For the sake of quick iteration, I decided to use a public FTP folder that I already had on the same server in order to host this. So I had configured a subdomain to host the files, and wanted to reference them from my WordPress site. Not quite a CDN, but something a little bit like that. Well, of course, I ran into an issue again.…Continue reading How to modify CORS settings using a .htaccess file

Vidyard logo

How to download audio files from Vidyard

Today, I’m documenting a simple way to download audio files from Vidyard. This approach only works for files that aren’t password-protected or behind authentication – I don’t think you can use it easily for nefarious stuff, but just in case you’re trying to commit some kind of IP theft (intellectual property), please don’t. And definitely do not ask for instructions in the comments section :) Anyway – why did I take up this task? What did I want to achieve, in order to need… This?…Continue reading How to download audio files from Vidyard

git logo

Visual Studio Code fails when running “git pull” for a new project

This article describes a simple fix to an issue (well… One or many possible issues), where git fails to pull anything from remote, throwing instead an error somewhat like this: fatal: no such branch: ‘master’ Bah. This stops you from pulling any new changes from remote, and likewise, it will stop you from pushing your new stuff out there. Always something going wrong with git, right? But what is the reason this time exactly? Problem So there I was, just following a guide on docs.microsoft.com.…Continue reading Visual Studio Code fails when running “git pull” for a new project

ClimaCell / tomorrow.io logo

No way to renew a ClimaCell API subscription – what to do?

One day I suddenly realized that my Home Assistant’s ClimaCell integration had stopped working. That was weird – it had been running just fine for a while. I had signed up for a ClimaCell developer account at developer.tomorrow.io (or whatever the address was before rebranding from ClimaCell to Tomorrow.io – but this is the portal that I used) on the 28th of July, perhaps in 2020, or perhaps 2019. And it had worked brilliantly so far, but suddenly and without warning, it just stopped working.…Continue reading No way to renew a ClimaCell API subscription – what to do?

Always ship Azure DevOps.

Azure DevOps suddenly 404s for your project? Easy fix!

This article explains a quick solution to a pretty common Azure DevOps problem. Namely – random and annoying 404 (or sometimes 401) errors when trying to access your dear team projects. I forgot to take screenshots of the errors and couldn’t figure out how to reproduce them, but hey, the fix is the main point, right? 😀 If you’ve ended up on this page, you’ve probably encountered the issue already, so why would you care about the screenshots anyway. Solution Ok, so this is a…Continue reading Azure DevOps suddenly 404s for your project? Easy fix!

Damn you, WordPress!

How to fix “Cannot read property ‘map’ of undefined (structured-data-blocks)”

So, once again, I find myself wasting time trying to fix WordPress. Though it is a powerful platform, it’s a never-ending source of grief when trying to maintain a site with a non-trivial number of plugins. Working with a static website creator would be much more fun, and there is a good chance that the site would stay up far more, but it would take considerable effort to set up Hugo or Gatsby – but we’ll see. We’ll see. Anyway, this time I had 2…Continue reading How to fix “Cannot read property ‘map’ of undefined (structured-data-blocks)”

Azure DevOps - Always Be Shipping!

How to update application settings of an Azure Functions App in Azure DevOps Pipeline

This article aims to patch one annoying gap in Microsoft’s documentation: how, exactly, do you update Azure Function App’s application settings using an Azure DevOps build/release pipeline? It sounds easy, and something that should happen almost automatically – and for Azure Web Apps (or App Services, as they are often called) it IS practically automatic. But for Azure Functions, it isn’t. And the docs aren’t perfect. Let me try and fix that. Problem Azure Functions won’t take your appsettings.json file, “mapping” your variable groups or…Continue reading How to update application settings of an Azure Functions App in Azure DevOps Pipeline

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 that you’ve made, and it’s all due to clumsy authentication implementation by…Continue reading Azure DevOps throwing “Unexpected token < in JSON at position 4"