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 like 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…Continue reading How to update application settings of an Azure Functions App in Azure DevOps Pipeline

WebSockets.

How to test a web socket connection in a browser

This article documents a simple and neat 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! The last line sends a simple payload down the WebSocket pipe, just to see if something happens. If there IS a response, we’ll be logging it in the console. Handy! The article does expect you to have your API already up and running, though :) Background WebSockets, they’re all the…Continue reading How to test a web socket connection in a 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 you’ve done, and it’s all due to clumsy authentication implementation by Microsoft.…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