Remove Duplicate Rows from a SQL Table
A small reminder for myself:delete t from (SELECT *, DupRank = ROW_NUMBER() OVER ( PARTITION BY PurchaseOrderNumber, LineNumber …
Deploy Azure Durable Function with Zero Downtime
RequirementTo deploy a new version of an Azure Durable Function using Terraform to a Function App with zero downtimeRelease PipelineThe production deployment is triggered when a modification to the main…
Connect to Key Vault from a Local Azure Function Instance
I was having an issue debugging an Azure Function locally. The start routine loaded the Key Vault secrets into config to be used later:var secretClient = new SecretClient( new Uri($"https://{keyVault.KeyVaultName}.vault.azure.net/"), …
Remote Debug Azure Function
See: Remote debug your azure function app v2 in Visual Studio 2019 - Krish Kothapalli BlogProcess:Debug > Attach to process...Key in the functions website address:pop-func-weu-d-justenoughd365import-01.azurewebsites.net:4024 Found…
Logic App XML Transform Ignoring XSLT Output Attributes
It seems Microsoft have still not fixed this one. When using a XML Transform shape in a Logic App, the output XML always contains the XML declaration and the action…
Logic App Deployment Failed Due to a Called Azure Function not being Started
This is where I found the resolution: Encountered an error (Forbidden) from extensions API. – Adventures in Software (benoldfield.co.uk)
BizTalk Orchestration and the #error “Errors exist for one or more children.”
I could not build a BT project because of an error reported in an orchestration: "Errors exist for one or more children.". The orchestration was added as an existing item…
Slow Visual Studio Performance
I was seeing really slow build times in my VS solution ~30 minutes. I thought this had something to do with my work's network, little did I know it was…
Connection String
Open Notepad Save the blank file as myConnection.udl Close notepad Double-click the udl file you just saved Fill it in and test it until successful Once succesful, close the udl…