All Posts

All Posts (560)

• 

  Published on

  2021-07-05 5:08 a.m.

  Authors

  koskila

  Tags

  GutenbergPhpmyadminWordPressYoast

  How to fix "Cannot read property 'map' of undefined (structured-data-blocks)"

  So, once again, I find myself wasting time trying to fix WordPress . Though it is a powerful platform, it's a never-ending source of grief when trying to maintain a site with a non-trivial number of plugins. Working with a static website creator would be much more fun, and there is a good chance that the site would stay up far more, but it would take considerable effort to set up Hugo or Gatsby - but we'll see. We'll see. Anyway, this time I had 2 issues with WordPress - both related to Yoast!

  Read more →
• 

  Published on

  2021-06-29 2:47 a.m.

  Authors

  koskila

  Tags

  AzureDevOpsAzureFunctionsDevOps

  How to update application settings of an Azure Functions App in Azure DevOps Pipeline

  This article aims to patch one annoying gap in Microsoft's documentation: how, exactly, do you update Azure Function App's application settings using an Azure DevOps build/release pipeline? It sounds easy, and something that should happen almost automatically - and for Azure Web Apps (or App Services, as they are often called) it IS practically automatic. But for Azure Functions, it isn't. And the docs aren't perfect. Let me try and fix that. Problem Azure Functions won't take your appsettings.

  Read more →
• 

  Published on

  2021-06-22 5:13 a.m.

  Authors

  koskila

  Tags

  JavaScriptWebsockets

  How to test a WebSocket connection in browser?

  This article documents a neat and simple way to establish and test a WebSocket connection, using just vanilla JavaScript and your favorite browser's developer tools. Quick and easy - no external tools or libraries required! This is neat because you don't want to have your information (credentials, hostnames, or even test data) leaking to outsiders hosting the tools - and using any external tools can be a bit of a drag anyway!

  Read more →
• 

  Published on

  2021-06-17 6:28 a.m.

  Authors

  koskila

  Tags

  AzureDevOps

  Azure DevOps throwing "Unexpected token < in JSON at position 4"

  This article documents one of the simplest solutions to one of the simplest issues you might ever encounter with Azure DevOps. Still: it's a pretty annoying one, and the solution - as simple as it is - seems worth documenting for the next time I'm googling this fervently as I'm afraid of losing my unsaved changes again...

  Read more →
• 

  Published on

  2021-06-15 4:04 a.m.

  Authors

  koskila

  Tags

  MicrosoftOfficeMicrosoftWord

  How to copy a table in Microsoft Word (Office app)?

  This article will document a super simple solution to an infuriating and stupid issue you might run into in Microsoft Office Word. Or maybe you might not, but I did. Can you tell I'm just sharing my own pains and whatever I needed to google and didn't find a solution for? Yeah, another one of these. But hey - maybe that'll be useful to someone else, too! Problem Long story short - copy-pasting this: Becomes this: WHAT - that's not a table. That's just weirdly spaced text in neat-ish columns.

  Read more →
• 

  Published on

  2021-06-08 6:25 a.m.

  Authors

  koskila

  Tags

  AzureSQLSqlServerManagementStudioSSMS

  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 bottom line is - this shouldn't be complicated. And it should be documented really well.

  Read more →
• 

  Published on

  2021-05-31 4:51 a.m.

  Authors

  koskila

  Tags

  LogicappMicrosoftFlow

  How to fix a Logic App deployment that failed with error "UsageConfigurationNotSupportedInSubscription"?

  This article explains a quick and dirty fix when you get an error somewhat like this: "UsageConfigurationNotSupportedInSubscription" when you're deploying an Azure Logic App from a template. The same fix will probably apply to a number of other issues - but don't hold me accountable for this :) Anyway - on to the topic of the day! Problem Can you tell by some of my recent blog posts that I've been deploying a few Logic Apps recently?

  Read more →
• 

  Published on

  2021-05-25 2:44 a.m.

  Authors

  koskila

  Tags

  AzureAzureCLIAzureAD

  How to add an user or group to multiple Azure resources at once?

  This article describes a solution to an age-old question of mine: how can I add an Azure Active Directory object - like a security group - to multiple resource groups at once? I've had to do this multiple times, and manual work takes quite a while. And who likes multiple manual steps?

  Read more →
