Posts from August 2022

Blog posts published in August 2022

← Back to all posts

Posts from August 2022 (6)

Published on

2022-08-30 5:47 a.m.
Authors

koskila
Tags

postgresql

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! Solution

Read more →
Published on

2022-08-23 6:57 p.m.
Authors

koskila
Tags

fqdn network

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 computers at home, so I don't really have Fully-Qualified Domain Names , either.

Read more →
Published on

2022-08-16 7:19 p.m.
Authors

koskila
Tags

aimesh asus wifi

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 RT-AC1750) at a deeply discounted price, and I still don't think they've been worth the trouble.

Read more →
Published on

2022-08-09 9:47 a.m.
Authors

koskila
Tags

powershell powershell7 windowsterminal

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 Microsoft.Online.SharePoint.PowerShell . Problem I use PowerShell 7 as the default shell in my Windows Terminal.

Read more →
Published on

2022-08-04 7:06 a.m.
Authors

koskila
Tags

authentication powershell sharepoint sharepoint-online

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

Read more →
Published on

2022-08-02 3:01 a.m.
Authors

koskila
Tags

azure azurecli powershell

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 with here?

Read more →