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,494 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,166 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

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

By

We are product focused at Redgate Software. Here is another of our values that...

KDA: Echoes of Deception - Case 7

By

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Read the latest Blogs

Forums

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server 2016 Plan

whats that ssis analyzer product that documents lineage

By stan

hi, a few years ago was at a very large company that bought a...

Implicit Conversions Cripple SQL Server

By sabyda

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)
What is returned?

See possible answers