• 

  Published on

  2021-05-17 5:54 a.m.

  Authors

  koskila

  Tags

  PowerShell

  Solving "Unable to find repository 'https://www.powershellgallery.com/api/v2'."

  So, you're running a PowerShell command that requires a connection to PowerShell gallery, but you run into an error message, somewhat like this: "Unable to find repository 'https://www.powershellgallery.com/api/v2'. This can happen when you're running something like Install-Module or Update-Module . This pretty much blocks you from doing anything that would require the use of new modules - so, quite a lot. Worth fixing, then.

  Read more →
• 

  Published on

  2021-05-10 8:58 p.m.

  Authors

  koskila

  Tags

  LogicappMicrosoftFlowPowerAutomate

  How to move your Microsoft PowerAutomate Flow to Logic Apps?

  This article explains how you can export a Microsoft Power Automate Flow from, well, Microsoft Power Automate, and nicely and easily import it to Azure Logic Apps. I'll explain the process step-by-step, and also explain solutions to a few hurdles you might run into! But first, let's take a look at why you might want to consider taking this step in the first place, shall we? Why move to Logic Apps? Ah, a valid question.

  Read more →
• 

  Published on

  2021-05-04 5:03 a.m.

  Authors

  koskila

  Tags

  RccOpinion

  Resolving an incredibly pointless struggle with RCC

  Okay, this might be my least general, and overall most pointless article ever, but I felt the need to document it anyway. Maybe it'll help someone with a similar gadget, despite being a bit off-topic on this blog. Apologies to any regular visitors! So, what am I talking about, then? Recently I bought a radio-controlled projector clock as a gift for my wife.

  Read more →
• 

  Published on

  2021-04-29 3:21 a.m.

  Authors

  koskila

  Tags

  NetFrameworkWCFSharePointOnline

  How to force an outdated .NET project to use TLS 1.2?

  This article explains a kind of weird fix to a pretty annoying issue with a legacy service. And I'm not just calling it legacy because it's WCF - I'm calling it legacy because it's old. The particular piece of software was developed about 7 years ago (2014-ish)! It had worked for quite a while - but now it was down. I know, I know - 2014 is not THAT old. There's surely COBOL that's been running since the 70s, if not before.

  Read more →
• 

  Published on

  2021-04-22 8:02 a.m.

  Authors

  koskila

  Tags

  AzureAzureARMLogicappMicrosoftFlow

  How to fix a Logic App deployment that failed with the error "ApiNotFound"?

  This article explains a quick and dirty fix when you get an error somewhat like " ApiNotFound " when you're deploying an Azure Logic App from a template. This seems to be a very typical hurdle to run into when you're trying to deploy a PowerAutomate Flow you've exported. I guess despite being built on the same platform, Flow developers took some liberties and the migration is not quite as painless as one would hope... :) Anyway - on to the topic of the day!

  Read more →
• 

  Published on

  2021-04-21 11:46 a.m.

  Authors

  koskila

  Tags

  dotnetLocalization

  Experiment: DateTime formats

  This article explains how to loop through all supported cultures on any given machine that's able to run .NET. The code sample is in C# and outputs an HTML table you can copy - but obviously you can adapt it to your needs! This was something I needed to support some weird documentation task way back when - and it took me like a year to finish this blog post and push it out from the drafts... Background Okay.

  Read more →
• 

  Published on

  2021-04-15 8:17 p.m.

  Authors

  koskila

  Tags

  AzureLogicappPowerAutomate

  How to fix "LinkedAuthorizationFailed" when deploying an Azure Logic App?

  This article explains one possible fix to "LinkedAuthorizationFailed" when you're deploying a Logic App from an Azure Automation template. Maybe it'll apply to other cases, too - but in my case, it helped me fix a broken template I had exported from Power Automate and was bringing into Logic Apps. Problem So, another fun issue to solve! The actual error you run into might be something along these lines: The client has permission to perform action 'Microsoft.

  Read more →
• 

  Published on

  2021-04-13 9:22 p.m.

  Authors

  koskila

  Tags

  MSBuildVisualStudio2019DevEnvironmentVisualStudio

  How to fix a build configuration that's not available as a build directive in Visual Studio?

  This article describes how to fix and tweak your pre-build directives in Visual Studio - just in case they refuse to work properly. Because yeah, apparently that sometimes just randomly happens. But fear not - there's a stupid and ugly, but definitely thoughtful workaround available! Also, sorry for the confusing title. I'm taking suggestions for a more descriptive one - but this one was kind of difficult to word clearly. Anyway - on to the topic of the day!

  Read more →
