ClickOnce signing from Azure DevOps via Azure Key Vault

To publish a WPF application from a CI DevOps pipeline I needed a command line tool to sign ClickOnce manifests and executables. The certificate is an EV Code Signing Certificate stored in an Azure Key Vault. After some research I found tools to sign executables, but no tools to sign […]

Read More

PostgreSQL powerful LATERAL join

PostgreSQL supports the SQL join type: LATERAL. Useful for creating advanced query’s. What is a LATERAL join? In the PostgreSQL documentation: Subqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns provided by preceding FROM items. (Without LATERAL, each subquery is evaluated […]

Read More

Cleaning Up Git Branches in Azure DevOps

Try again to delete tCleaning up Git branches is needed from time to time to keep the workspace organised. Using Azure DevOps most of the Git housekeeping tasks are automated. A typical default workflow follows these steps:– From a sprint work item, a new remote (feature/bugfix) branch is created.– Commit […]

Read More

Disable Visual Studio 2022 IIS security attach warning

Running Visual Studio as administrator is needed to host your web project in IIS. Everytime the debugger is started the “Attach Security Warning” confirmation dialog appears. Modify the registry to disable this.  Follow these steps to modify the private registry file (privateregistry.bin): 1. Close Visual Studio 2022. Start regedit.exe and […]

Read More

How to switch the active PostgreSQL cluster

A how to of switching the active PostgreSQL cluster version to make it bind to port 5432. Let’s define the active PostgreSQL cluster as the one that binds to port 5432 and having multiple versions running in Ubuntu. Check with pg_lscluster what is running: And what is the active PostgreSQL […]

Read More

Azure Portal Dashboard – Monitoring in een oogopslag

In de Azure Portal is het dashboard een krachtige tool om de status van de systemen te monitoren. Het dashboard is volledig naar wens aan te passen. Voor vrijwel alle systeemonderdelen van Virtual Machine tot AppService is een widget of grafiek op het dashboard te plaatsen. Hieronder een voorbeeld van een […]

Read More

The mystery of hanging batch script until keypress

Since Windows 10 and Windows Server 2016 I noticed that sometimes a batch or powershell script is hanging or freezing in the middle of an operation. It continues if the escape key is pressed. This also happens to my console application. So, I run it in debug mode from Visual […]

Read More

.NET event: From The Death Star to Open Source .NET Core by Scott Hanselman

Ongeveer 700 .NET enthousiastelingen kwamen 2 februari 2019 naar Den-Bosch om het .NET event bij te wonen georganiseerd door de .NET Zuid User Group en gesponsord door ABN AMRO Asset Based Finance. Scott Hanselman sprak anderhalf uur in Theater de Parade. Wat aan bod kwam is hoe Microsoft druk bezig is met de transitie naar […]

Read More