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
1,807 reads
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,013 reads
Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.
2026-05-18
Learn more about dbt in this next article on Data Engineering in Fabric.
2026-04-08
4,613 reads
In this next installment, we look at using dbt to seed a Fabric Warehouse.
2026-03-25
3,227 reads
The next installment of the Fabric Modern Data Platform looks at Spark pools for executing code.
2026-03-11
1,663 reads
In this next installments of the Modern Fabric Data Warehouse, we look at tools for developers.
2026-02-25
2,165 reads
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
This next articles gives you a few quick ways to access data in remote storage.
2026-02-11
1,760 reads
This next article in the Fabric Modern Data Platform looks at DuckDB, an analytical database platform designed for analytics
2026-01-28
1,636 reads
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Are there any good articles on all the trace flags that are enabled on...
Comments posted to this topic are about the item The Data Model Matters
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers