(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media logs, website user interactions, and financial transactions. So, working with streaming datasets can place you...
2025-07-07
181 reads
It’s been a week since I flew home from London and Redgate to begin my sabbatical. Actually, at this time last week I was just about to land in...
2025-07-05
17 reads
When you're searching about the future of a career in MS SQL Server, you're not just looking for a pat on the back. You want to know the truth....
2025-07-05
110 reads
In 2025, artificial intelligence is no longer a futuristic concept—it’s a central force in the creative world. From music and film to fashion, literature, and visual arts, AI is...
2025-07-04
22 reads
As businesses increasingly migrate their databases to the cloud, the demand for skilled database administrators is skyrocketing. The DP-300: Administering Microsoft Azure SQL Solutions certification is designed for professionals...
2025-07-04
87 reads
It’s been a minute since I’ve gotten out to speak at events, but the second half of 2025 is going to be packed.
2025-07-03
27 reads
Calling APIs directly from SQL Server has been available in Azure SQL DB since 2022, but now it's available in on-prem in SQL Server 2025...
2025-07-03
6 reads
The PASS Summit goes on tour this year, with an August stop in New York City. This is the first event in the series, and I’m excited to go...
2025-07-02
13 reads
A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get overlooked, until something breaks. But if you know how to use them, they can tell...
2025-07-02
91 reads
AI is deemed to be the new superpower. Adoption of AI in various capacities is at 72% across industries, world wide, according to one study, and it does not...
2025-07-01
27 reads
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...
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
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