Welcome to a series of three blogs where I'm going to explore Azure Sql Copilot. This series will portray a lot of my experiences trying out Azure Sql Copilot. The first blog will feature a short introduction and an introduction on Copilot security. The following blogs will focus on a lot of testing. Remember, AI … Continue reading Sql Server and Copilot. What the query it this? Part 1, introduction
I had an interesting morning trying to connect Dynamics to a Data lake. As you might know, there was a feature where Dynamics would create a Data lake for you. This choice will cease to exist quite soon and to offer alternatives, you can create an Azure Synapse Link or Fabric Link. This blog will … Continue reading Creating Azure Synapse Link for Dynamics: Step-by-Step Guide
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
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
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
I've just returned from Lingen, Germany after the DataGrillen event. This year, I wasn't only attending (which you should do as it is one of the best events) but for the first time, I was also selected as a speaker. Speaker dinner The evening before the event, there was the speaker dinner. It was a … Continue reading Attending and speaking at Datagrillen 2024
Blog Alert! Arun Ulag shared some neat new developments on #MicrosoftFabric at the keynote. Here are my first thoughts on them! #mvpbuzz #FabCon
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
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
Every now and then a special event comes up where you can’t help but think “I really, really want to be there”. This happened to me with Data Moshpit in Berlin and again with Fabric February. When the first information dropped, I was waiting for both the call for speakers and the ticket sales. There … Continue reading Speaking experiences at Fabric February, Oslo
Reitse's blog 