What is, in my experience, the best way to get data from Azure Cosmos DB. In this blog, I will provide examples of how to set up a connection to Azure Cosmos DB in Azure Synapse Notebooks. And explain the difference between the analytical store and the operational store. In…

With Python and Azure PowerShell — In case you need to access an Azure SQL Database from your DevOps deployment pipeline to execute some custom script on a database. If you need to use something other than a username and password authentication and want to leverage Azure Active Directory, using an Access Token might be your…

Improve the quality of your solution from a DevOps perspective — Developing ETL or ELT solutions in smaller or larger teams has never been easier with the help of DevOps. It enables us to be certain that the solution still works after multiple team members made changes in different parts of the solution. For example changes in database stored procedures, tables…

Automatically sync multiple Outlook Calendars to one ‘main’ Calendar — Working as a consultant sometimes means having multiple mail addresses and calendars to manage. Up until now, I added Calendar events from my client manually to my ‘main’ calendar, just to keep it up to date for my colleagues and avoid two meetings at the same time. After multiple attempts…

Build a Power BI Report on Parquet files with the Serverless SQL Pool — Last week, 3th of December, Azure Synapse Analytics was announced to be General Available. Another reason to have some fun with a few of the new features in the Azure Synapse Workspace. …

With Kusto Queries and Diagnostic Logs — Recently I have been working with Azure Analysis Services (AAS) quite a lot. The number of tables in our model was quickly growing and processing times were fluctuating and increasing as well. Reason enough for me to find out a little bit more about which tables were taking up the…

Without adding the complete range of the datacentre — Since October 2017 it is possible to configure a firewall on your Azure Analysis Services. It is recommended to do this, since it adds an extra layer of protection to your AAS. By default, AAS accepts all incoming network traffic from any client. To be honest the firewall has very…