Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built content in them takes a lot longer. Moving content to another workspace usually means redeploying...
2026-10-09 (first published: 2026-09-29)
391 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people who prefer a GUI over writing code to handle deployments, but the implementation has enough...
2026-09-02 (first published: 2026-08-21)
468 reads
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet Access. But enabling them disables several features.
The post Think Twice Before Enabling Fabric’s Inbound Network...
2026-07-31 (first published: 2026-07-24)
294 reads
If you’ve been watching AI roll through the data community and thinking, “this seems useful, but I have no idea where to start,” this post is for you.
The post...
2026-07-06 (first published: 2026-06-22)
479 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the invitation post, I intentionally kept the prompt broad because change detection looks different depending on...
2026-06-05 (first published: 2026-05-19)
818 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion architecture declaratively, but once you have a pipeline of MLVs in production, you need visibility...
2026-05-13 (first published: 2026-04-30)
205 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection.
The post T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes? first appeared on Data Savvy.
2026-05-05
174 reads
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL Server 2025. The latest version of mirroring that uses the SQL Server Change Feed is...
2026-04-01 (first published: 2026-03-24)
423 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture (CDC). That is still what is used to mirror SQL Server 2016 – 2022. SQL...
2026-03-25 (first published: 2026-03-11)
638 reads
Lots of people have created Power BI reports, using interactive data visualizations to explore and communicate data. When Power BI was first created, it was used in situations that...
2025-12-08 (first published: 2025-11-24)
80 reads
I built a free library of runnable SQL Server demos. Each reproduces a real...
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
We're currently in Azure, however as we had a very tight migration timeline when...
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Hello everyone, I am planning to implement a data purging solution that is expected...
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers