SharePoint is not broken - it just does't work

(Literally) Breaking: Changes to app authentication on SharePoint! 😵

This article explains how to get rid of sudden and unexplainable 401 Access Denied errors when trying to authenticate against a fairly fresh Microsoft 365 / SharePoint Online tenant. This issue seems to be caused by a long-ish project to finally retire ACS – Azure Access Control service) on SharePoint (it’s retired everywhere else already!) Note: This is an updating story, as the situation with ACS is definitely… Developing. Yeah, let’s call it that. It’s a developing situation. Problem In the beginning of September, a…Continue reading (Literally) Breaking: Changes to app authentication on SharePoint! 😵

Pulumi Azure Next-gen

Pulumi task on Azure DevOps fails with error “azureblob.OpenBucket: accountName is required”

This article explains how to fix one of the many issues you might face when configuring Pulumi deployments for your Azure DevOps Pipelines! The particular error you may run into was “azureblob.OpenBucket: accountName is required” – what a descriptive one, when there’s no accountName to be specified anywhere! But first – let’s get through the basics. Namely… “Pulumi?”, you ask – “What’s that?” Well, let me give you a 1-line response to that. One very long line, that is. But what was the error I…Continue reading Pulumi task on Azure DevOps fails with error “azureblob.OpenBucket: accountName is required”

Hacktoberfest 2020 - completed!

Hacktoberfest 2020

Another year, another Hacktoberfest, another haphazard participation and – as usual – another blog post a little bit late. Still, better late than never, and the event has become such a phenomenon I’m happy I did finish the challenge (or like DigitalOcean calls it – the celebration)! The event has a special place in my heart, as it did (in 2017, I think?) encourage me to contribute more to the community – not only by maintaining this blog but also by occasionally submitting a Pull…Continue reading Hacktoberfest 2020

Let me explain SharePoint...

How to access the site collection app catalog in SharePoint?

This article explains how to access the Site Collection App Catalog in SharePoint Online. I mean – yeah, I had to google it after getting back to SPFx dev stuff after a while, and realized the first few results were useless. Of course. So how did you do this now… Turned out to be pretty easy, and borderline obvious! Still, yet another thing to document. Solution So, back to basics – how do you access the Site Collection App Catalog on a SharePoint Online site?

Frequently Asked Robot Lawn Mower Questions

Frequently Asked Robot Lawn Mower Questions

This article is my attempt at documenting my experiences with Worx Landroid L2000. It’s a phenomenal little helper in your garden, but it will run into issues – and it’ll make you work a bit in order to get it to run efficiently! This article contains all of the gotchas I’ve run into so far, wrapped in a handy FAQ-format for your convenience (and mine, to be fair – I’ll be back to consult my notes later)! Most of the points should apply to a…Continue reading Frequently Asked Robot Lawn Mower Questions

Say "Dependency Injection" one more time I DARE YOU

How to inject EF Core DbContext in an Azure Function?

Ah, one more on the related topics of different configurations for your Azure Function apps. In this article, I’ll describe how you can configure the Entity Framework Core database context to be injected into your Azure Functions App. In my experience, this is a very typical and often-needed model to structure your Azure Functions, so while tooling and templates aren’t quite there, it’s worthwhile to document here. Solution I’ve posted before about how to instantiate a database context using DbContextOptionsBuilder – see a copy-pasteable example…Continue reading How to inject EF Core DbContext in an Azure Function?

Entity Framework - am I right?

“Conversion overflow” when reading numeric data from MS SQL database using Entity Framework

This article explains how to fix a weird situation where your .NET application utilizing Entity Framework or Entity Framework Core simply crashes without any way to recover or catch the Exception. You only get errors somewhere along the lines of “conversion overflow”. Ah – what a fun little issue! Problem So when you’re trying to instantiate an entity with a property of type decimal, you’ll get one of the 2 following exceptions with varying Call Stacks: Conversion overflow or: Arithmetic overflow error converting numeric to data type numeric…Continue reading “Conversion overflow” when reading numeric data from MS SQL database using Entity Framework

Azure Functions CLI - such a pretty logo for such an awesome functionality

How to configure Azure Function’s startup?

Azure Functions use dependency injection, and that allows us to define all kinds of prebuilt or custom-built services as being available for our functions really easily. This is a really easy way to initialize scoped resources to be used in your different functions… But how do you actually configure them in an Azure Functions App? Problem Okay, a step back – there’s a bit of a problem that we need to resolve before we can proceed with the configuration. When you create a new Azure…Continue reading How to configure Azure Function’s startup?

git logo

How to list your git stashes?

Long story short, yes, I really had to google this, and since top results seemed to give pretty obtuse answers, I decided to document it for myself. And just to state the obvious: I’m using GitHub Desktop for most of my mandatory Git stuff, but for whenever I have to run any git commands, I run Windows PowerShell (git exe is added to PATH variable). Solution Well, it’s actually very, VERY simple. You can just run something like this: The command outputs a nice list…Continue reading How to list your git stashes?

Powershell is hell

How to fix “System.InvalidOperationException: PowerShell Gallery is currently unavailable.”

This article explains how to fix an issue when updating a module in PowerShell. The error is something along the lines of: “System.InvalidOperationException: PowerShell Gallery is currently unavailable. Please try again later.” The whole error looks something like the one below, although you can probably get it for many different commandlets. Luckily, like usual, there are a few ways to fix this! Solution And with that, you should be good!

Microsoft Lists General Availability teaser image

How to change Microsoft Lists language?

