Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

SQLServerCentral Article

Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform

  • Article

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 […]

You rated this post out of 5. Change rating

2026-06-03

2,637 reads

SQLServerCentral Article

Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform

  • Article

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 […]

You rated this post out of 5. Change rating

2026-05-27

1,215 reads

External Article

Microsoft Fabric and MQTT for Real-Time IoT Data Ingestion and Analytics

  • Article

Microsoft Fabric is a unified platform for data integration, data engineering, real-time intelligence, and advanced analytics. Fabric is known for providing an integrated way of working with your data, connecting to many diverse types of sources and across the data landscape. How do we get started ingesting and analyzing real-time data streamed over the MQTT protocol?

2026-02-23

Blogs

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

By

Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...

The Book of Redgate: Evidence

By

We aren’t the only company that does this, but Redgate Software does try to...

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

By

Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....

Read the latest Blogs

Forums

The New World Of AI Robots

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New World Of AI...

Logic question in a WHERE clause using IIF?

By DaveBriCam

Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...

Execute as failure

By pdanes

Security has long been a problem for me. Every time I think I understand...

Visit the forum

Question of the Day

BIT_COUNT() V

What does this return on SQL Server 2025?

select bit_count(null)

See possible answers