Transforming Team Dynamics with the Leader’s Toolkit

First impressions When I got the package in the mail and opened it, I noticed it was similar to the Pip Decks box I reviewed earlier. The box has the same size and a similar design. The same goes when you open the box. Similar-sized cards and a more or less comparable structure. They feel … Continue reading Transforming Team Dynamics with the Leader’s Toolkit

DP-700 training: Item Level Access

In the previous blog post, I wrote about workspace-level Access. With the four levels of access that can be defined, this wasn't too hard. Let's make it a little harder and see if we can prevent mishaps in the different items within our workspace. In other words, let's regulate access to the different items because … Continue reading DP-700 training: Item Level Access

DP-700 Training: Data transformation options

Welcome to my Ted Talk, data transformation is done in T-SQL. Thank you. Well, yes once upon a time, maybe. Nowadays there are many more ways that lead to the dark side (also known as data vault) and the happy side (also known as the star schema or dimensional model). Did I lose you yet? … Continue reading DP-700 Training: Data transformation options

What to Expect from the DP-700 Microsoft Certification Exam

About two weeks ago, the DP-700 (Microsoft Fabric Data Engineer) went into beta. This means that curious people like me can take the exam, see what's in it and provide feedback to the people who wrote the questions. To add to fun, I decided to take the exam online as the exam centres close by … Continue reading What to Expect from the DP-700 Microsoft Certification Exam

Fixing Azure SQL Client Connection Timeouts

This blog won't be very long and will describe a connection issue I experienced with a customer including the solution and some context why this solution worked. I hope this saves you time when dealing with the same error. Issue The customer can connect to the Azure Sql database with Sql Server Management Studio (SSMS) … Continue reading Fixing Azure SQL Client Connection Timeouts

Microsoft Fabric Copy Job: Simplifying Data Ingestion

Very recently, Microsoft announced the public preview of the Microsoft Fabric Copy Job. This blog will give an explanation of what a Copy Job is, how to create one and why it can be an enormous help in speeding up your data ingestion. What it is The copy job is essentially an abstraction of a … Continue reading Microsoft Fabric Copy Job: Simplifying Data Ingestion

Microsoft Fabric Dataflow Gen2: In-depth Performance Evaluation and Capacity Insights

In my previous blogs, I've been hammering Fabric with data from some different angles. Either with the Copy dataflows, notebooks, Pipelines, Data Warehouse SQL scripts or in PowerBI.This time, I'm going to make the dataflow Gen2 work for it's money. As usual, I'm using the F2 capacity as it's the one that should break the … Continue reading Microsoft Fabric Dataflow Gen2: In-depth Performance Evaluation and Capacity Insights

Not every SQL is created equal

Yes I know, clickbaity cheesy title. This blog is a bit like that, but maybe you'll learn something as well. Issue In short, what I was facing today was a trial migration from System A to System B. Which means that data has to flow from one system to the other. System A is a … Continue reading Not every SQL is created equal

Microsoft DP-600 exam (beta) experiences

Today I took the Implementing Analytics Solutions Using Microsoft Fabric exam and in this blogpost I'll write about my experiences and feelings. There are other blogposts out there for you to read and compare experiences. Remember that all of these are personal views on the exams and opinions can differ. Preparation There's no way you'll … Continue reading Microsoft DP-600 exam (beta) experiences

Microsoft Fabric, comparing the F2 with the preview F64

If you've been having fun with Microsoft Fabric, chances are you've been playing around with the F64 capacity trial. This one is given to you by Microsoft for free but, since the GA data, the timer attached to it is counting down the days until you need to buy your own. Most blogs I've read … Continue reading Microsoft Fabric, comparing the F2 with the preview F64