Blog Post

Slide Decks

Hello everyone! Just a quick note. I’ve removed all my slide decks from SlideShare. I found they were inserting ads into the slides and I didn’t sign up for...

2025-08-02

50 reads

Blog Post

SQL Server Maintenance Plans

If you’re a DBA, sysadmin, IT manager, or Accidental DBA, you’ve probably seen SQL Server’s built-in Maintenance Plans. They live right there in SSMS under the “Management” node, quietly...

2025-08-15 (first published: )

440 reads

Blogs

KDA: Echoes of Deception - Case 6

By

A cryptic message, a book cipher hidden in art provenance records, and a trail...

Capturing My Own Metrics: #SQLNewBlogger

By

A customer was trying to compare two tables and capture a state as a...

Red Flags in Your Query (T-SQL Tuesday #200)

By

When I'm looking at a query, I bet it's bad if I see... a...

Read the latest Blogs

Forums

BIT_COUNT II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT II

I Can't Make You Learn

By Steve Jones - SSC Editor

Comments posted to this topic are about the item I Can't Make You Learn

Why Your SQL Permissions Disappeared

By deepeshdhake

Comments posted to this topic are about the item Why Your SQL Permissions Disappeared

Visit the forum

Question of the Day

BIT_COUNT II

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

UserID  UserPermissions
15
23
37
4       NULL
What is returned when I run this code: 
select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

See possible answers