DP-700 training: Workspace logging

Let's dig into something that's quite simple to implement: workspace monitoring. Whenever someone calls out that "something is simple to implement", your first response should be "Oh really?". Because simplicity is always in the eyes of the beholder. And sometimes the easiest solutions carry the most consequences. Or cost. Or both. Wording can be complicated, … Continue reading DP-700 training: Workspace logging

DP-700 training: create and manage shortcuts to data

Storage is cheap, so we don't have to worry about data storage costs. Though this might be true, at some point, a lot of data will start to cost a lot of money. And, like many of you, dear readers who are in business intelligence, we like to duplicate data. A lot. We ingest it, … Continue reading DP-700 training: create and manage shortcuts to data

DP-700 Training: Choose an appropriate data store

The best place to store your data is in a SQL Server database that no living being can ever access. The end. No, I'm kidding, of course. But there's an atom of truth in this joke. Because for years we, in the structured data industry, have always been convinced that a database is the best … Continue reading DP-700 Training: Choose an appropriate data store

DP-700 training: Create and configure deployment pipelines

In one of the earlier blogs, the topic revolved around everything Git. Git is a version control system where you can leverage CI/CD. I love Git, even though it has a habit of biting me severely in the parts I use to sit on. If you're not well versed in Git or have no option … Continue reading DP-700 training: Create and configure deployment pipelines

DP-700 Exam training: Configure OneLake workspace settings

OneLake, the OneDrive for all your data, the One Lake to rule them all or however you've heard it being described. Whatever you've heard, OneLake is the single storage on your tenant used to store all the data of your Fabric Capacities. About OneLake The core point to remember is that your tenant has just … Continue reading DP-700 Exam training: Configure OneLake workspace settings

Experiencing Microsoft Fabric Conference in Stockholm

After an almost full week of travelling, learning and meeting people, time for a short write up. Hello Stockholm! Or even hello Schiphol. When I walked up to the gate, it took the best part of a minute for the first Microsoft person to walk up to me and ask if I was on my … Continue reading Experiencing Microsoft Fabric Conference in Stockholm

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

Understanding Cross Workspace Data Transfer in Microsoft Fabric

When you open Fabric, the first thing you need to do is choose a so-called workspace. This serves as a container for all your Fabric items. You can have one or more workspaces and the design is entirely up to you. From one workspace to rule them all to one workspace for each set of … Continue reading Understanding Cross Workspace Data Transfer in Microsoft Fabric

Fabric Lakehouse Data Ingestion: CSV vs. SQL Scenarios

This blog will be a quite short one compared to the other blogs as it's more of an overview to show you the capacity of Fabric ingesting CSV files in their native format into a Lakehouse and ingesting SQL data into a table structure inside the Lakehouse. Simple, straightforward stuff without any form of modification. … Continue reading Fabric Lakehouse Data Ingestion: CSV vs. SQL Scenarios

Testing Microsoft Fabric Capacity: Data Warehouse vs Lakehouse Performance

I just can't seem to stop doing this, checking the limits of Microsoft Fabric. In this instalment I'll try and find some limits on the data warehouse experience and compare them with the Lakehouse experience. The data warehouse is a bit different compared to the Lakehouse, so I'll be digging into that one first. Then … Continue reading Testing Microsoft Fabric Capacity: Data Warehouse vs Lakehouse Performance