DP-700 training: data masking

Data security is the most important part of our job as data engineers and data architects. There are very few use cases where people need to see all the data in full detail. I know, customers take a different view on this but in reality, do they really need every single detail? No, they do … Continue reading DP-700 training: data masking

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: Configure version control

This blogpost will be introductory to version control within Microsoft Fabric. If you've got the basics of this under control, you're welcome to refresh your knowledge in this blog or check out our points of view. Alternatively, you can dig into the blogposts by Kevin Chant who has a lot of good posts on this … Continue reading DP-700: Configure version control

Top Highlights from #MSIgnite 2024

By the time you read this, I'm guessing the big #MSIgnite announcements were yesterday. You can use that hashtag to find most of the posts on social media. And there were many, very cool, announcements! Let me quickly take you through my favourites. Databases! As I still love the DBA work, announcing SQL Server 2025 … Continue reading Top Highlights from #MSIgnite 2024

Mastering the DP-700: Your Guide to Microsoft Fabric Certification

For those of you who either attended Fabric Conference Europe and/or have some sort of social media account, it won't come as a huge surprise that Microsoft is launching a new certification. If you're working with Microsoft Fabric and focusing on the data engineering part of things, this certification is for you! What is it? … Continue reading Mastering the DP-700: Your Guide to Microsoft Fabric Certification

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

Fabric Conference key note first thoughts

Blog Alert! Arun Ulag shared some neat new developments on #MicrosoftFabric at the keynote. Here are my first thoughts on them! #mvpbuzz #FabCon

Loadtesting Fabric part 2, bringing Pain to Powerbi

In my previous blog on Fabric and loadtesting, I ended with not really knowing how PowerBI would respond to all these rows. After creating and presenting a session on this subject, it's time to dig into this part of Fabric as well. There were questions and I made promises. So here goes! This blog will … Continue reading Loadtesting Fabric part 2, bringing Pain to Powerbi