Microsoft Realtime Intelligence: the array that wasn’t

In a previous blog, I wrote about processing XML and that it's actually JSON after the first pass. So far, so good. But then I found out that not all data was returned. That's weird because it's really there. So, what's happening here? Follow me, and let's find out! The previous blog had this JSON … Continue reading Microsoft Realtime Intelligence: the array that wasn’t

Microsoft Fabric Realtime Intelligence: Processing XML, or are you?

I've been working for quite some time on a fun solution in Fabric Realtime Intelligence. We're processing XML files into a structured table. As you're probably aware, XML has its own... well, let's be nice and call them challenges. One thing I ran into was that an element contained several other elements. Usually, you'll see … Continue reading Microsoft Fabric Realtime Intelligence: Processing XML, or are you?

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: 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