Mastodawn

Blog alert!

This time, a way to handle arrays that only have one element in KQL. A follow-up to the previous blog on XML and JSON.

#MicrosoftFabric
#ADX
#Kusto
#KQL
#JSON
#XML
#DataEngineer

http://sqlreitse.com/2026/03/17/microsoft-realtime-intelligence-the-array-that-wasnt/

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 bec…

Reitse's blog

Alberto Morillo 2d ago

What is Fabric connection inside Notebook
#Microsoftfabric #DataEngineering #JupyterNotebook
https://learn.microsoft.com/en-us/fabric/data-engineering/fabric-connection-with-notebook?wt.mc_id=DP-MVP-4015656

Fabric Connection in notebooks - Microsoft Fabric

Learn about how you can use a Fabric Connection to access external data sources directly in notebooks.

2meterdba | Reitse Eskens 3d ago

Blog alert!

A short one this time, on a nice find processen XML data in Realtime Intelligence.

#MicrosoftFabric
#RealtimeIntelligence
#XML
#Kusto
#KQL
#EventHouse

http://sqlreitse.com/2026/03/14/microsoft-fabric-realtime-intelligence-processing-xml-or-are-you/

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 …

Reitse's blog

Alberto Morillo 6d ago

Workspace-level IP Firewall rules in Microsoft Fabric
#DataSecurity #MicrosoftFabric #Azure
https://learn.microsoft.com/en-us/fabric/security/security-workspace-level-firewall-overview?wt.mc_id=DP-MVP-4015656

About workspace IP firewall rules - Microsoft Fabric

Learn about using workspace-level IP firewall rules for secure access to a Fabric workspace.

2meterdba | Reitse Eskens Mar 6

Blog Alert!

This time of getting the Data Api Builder MCP preview to connect to a Fabric Lakehouse SQL Endpoint using Entra ID.

#MCP
#DAB
#MicrosoftFabric
#Lakehouse
#SqlEndpoint
#EntraId

http://sqlreitse.com/2026/03/06/sql-mcp-local-to-fabric-lakehouse/

SQL MCP: Local to Fabric Lakehouse

Let’s be honest, you thought of doing this yourself. Connecting two tools that seem to serve very different purposes. But, as I had a day to fool around, I thought to myself, let’s see …

Reitse's blog

DB-Engines Mar 3

DB-Engines Ranking climbers of the month (March 2026):

1. @postgresql

2. #MicrosoftFabric

3. #MongoDB

http://db-engines.com/en/ranking

Alberto Morillo Feb 23

Fine-grained ReadWrite access to data with OneLake security
#OneLake #DataSecurity #lakehouse #MicrosoftFabric
https://blog.fabric.microsoft.com/en-US/blog/fine-grained-readwrite-access-to-lakehouse-data-with-onelake-security/?wt.mc_id=DP-MVP-4015656

Fine-grained ReadWrite access to data with OneLake security (Preview) | Microsoft Fabric Blog | Microsoft Fabric

Introduction to ReadWrite access Support for ReadWrite access controls within lakehouse items is a powerful new capability, now available in preview. This enhancement gives data owners the ability to grant precise write permissions to users—without requiring elevated workspace roles like Admin or Member. With ReadWrite access, workspace viewers or users with only Read access can … <a href="https://blog.fabric.microsoft.com/en-us/blog/fine-grained-readwrite-access-to-lakehouse-data-with-onelake-security/" class="more-link">Continue reading “Fine-grained ReadWrite access to data with OneLake security (Preview)”</a>

Justin Bird Feb 19

Happening Today! (2026-02-19)

Kev Chant joins us to discuss #MicrosoftFabric and #AzureDevOps - the story so far for 2026. Learn how to implement #CICD, Git integration, and deployment best practices. https://www.meetup.com/fabricpowerbiwales/events/312430627

Microsoft Fabric and Azure DevOps - The story so far for 2026 with Kev Chant, Thu, Feb 19, 2026, 6:00 PM | Meetup

**Description** Microsoft Fabric is growing in popularity as a Microsoft Data Platform offering. However, a lot of people feel challenged about how to implement CI/CD. In

Meetup

2meterdba | Reitse Eskens Feb 16

Blog alert!

I've revisited my loadtests in Fabric and wrote them down. Enjoy!
#MicrosoftFabric
#LoadTesting
#Lakehouse
#Warehouse
#Eventhouse
#FabricSQL

http://sqlreitse.com/2026/02/16/loadtesting-microsoft-fabric-part-ii/

Loadtesting Microsoft Fabric, part II

This blog can also be known as ‘The Sequel’, not to be confused with SQL, even though Fabric SQL will be mentioned in this blog. Anyway, I digress and don’t call me Shirley. For t…

Reitse's blog

Alberto Morillo Feb 15

Mirroring for SQL Server in Microsoft Fabric
#MicrosoftFabric #SQLServer #Dataanalytics #OneLake #AI #DataScience #ChangeDataCapture #DataReplication
https://blog.fabric.microsoft.com/en-AU/blog/mirroring-for-sql-server-in-microsoft-fabric-generally-available?wt.mc_id=DP-MVP-4015656

Mirroring for SQL Server in Microsoft Fabric (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric

In today’s AI driven world, analytics platforms are only as good as their data. With the ever-increasing amount of data being collected in various applications, databases, and data warehouses in an enterprise, managing and ingesting data into a central platform for purposes of analytics and AI is a cumbersome and costly process. Databases and data … <a href="https://blog.fabric.microsoft.com/en-us/blog/mirroring-for-sql-server-in-microsoft-fabric-generally-available/" class="more-link">Continue reading “Mirroring for SQL Server in Microsoft Fabric (Generally Available)”</a>