Managing Fabric Lakehouse objects with the new CLI: Data Engineering with Fabric
In this next article, we are going to explore how to install, configure and use the command line to manage a couple different Fabric Lakehouse’s.
2025-06-04
1,746 reads
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries
Building pipelines in Microsoft Fabric can be complicated, and it's easy to write code that is hard to maintain. Using parameters in your connections helps to build pipelines that are easily configured.
2025-07-04 (first published: 2025-06-02)
7,208 reads
How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal to write SQL more efficiently. One of those features is macros, which we’ll introduce in this article
2025-05-28
Level 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool
This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.
2025-06-06 (first published: 2025-05-07)
784 reads
How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?
The article A gentle introduction to dbt explains how you can get dbt in the cloud version, how you can set up a free account, and how to create a connection to a Microsoft Fabric warehouse.
2025-04-30
2026-05-06 (first published: 2025-04-16)
1,758 reads
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
Learn how you can create a full data load process in Fabric.
2025-04-16
4,227 reads
Create Raw Zone Tables using Generative AI: The Fabric Modern Data Platform
In this first article on the Fabric Modern Data Platform, we look at how to use Generative AI to build tables.
2025-04-07 (first published: 2025-04-02)
3,365 reads
Fabric Analytics for SQL folks: Part 1 - Fabric demystified
Unlock new opportunities for data-driven decision-making by grasping the significance of SQL and structured data in current data and analytics ecosystems like Microsoft Fabric.
2025-03-21
6,751 reads
Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric
This next article in the Data Engineering with Fabric series showcases how tally tables can help load data in a Fabric warehouse.
2025-02-26
2,348 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