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…Continue reading How to (easily) move data between SQL databases

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…Continue reading How to change printer paper size using PowerShell?

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…Continue reading How to run Robot tests on an Azure DevOps hosted agent?

"Post-processing of the image failed likely because the server is busy or does not have enough resources. Uploading a smaller image may help. Suggested maximum size is 2500 pixels." when trying to upload a picture to WordPress.

10 ways to fix “Post-processing of the image failed likely because the server is busy or does not have enough resources. Uploading a smaller image may help. Suggested maximum size is 2500 pixels.” error on WordPress – and a workaround!

This article will go through different solutions for fixing issues with uploading pictures to your WordPress Media Library. There are plenty of reasons that could cause this issue – and a couple of different ways to run into it. But fear not! I’ll be proposing a few different ways to fix the issue in your installation. And by “a few” I mean 10. Or more, if I have updated the…Continue reading 10 ways to fix “Post-processing of the image failed likely because the server is busy or does not have enough resources. Uploading a smaller image may help. Suggested maximum size is 2500 pixels.” error on WordPress – and a workaround!

Microsoft Azure logo

Enabling local cache for an Azure App Service

This article explains one easy way for you to improve the performance and uptime of your Azure App Service. I’ll explain a simple but kind-of-hidden and surprisingly badly documented feature – Azure App Service Local Cache, that is – which might make a huge difference. It sure did for me! Since it’s such a no-brainen, I’m kind of half expecting everyone else to already having known about this, but since…Continue reading Enabling local cache for an Azure App Service

Azure Active Directory (Azure AD)

How to find out the Directory ID of your Azure AD tenant?

This article explains in extremely short way, how to fetch your Azure Active Directory tenant’s Directory ID. Let’s make it short and sweet, because quite frankly, it is really simple! Solution Option 1: Use whatismytenantid.com for finding your tenant/directory id: Quick solution – works (at least) for all standard tenants: Navigate to https://www.whatismytenantid.com/ Enter the domain associated with your Azure AD instance (often like contoso.onmicrosoft.com) Let ShareGate do their magic…Continue reading How to find out the Directory ID of your Azure AD tenant?

Epic Visio Skills produced this cool illustration of Microsoft Teams extensibility!

How to fix a Teams team with no Owners?

As Teams adoption grows (partially driven by the megatrend of digitalization, partially by the massive surge in working from home due to Covid-19), different problems managing Teams also become more obvious. The growth seems to have been largely organic. Teams and organizations are adopting the tools that best help them get their work done with little regard to how the tools are maintained and best used. Teams are often created…Continue reading How to fix a Teams team with no Owners?

HTTP Error 500.32 - ANCM Failed to Load dll

How to fix “HTTP Error 500.32 – ANCM Failed to Load dll”

Yikes – ever ran into this error after deploying your ASP.NET Core web application to an Azure App Service? Yeah, me too. And when it’s a production deployment, and the error didn’t happen in test/QA environment, that’s even more fun. This article describes a couple of ways to fix it, though. You wouldn’t believe these 3 solutions to fix the error “500.32”, and what they look like now! Oh heavens,…Continue reading How to fix “HTTP Error 500.32 – ANCM Failed to Load dll”

Y2K20 - a new era of bugs

An easy fix for WordPress media uploads failing after a year/month change

This article explains one possible fix to a situation, where your pictures in WordPress fail to show up. In this particular case, uploading, editing and even selecting pictures for your articles works – just displaying them doesn’t work. Alternatively, programmatic access might fail as well: in my case, ShortPixel reported an error “There was an error and your request was not processed: Could not download the file (404 Not Found)”.…Continue reading An easy fix for WordPress media uploads failing after a year/month change

SOLVE ALL THE ERRORS!

App Service refuses connections with error: “No connection could be made because the target machine actively refused it”

This blog post describes a very specific fix to a very specific issue. In a software project that consisted of a desktop client application and some APIs hosted on Azure, we ran into an error where some connections to APIs would fail with an error like this: No connection could be made because the target machine actively refused it. What gives? Description Imagine this: You’re connecting to an API hosted…Continue reading App Service refuses connections with error: “No connection could be made because the target machine actively refused it”