Russia is a bad neighbor

Evil triumphs when good men do nothing

I never thought that I would write an article on this site of mine about war, peace and a threat to not only an entire nation’s existence, but mine, too. But as this website has some reach (there’s around 75 000 of you each month), I feel that I have a responsibility to say and do something. On February 24th, 2022, the fascist oligarchy known as Russia attacked yet another one of its neighbors. That’s almost not even newsworthy by itself – it’s happened multiple…Continue reading Evil triumphs when good men do nothing

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!) 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 Microsoft.Online.SharePoint.PowerShell. Problem I use PowerShell 7 as the default shell in my Windows Terminal. It doesn’t…Continue reading How to use Microsoft.Online.SharePoint.PowerShell with PowerShell 7?

SharePoint is not broken - it just does't work

How to fix “The website does not support SharePoint Online credentials. The response status code is ‘Unauthorized'”

While running some SharePoint Online -PowerShell commandlets, or connecting to a SharePoint Online site from your app, you get the following (or similar) error about your SharePoint Online credentials being unauthorized for something you should definitely be authorized to do: Cannot contact web site ‘https://[tenant]-admin.sharepoint.com/’ or the web site does not support SharePoint Online credentials. The response status code is ‘Unauthorized’. And that’s not all – by digging into the full error message, you find the underlying internal error: MSDAVEXT_Error=917656; Access+denied.+Before+opening+files+in+this+location%2c+you+must+first+browse+to+the+web+site+and+select+the+option+to+login+automatically. What awakens my curiosity,…Continue reading How to fix “The website does not support SharePoint Online credentials. The response status code is ‘Unauthorized’”

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?

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 a weird case – not something you would usually expect to run into! But as…Continue reading How to fix another weird Entity Framework Core dependency issue?

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?

Steve Ballmer has 4 words for you: Develop

How to get a free Office 365 Developer tenant?

In this article, I am pretty much just sharing one link – the one, where you can request a new free Office 365 Developer subscription. And while I’m not sure if anyone else ever needs to google for this, I am actually quite comfortable just documenting it for myself. Just like all of the other blog posts, really :) See, this is a thing I struggle with, because: I tend to need it often enough that I find myself looking for it, but seldom remember…Continue reading How to get a free Office 365 Developer tenant?

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

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, it takes me a while to get around to polishing things into a publishable form.…Continue reading How to configure Azure IoT Edge deployments in Azure DevOps pipeline?

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?

Visual Studio logo

How to fix Visual Studio throwing a “This syntax requires an imported helper named ‘__spreadArray’ which does not exist in ‘tslib’. Consider upgrading your version of ‘tslib’.

This one is something that I keep running into. Visual Studio just throws an error for a missing helper __spreadArray in a library that you didn’t even know you had installed, and you’re not sure if it should – or even can – be updated. I guess Visual Studio just refuses to give me a break :) But like with so many different issues, there are multiple fixes available! Problem So when trying to build your solution or start debugging in Visual Studio, you run…Continue reading How to fix Visual Studio throwing a “This syntax requires an imported helper named ‘__spreadArray’ which does not exist in ‘tslib’. Consider upgrading your version of ‘tslib’.

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 somewhat like this: The listener for function [function name] was unable to start. Microsoft.Azure.EventHubs.Processor: Out…Continue reading How to fix “The listener for function was unable to start. Out of retries creating lease for partition 0”

WebSockets.

Using role claims to target WebSockets

This article explains a (fairly) simple solution on how you can grab role claims – or any other claims with some tweaking – and use them as the basis for targeting your WebSocket messages. Very nifty, if you ask me, without all the enterprisiness of SignalR. Talking about SignalR, another way to implement pretty much the same thing, but with all of the enterprisey goodness of SignalR, is described in this blog post: How to access claims of a SignalR user in ASP.NET Core? That…Continue reading Using role claims to target WebSockets

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 try and make some sense of the whole Azure Storage emulating/exploring a side of things…Continue reading The simplest fixes to “500 (Internal Server Error)” from Azurite

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”?

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 can’t be instantiated if the database doesn’t exist on the server already. So, what do…Continue reading How to configure Azure PostgreSQL to allow Cloud Shell connections?

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”

Omnia Intranet by Precio Fishbone

Joining the Omnia team!

Exciting news right after the Easter break (and a bit of a change from the usual flow of technical stuff) – I’ve joined the Omnia team at Precio Fishbone. Over the last 12 months, I have been working mostly on Azure IoT projects and was already debating renaming the blog. The title #SharePointProblems matches the content poorly when most of my new posts are about Docker, Azure DevOps, or Entity Framework. But to those of you worrying about my blog’s Search Engine Optimization, I have…Continue reading Joining the Omnia team!

Let's fix all the problems!

Upgrade from WSL 1 to WSL 2 in Windows 10 to fix Docker

Okay – another one of the topics that I’m explaining probably more to myself than whoever’s reading this later. But that’s why I write this blog, so please bear with me. 🙂 Anyway, onto the actual issue at hand! I was configuring Docker on WSL on my Windows laptop for development purposes. That’s supposed to be easy – install WSL, install a distribution, install Docker, switch it to using WSL, fire up your WSL command prompt and run any Docker commands there (or deploy from…Continue reading Upgrade from WSL 1 to WSL 2 in Windows 10 to fix Docker

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!