PostgreSQL everywhere

How to store a complex object as JSON in a PostgreSQL database using Entity Framework (Npgsql)?

Okay, that’s a title and a half. But let’s see – what are we actually doing and why? In my particular case, I had to store a Dictionary<string, string> in a Postgres database. By default, that’s not something Entity Framework handles. But as usual, there’s a way around that – and the same concept we’ll take a look at below should work for other complex data types or objects too!…Continue reading How to store a complex object as JSON in a PostgreSQL database using Entity Framework (Npgsql)?

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

How to configure FQDN on a workgroup computer?

My ASUS AC-68U requires an external server with a Fully-Qualified Domain Name for any logging to be persisted beyond a reboot of the router. And since the router regularly needs rebooting (and will usually just automatically reboot if any errors are encountered), logging errors without them being persisted after a reboot is pretty useless. So, a computer with an FQDN I’ll need. But I don’t have a domain for my…Continue reading How to configure FQDN on a workgroup computer?

Dealing with ASUS hardware...

ASUS AiMesh tips and tricks

This post is meant to gather my tips and tricks for surviving life with ASUS AiMesh wifi routers. Draw on my experience so that your life would be easier :) A quick word of advice before you proceed, though: you’ll save yourself from a lot of trouble by buying actual networking gear instead of this flea market discount garden-variety rubbish. I got my ASUS AiMesh routers (RT-AC68U, RT-AC66U B1, and…Continue reading ASUS AiMesh tips and tricks

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!) that 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…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'”

Whilst 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…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…Continue reading How to refresh all Az CLI subscriptions?