Want to really level up your SQL game? I mean, go from good to great? This March 2025, grab the interactive course Window Functions in PostgreSQL absolutely FREE. This is your chance to master...
2025-03-13
6,640 reads
We published an article recently at SQL Server Central on Tally Tables in Fabric from John Miner. In it he showed how this can be efficient. A day after...
2025-03-21 (first published: 2025-03-12)
6,974 reads
In today’s data-driven world, organizations need the ability to analyze and act on data as it flows in real time. Microsoft Fabric provides a powerful ecosystem for real-time intelligence,...
2025-03-24 (first published: 2025-03-12)
7,367 reads
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin – Data Platform MVP, WIT co-lead and WITspiration founder. Deb’s invitation is to blog about mentoring and sponsorship. What...
2025-03-21 (first published: 2025-03-11)
6,662 reads
Thank you to Deborah Melkin for hosting TSQL Tuesday this month! I’ve always considered mentoring and sponsorship very structured. Now, I wonder if they’re also small things we do...
2025-03-24 (first published: 2025-03-11)
6,593 reads
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin, and it’s a good one that asks us where we are making the world better. The topic is...
2025-03-11
6,585 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Deborah Melkin
(blog) asks us to talk about our relationship with mentoring and...
2025-03-11
22 reads
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges, the March SQL Practice is the perfect opportunity. This month’s challenge is designed for advanced...
2025-03-11
6,577 reads
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the year. This year was especially sweet to see a lot of the SML (Saturday Morning...
2025-03-10
30 reads
Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...
2025-03-10
5 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
Comments posted to this topic are about the item BIT_COUNT II
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