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 →
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,…