Last week, my work colleague Guillem Bonafonte and I came across a suitable use case for WebJobs in context of a project. WebJobs is a feature of Azure App Service that allows to run a program or script on the same instance as a web app, web API, ... After consulting the documentation, we started... Continue Reading →
[NoBrainer] Define Azure Key Vault with embedded Access Policy in Terraform
azurerm (Azure resource manager) provider for terraform allows definition of Key Vault access policies either within the azurerm_key_vault resource via the access_policy block or by using the azurerm_key_vault_access_policy resource (using both methods for access policy management leads to conflicts). The advantage of defining Key Vault access policies within the azurerm_key_vault resource over defining azurerm_key_vault_access_policy resource(s)... Continue Reading →
[NoBrainer] Filter items on nested properties in Azure Cosmos DB Data Explorer
In this post I quickly explain how to filter items of a Cosmos DB container based on nested properties by using Data Explorer of Azure Cosmos DB account in Azure portal. Suppose there is a container named People and the following item structure. { "person": { "firstName": "John", "lastName": "Doe", "personId": "1234", "addresses": [ {... Continue Reading →
[HOWTO] Renew Client Secret of Azure DevOps Service Connection
When creating a Azure DevOps service connection of type Azure Resource Manager that uses authentication method service principal (automatic), a service principal and a app registration get created in the corresponding Azure tenant. Furthermore a client secret gets added to the app registration for the service connection. Unfortunately the client secret expires after two years... Continue Reading →
[HOWTO] Access Azure SQL Database with Microsoft SQL Server Management Studio 18 using AAD Authentication
As announced in my initial post, here is my first technical post - published just before the end of the year. A few weeks ago I wanted to access a Azure SQL database with a specific AAD user through Microsoft SQL Server Management Studio 18 using Azure Active Directory (AAD) authentication. To do so, I... Continue Reading →