• 

  Published on

  2021-04-08 2:33 a.m.

  Authors

  koskila

  Tags

  AzureDevOpsNuGet

  How to access invisible packages in Azure DevOps artifact feed?

  Let's go with a very simple "note-to-self" kind of a blog post today. Plenty of those to go around on this blog, and I am sure that there will be plenty more! This one is another case that should be really obvious, but isn't, and should just work, but doesn't. Namely, when you have run a pipeline in Azure DevOps expecting it to publish a package in your internal NuGet feed so that all of your friends can use it.

  Read more →
• 

  Published on

  2021-03-31 10:26 a.m.

  Authors

  koskila

  Tags

  PowerShellPrinters

  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.

  Read more →
• 

  Published on

  2021-03-24 5:25 a.m.

  Authors

  koskila

  Tags

  ActiveDirectoryAzureAD

  Guide: How to take over and kill a viral AAD tenant?

  Rogue Azure Active Directories don't sound like a huge and widespread problem, but Microsoft's approach of generating unmanaged, viral AAD tenants whenever they encounter the tiniest reason to do so MUST be driven by some weird internal scorecard where "number of tenants" has a lot of weight, because you do get an Azure AD tenant really easily, and getting rid of one is surprisingly laborious. This guide aims to explain what's the quickest way to remove one.

  Read more →
• 

  Published on

  2021-03-18 8:12 a.m.

  Authors

  koskila

  Tags

  PowerShell

  Listing all of the assemblies loaded in a PowerShell session?

  In this article, I'll do my best to explain how to list all loaded assemblies in a PowerShell session. You see, PowerShell is great at caching assemblies in the weirdest possible way, so ending up with all kinds of mismatches in loaded DLL versions is pretty common. Or just being plainly blocked from loading a new one as you already have a cached reference. I mean, I've run into all kinds of issues even if I only use PowerShell occasionally. Maybe that's the reason.

  Read more →
• 

  Published on

  2021-03-15 2:01 p.m.

  Authors

  koskila

  Tags

  OpinionValoIntranet

  Of Course I Still #ValoLove You

  Long story short: My 6-year career with Valo is now coming to an end. Today was my last day at Valo. This is the longest I've ever worked at a company, and I've had the time of my life in the many positions I've held within Valo / Blue Meteorite. Rarely does a company offer you so many different possibilities and options - and let you grow into the role that you're looking to fill, with any support you might need.

  Read more →
• 

  Published on

  2021-03-08 4:34 a.m.

  Authors

  koskila

  Tags

  EntityFrameworkCoreEFCore

  How to fix "No database provider has been configured for this DbContext" in EF Core?

  I'm using Entity Framework in most of the projects that I'm working on - and for the most part, it's a pleasure to work with. But as always, there are plenty of chances to run into issues... So obviously, I stumbled into all of the rare stuff that IS broken! This one I hadn't really seen before: "No database provider has been configured for this DbContext" . This time I encountered the issue while setting up a new project and getting started working on the model.

  Read more →
• 

  Published on

  2021-03-04 2:11 p.m.

  Authors

  koskila

  Tags

  AzureDevOpsRobotFrameworkYAML

  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 YAML for your convenience. Well - and mine.

  Read more →
• 

  Published on

  2021-03-03 5:42 a.m.

  Authors

  koskila

  Tags

  AzureFunctions

  "Missing value for AzureWebJobsStorage in local.settings.json" when debugging Azure Functions locally?

  Another day, another issue with Azure Functions ! For such a simple and powerful tool, it sure does produce a lot of topics for blog articles! 😁 So, in this article, I'm explaining a couple of possible reasons why you might get an error along the lines of " Missing value for AzureWebJobsStorage " when debugging Azure Functions locally. But before jumping into the solution(s), let's take a closer look at the issue at hand, shall we?

  Read more →
• 

  Published on

  2021-02-24 11:34 a.m.

  Authors

  koskila

  Tags

  GutenbergMicrosoftExcelWordPress

  How to copy-paste a table from Excel to WordPress without using plug-ins?

  So, I tried to paste a table from Excel into WordPress, and I failed. Annoying - but not a big problem. I can just paste it into an existing table and it'll "sort itself out", right? Well, no. Exporting the Excel sheet as a html page and copy-pasting the table from there didn't work either. Actually, copy-pasting a table just didn't work at all. So... WordPress is unable to understand HTML tables. Is that really it? Well, no, again, it's not.

  Read more →