At Tuesday 6th of June 2023, I’m giving an online version of my session “Analyzing Azure Cosmos DB Data with Azure Synapse Link” (which I presented at Techorama). It’s a YouTube live stream for the Azure Cosmos DB global user group (and also Microsoft Reactor). The event starts at 1PM ET, which is 10AM PT, […]
Category: Varia
Change the Default Git Branch for a dbt Cloud Project
In dbt, you can link your project to a github account, which is obviously the right thing to do. By default, the project uses the main branch. But what if you have two dbt projects; one for dev and one for prd? And in the dev project, you want to change the default branch to […]
Get your Query History in Redshift
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for Redshift in the tool DBeaver. When you work with SQL Server Management Studio (SSMS), you typically don’t have this issue as a temporary copy is always […]
Star Schema Merchandising Available
Those of you who follow me on social media (twitter | LinkedIn | mastadon) or who read my blog here, might be familiar with my catchphrase “STAR SCHEMA ALL THE THINGS”. This slogan originated a couple of years ago when I had to convince some people that the star schema (aka the dimensional model) should […]
Speaking at Techorama 2023
I’m excited to announce I’ve been selected again as a speaker for Techorama 2023. Techorama is one of the biggest Microsoft-focused events in the European mainland, and it’s always a pleasure to be there. It’s organization is amazing and there are tons of interesting sessions. The first batch of sessions has just been announced, so […]
Build Once – Add Metadata (the importance of metadata-driven frameworks)
When working in business intelligence, data engineering or data in general, there are some “mantras” that are being adopted by the larger community as “best practices”. For example, I shout “STAR SCHEMA ALL THE THINGS” anywhere I can, because a star schema is the most optimal way to design your model in Power BI. We […]
Webinar – Data Warehouse Modernization
I’m delighted to announce I’m participating in a panel discussion about data warehouse modernization. The full title is “Data Warehouse Modernization – Crafting a Successful Migration Strategy Post Pandemic”. The webinar is hosted by Astera Software (they offer low-code ETL and data warehouse builder solutions) and I’m joined by Kent Graziano (retired data warrior at […]
Webinar – Intro to Azure Data Factory
I’m excited to announce I’m giving a webinar for MSSQLTips.com, with “Introduction to Azure Data Factory” as the subject. The webinar will take place at Tuesday May the 3th, at 6PM UTC and it’s free to attend. The abstract: Azure Data Factory (ADF) is the tool in the Azure cloud for creating your data pipelines. […]
Happy 2022
Or is it April 2020? Not sure. Anyway, I’d like to extend my best wishes for the upcoming year. I hope there will be many possibilities for the data community to come together and share knowledge in a safe and responsible manner. In case you’re wondering, here are my top 5 blog posts of 2021: […]
New Argument for STRING_SPLIT Function
A new (optional) argument has been added to STRING_SPLIT: enable_ordinal. Setting it to 1 will add an output column with the 1-based index of each item of the array. Nice. This is great if you want to preserve the order of the items. Let’s illustrate with an example: This returns the following result: As you […]