The F-Files Podcast

Episode 013 - The mask falls for one

Five columns. One sensitive table. And only a handful of people who see what’s really there. In this episode, Frank and Kevin explore the invisible line between data protection and privileged access in Microsoft Fabric. With dynamic data masking enabled on the EmployeeData table, most users see only obfuscated results — but not everyone. They dive into: * How dynamic data masking works across Fabric’s data warehousing layer * The critical difference between SELECT and UNMASK permissions * Why masking rules are your first — and sometimes last — line of defense * Best practices for protecting fields like SSNs, email addresses, and more 🔍 The Mask Falls for One — because visibility isn’t just about roles, it’s about trust. 🎧 Tune in and uncover what lies beneath… if you're allowed.

Episode 012 - Deploy Devide

The content was identical. The configurations were not. And the damage? Very real. In this episode, Frank and Kevin uncover the critical importance of maintaining distinct settings between Development, Test, and Production environments in Microsoft Fabric. What looks like a smooth deployment often hides a dangerous assumption: that what works in one stage will work in all. They explore: * How to use selective deployment to control what actually moves forward * Why unique deployment rules per stage are non-negotiable * The danger of assigning one workspace across all environments * Real-world stories of environments gone rogue due to overlooked configs ⚠️ Deploy Divide is a reminder that content consistency means nothing without contextual integrity. 🎧 Listen now — before your next deployment crosses a line it shouldn’t.

Episode 011 - Escape from Hardcoded Hell

In this fiery episode of The F Files, Frank and Kevin find themselves deep in the inferno of inefficient pipelines, where static values, hardcoded paths, and inflexible components reign supreme. Data transformations are brittle, errors lurk in every corner, and updates require a full-scale rescue mission. But not all hope is lost. Armed with parameterization, string interpolation, and smart pipeline design, the duo sets out to break free from the shackles of hardcoding. Can reusable pipeline logic and dynamic inputs bring order to chaos? Or will they be trapped forever in a loop of copy-paste despair? Tune in to uncover: - How to use pipeline parameters for flexible, scalable design - The role of string interpolation in dynamic configurations - Real-world examples of escaping hardcoded nightmare scenarios Because in the world of data engineering… “Hell is other people's hardcoded pipelines.”

Episode 010 - The unauthorized push

The logs showed a deployment to Production. The problem? No one on the team admitted doing it. In this episode, Frank and Kevin investigate the chilling consequences of improper permission control in Microsoft Fabric deployment pipelines. When pipeline settings aren’t locked down, the line between authorized changes and accidental disasters gets dangerously thin. They uncover: - How to assign pipeline admin roles and why it matters - The difference between workspace permissions and pipeline access - Why role-based access control (RBAC) is your only real defense - Real-world horror stories of "harmless" edits with very real consequences 🔐 The Unauthorized Push is a cautionary tale about access, accountability — and what happens when you leave the door wide open. 🎧 Listen now. Before someone pushes something they shouldn't.

Episode 009 - Fabric Flux

One workspace in Dev. The same workspace in Prod. And somewhere in between… the rules started to bend. In this episode, Frank and Kevin dive into the chaos and complexity of deployment pipelines in Microsoft Fabric — where content transitions between environments are anything but linear. As teams demand selective deployment, backward promotion, and environmental isolation, the system starts to show its flux. They explore: - How to configure multi-stage deployment pipelines for Dev → Test → Prod - Why selective deployment is critical — and what happens when it’s not enabled - The risks of full deployment in a dynamic workspace structure - What it means to maintain stability when environments are in constant motion ⚠️ Fabric Flux — because in a world of constant deployment, nothing stays where it was meant to be. 🎧 Listen now, before your pipeline starts drifting too.