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 →
[HOWTO] Focus Material UI v4 TextField on button click
In a project I'm currently working I had to set the focus to a Material UI (MUI) version 4 TextField as soon as a button gets clicked. As another input field should be focused after page is loaded, autoFocus did not do the trick. Furthermore the MUI TextField is rendered conditionally. After some research and... 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 →
The ultimate Gmail trick
Recently, a colleague at work told me a great Gmail trick that I'd like to share here. You can add a + sign at the end of the local part of your email address followed by an arbitrary combination of words and/or numbers. Example: yourusername+test1234@gmail.com Emails sent to such variants of your Gmail address will... Continue Reading →
Microsoft Graph REST API pitfall $expand
Last week I fell into a Graph REST API pitfall. In a customer project we implemented an interface that abstracts the interaction with Azure Active Directory (AAD). It defines a method that loads all users of a specific AAD group. The implementation of this interface interacts with Microsoft Graph REST API using GraphServiceClient. The code... 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] Convert Image File to SQL data type varbinary using PowerShell
In one of the projects I'm currently working on, I needed to insert a PNG file into a database column of type varbinary. I failed with my first attempts, but thanks to some blog posts and some threads on StackOverflow, I was able to come up with the following solution by assembling some of the... 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 →
Relaunch with new host and new design
After having a blog hosted on GitHub using GitHub pages I decided a few months ago to restart blogging from scratch at wordpress.com. Currently I'm setting up everything properly. My goal is to release the first blog post before the end of 2021. Afterwards I plan to regularly provide content concerning solutions for challenges I... Continue Reading →