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] 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 →