I recently started playing around with Microsoft Lists. What a fun and friendly tool – makes SharePoint lists far more approachable offering a great editing experience, easy sharing, and hopefully in just a bit, awesome integrations and great mobile app (I mean, there’s iOS… But who has an iPhone in this day and age? 😉 However, as is usual in my tech endeavors, I immediately ran into an issue. Problem Some background: I’ve selected either EN-US or EN-CA as my locale everywhere on my work…Continue reading How to change Microsoft Lists language?

Visual Studio logo

How to remove your account as a guest in another Azure AD tenant?

This article explains how to fix your account, whenever it gets completely FUBAR due to your account being added as a guest in another AAD organization. And this might happen in multiple different situations – my most typical woe is Visual Studio’s Cloud Explorer, which stops showing me my subscriptions due to authentication against the other organizations failing. Add some extra difficulty by having someone in the other directory block your account from signing in, and you can’t even remove the account by any usual…Continue reading How to remove your account as a guest in another Azure AD tenant?

Spotify Premium logo

Is Lifetime Spotify Premium a scam?

This article describes another fishy online offering, Spotify Premium Lifetime subscription. Long story short, it’s a scam, just not a very heinous one. Depending on the calibration of your moral compass, it might even be worth it, although definitely not recommended. Let’s take a closer look at what’s going on with this criminal affair, then! A while back, I wrote an article about cybercriminals stealing your money and your data, if you buy an “Office 365 Lifetime subscription”. Just for the record: it’s not a…Continue reading Is Lifetime Spotify Premium a scam?

Azure Active Directory, the advanced logo

How to fix “AADSTS50011 – The resource principal named was not found in the tenant”

Another day, another variant of AADSTS50011! With a lot of apps and web services using Azure Active Directory for authentication, you’re bound to run into issues, right? Ah well, one would hope to avoid them. But at least this one is usually easy to fix! Problem I’ve encountered 2 different variants of this particular issue – the error message may or may not contain the name of the principal it’s looking for, and the guid of the tenant it’s looking for the principal in. AADSTS500011…Continue reading How to fix “AADSTS50011 – The resource principal named was not found in the tenant”

AADSTS50196 error message

How to fix error AADSTS50196 on Microsoft web properties?

This article explains how to fix error with error code AADSTS50196. This issue usually comes up with an error message somewhat like “The server terminated an operation because it encountered a client request loop.” The error seems to be popping up more and more often. No worries – it wasn’t caused by you! It is, in fact, an unintended side effect of a security hardening feature in some browsers, and some outdated configuration on Microsoft’s end. Obviously, you could run into the issue on other…Continue reading How to fix error AADSTS50196 on Microsoft web properties?

MSDN-related queries in my Google Search Console data. There's quite a few...

The all-important MSDN Subscriber links

This article serves as a simple glossary of important MSDN Subscriber links that I always forget – links that Microsoft keeps updating, that is! I’ll be updating the post as need be :) And yes, I do feel a little bit ridiculous about creating an actual article about something as simple as a list of links to stuff that should be easily discoverable by any search engine. But I suppose it is what it is. Anyway, it seems to me like any time I need…Continue reading The all-important MSDN Subscriber links

"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.

Fixing issues with uploading pictures to WordPress Media Library

This article will go through different solutions for fixing issues with uploading pictures to your WordPress Media Library. There’s plenty of reasons that could cause this issue – and a couple of different ways to end up running into it. But fear not! I’ll be proposing a few different ways to fix the issue in your installation. Unlike some of the more aggravated users online suggest, this isn’t likely a bug in WordPress – rather, it’s a configuration / compatibility issue. Luckily, it’s usually something…Continue reading Fixing issues with uploading pictures to WordPress Media Library

Visual Studio logo

How to restore lost windows in Visual Studio?

This article explains how to restore any hidden windows in Visual Studio without resetting your whole window layout, by using a common keyboard shortcut. Problem We’ve all been there – you’re opening a new window in Visual Studio, but your keyboard shortcut or clicking the item in the menu simply seems to do nothing. The window doesn’t show up anywhere. Reason The reason for this (most of the time) is simple: you have the window popped-up and located outside your screen. This happens pretty much…Continue reading How to restore lost windows in Visual Studio?

Worx Landroid L2000 (WR155E) - an honest review

Worx Landroid L2000 (WR155E) – an honest review

In this article, I’m sharing my perspective and experiences of Worx Landroid L2000 – an autonomous lawn mower I’ve had for about 2 summers now. Hopefully, I’ll be able to help someone else make an informed decision about getting a puppy like this. Anyway – a step back, the 10k-feet view first, as usual. Robot lawn mowers are slowly becoming a commodity, but choosing the right one is still tough. The models are different, the marketing differs, the features and even the behavior of the…Continue reading Worx Landroid L2000 (WR155E) – an honest review

Dependency hell

How to resolve “Microsoft.Data.SqlClient is not supported on this platform.” in an Azure Function App?

Hah – another interesting one. This article describes how to resolve an error along the lines of “Microsoft.Data.SqlClient: Microsoft.Data.SqlClient is not supported on this platform.“, thrown by Azure Functions host. Apparently you can run into this issue either on your local development machine or even in Azure. Problem For me, this error popped up after some house cleaning tasks – dependency updates, merging feature branches… You know the stuff. And suddenly, while the Azure Function App would build and run just fine, my SQL calls…Continue reading How to resolve “Microsoft.Data.SqlClient is not supported on this platform.” in an Azure Function App?