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
2,449 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,154 reads
2026-05-06 (first published: 2025-04-16)
1,716 reads
Learn more about dbt in this next article on Data Engineering in Fabric.
2026-04-08
4,780 reads
In this next installment, we look at using dbt to seed a Fabric Warehouse.
2026-03-25
3,348 reads
The next installment of the Fabric Modern Data Platform looks at Spark pools for executing code.
2026-03-11
1,724 reads
This article will use the incremental data load pattern to load data in our raw zone tables.
2026-03-07 (first published: 2025-12-10)
1,152 reads
In this next installments of the Modern Fabric Data Warehouse, we look at tools for developers.
2026-02-25
2,243 reads
This next articles gives you a few quick ways to access data in remote storage.
2026-02-11
1,845 reads
This next article in the Fabric Modern Data Platform looks at DuckDB, an analytical database platform designed for analytics
2026-01-28
1,685 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers