Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
This next article in the Fabric Modern Data Platform looks at DuckDB, an analytical database platform designed for analytics
2026-01-28
1,169 reads
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
In this next article on the Fabric Modern Data Platform, we use the Polars library in Python to improve our data engineering.
2026-01-14
1,692 reads
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
In this next article, we look at how notebooks using Python can be cheaper than Spark notebooks.
2026-01-07
2,307 reads
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
This article will use the incremental data load pattern to load data in our raw zone tables.
2025-12-10
685 reads
2025-12-05
99 reads
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
In this next article on the Fabric Modern Data Platform, we examine setting up an on-premises gateway.
2025-12-09 (first published: 2025-11-26)
2,009 reads
How Microsoft Fabric Is Reshaping Data Value
The data professional’s world is changing and I know you hear this from me in editorials, blogs posts and social media, but it’s the truth. With the rise of Microsoft Fabric, we’re not just seeing another platform shift; we’re witnessing a redefinition of how data is valued, governed, and protected across the enterprise. Fabric isn’t […]
2025-07-22
243 reads
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,546 reads
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)
5,062 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
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers