Azure DevOps - Always Be Shipping!

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.json file, “mapping” your variable groups or…Continue reading How to update application settings of an Azure Functions App in Azure DevOps Pipeline

WebSockets.

How to test a WebSocket connection directly 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! In the sample found in a few paragraphs below, we’ll instantiate a WebSocket…Continue reading How to test a WebSocket connection directly in browser

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

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… :) Essentially, your editor view in Azure DevOps times out and you risk losing any changes that you’ve made, and it’s all due to clumsy authentication implementation by…Continue reading Azure DevOps throwing “Unexpected token < in JSON at position 4"

Microsoft. Word.

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…Continue reading How to copy a table in Microsoft Word (Office app)?

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 bottom line is – this shouldn’t be complicated. And it should be documented really well.…Continue reading How to (easily) move data between SQL databases