DP-700 training: Implement mirroring

If you come from an SQL Server background, mirroring will be familiar to you. It may be good or bad, but hopefully not at a nightmare level. Whatever your association with database mirroring, it is also available within Microsoft Fabric. What is mirroring If you're not coming from a SQL Server background, or any data … Continue reading DP-700 training: Implement mirroring

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

DP-700 Training: Process data using KQL

This post can come as a shock if you're used to writing T-SQL. Because not only is there more than one useful language to process data, realtime data in this case, but it also has enough similarities to SQL to look familiar and is different enough to leave you flustered. Now, to get a complete … Continue reading DP-700 Training: Process data using KQL

DP-700 training: exploring event streams

Microsoft Fabric really is a Swiss army knife when it comes to its possibilities. Not only capable of hosting your BI information which is usually loaded at night and analysed during working hours but it can also process real time information. Let's dig into that some more! Data Fabric architecture Before we go all nerdy … Continue reading DP-700 training: exploring event streams

DP-700 exam training: Configure Domain workspace settings

In the previous blog, you read about the Spark settings within the workspace. This time it's about the domain settings. So let's dig into what domains are, what you can use them for and which settings there are. What are domains? If you read (and you should) the excellent book on data architectures by James … Continue reading DP-700 exam training: Configure Domain workspace settings

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