SQL Swimmer

So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...

2012-08-16

2,330 reads

Simply NomCom

So there seems to be some confusion as to what the NomCom’s job is. I have to admit I was...

2012-06-18

607 reads

I submitted my application for the NomCom last week and the polls opened up yesterday. I’ve seen an amazing amount...

2012-06-14

622 reads

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. The internet...

2012-06-06

592 reads

“Don’t aim to have others like you; aim to have them respect you.” –...

Many years ago, before I joined Oracle, I was working on a major modernisation...

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...

WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 3;