Just another software engineering blog
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
rufers blog 
In our case, we access the database with a .NET Core backend application using EntityFrameworkCore. Entity class defines a property…
Hi marc, how would you recover the png from the saved varbinary?
Hi Michael. There is for sure a way to do so in PowerShell. However it was not necessary in my…
Works out of the box, Thanks Marc for sharing! To validate the hex output I used a random online tool,…