EightKB 2025
EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s all happening on August the 21st! We’ve open our call for speakers, you can submit...
2025-03-28 (first published: 2025-03-17)
263 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s all happening on August the 21st! We’ve open our call for speakers, you can submit...
2025-03-28 (first published: 2025-03-17)
263 reads
Core skills depends on the position, but the point is that ensuring you have a strong foundational base for your chosen area is better than reaching for emerging skills.
2025-03-28
108 reads
The Source Control Dilemma Every DBA has been there. Trying to keep track of database schema changes while developers have their fancy Git repositories and version control workflows. Meanwhile,...
2025-03-27
139 reads
I received a sobering reminder this week of a lesson we all have learned or should have learned long ago. Something I said online came back around months later...
2025-03-26 (first published: 2025-03-17)
390 reads
IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping everything running smoothly. When SQL Server performance becomes an issue, a common reaction is often...
2025-03-26 (first published: 2025-03-13)
6,954 reads
Often we find out about a problem reported by a customer after the incident has passed. This might be from a trouble ticket or even an email that we...
2025-03-24
151 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
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...
2025-03-24
28 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...
2025-03-24
14 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...
2025-03-24
32 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...
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
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