How to mirror data from SQL Server to Microsoft Fabric: complete guide
Learn all about Microsoft Fabric mirroring for SQL Server: how it works, what's new in 2025, setup, limitations, and troubleshooting
2026-10-02
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
Foreign Keys and Performance in a Microsoft Fabric Warehouse
I wanted to answer a simple question: Do relationships help, hurt, or have no effect when added to tables in a Fabric warehouse?
2026-09-18
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Learn about using classification as a technique to prepare your data for additional machine learning analysis.
2026-07-15
1,032 reads
2026-06-27
189 reads
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Data build tool (dbt) is an open-source command line tool that helps engineers transform data using SQL scripts. However, there are limitations to what can be done with the Structure Query Language (SQL). That is where dbt Python models can be used to perform complex tasks. A dbt Python model is a function that reads […]
2026-06-03
2,768 reads
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data within their warehouses. It already assumes that data is extracted and loaded into raw tables. The dbt core framework is written in Python with the translations defined as a combination of SQL scripts, Jinga Template Language, and YAML […]
2026-05-27
1,291 reads
Improve Query Performance in the Fabric Warehouse with Clustering
Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.
2026-05-18
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Learn more about dbt in this next article on Data Engineering in Fabric.
2026-04-08
5,162 reads
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
In this next installment, we look at using dbt to seed a Fabric Warehouse.
2026-03-25
3,636 reads
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
The next installment of the Fabric Modern Data Platform looks at Spark pools for executing code.
2026-03-11
1,857 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers