SQL People PASS Board interview is online–Please Comment!
Hey folks,
Welcome back to the PASS election process. The process moves forward with all of us candidates awaiting our ranking...
2011-11-10
868 reads
Blog Posts
SQL Triggers - An Introduction
Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...
2011-11-10
1,254 reads
Stored Procedure Checklist
DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate...
2011-11-10
2,998 reads
Tentative Meetings
A lot of my work right now involves going to meetings. A few of them are ones I host, a...
2011-11-10
621 reads
Book Review: Moneyball
With the movie coming out I realized somehow I’d missed reading Moneyball by Michael Lewis. It’s the story of how...
2011-11-09
692 reads
Eighty Logical Cores of Goodness!
I recently had the opportunity to specify the purchase of a couple of Dell PowerEdge R810 2U servers that will...
2011-11-09
1,831 reads
My Playbook For Putting On a SQLSaturday Part 2: Venue
Finding Your Venue
Sounds simple right?
It can be one of the most difficult things to do for something the size of...
2011-11-09
1,228 reads
Physical Servers What are They?
Today I'm in the process of installing some physical servers. To put this into perspective due to the companies I...
2011-11-09
515 reads
PreCon–SQL Saturday Tampa
I recently had a great opportunity to present a preconference all day event in Tampa with the crew from the...
2011-11-09
724 reads
Script level upgrade for database ‘master’ failed
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to start. I started digging in and this is what...
2011-11-09
13 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers