31 Days of SSIS – Adding Some Delta Force (27/31)
31 Days of SSIS
Welcome to day twenty-seventh post of the 31 Days of SSIS. We’re getting near the end now. ...
2011-01-28
1,537 reads
Blog Posts
31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31)
31 Days of SSIS
It’s Friday and I’m still taking Friday’s off in my 31 Days of SSIS blog series. As...
2011-01-28
888 reads
A Quick TRIM, Sir?
The other day, I was answering a question on the ASK.SQLSERVERCENTRAL.COM forum from a programmer who had hit a
problem...
2011-01-28
2,153 reads
MySQL Saves You From Missing Where Clause, Sorta
I’ve been taking a look at MySQL after a long absence to help a client decide if it should be...
2011-01-28
921 reads
Speaking at the Rocky Mountain Tech Trifecta on March 5
I just got the notification that I will be one of the speakers at the Rocky Mountain Tech Trifecta on...
2011-01-28
688 reads
SQL Saturday #57 Houston
So you don’t have anything to do this Saturday.Well, if you have an insatiable thirst for SQL knowledge like me,...
2011-01-28
478 reads
Un-SQL Friday #002 Roundup (finally)
The invitation for Un-SQL Friday #002 (Tech Giants) was, like, a week ago! I’ve gotta get this train a-rollin, or...
2011-01-28
962 reads
Upcoming presentations
It’s looking like it’s going to be a busy year.
It’s only January and I already have three presentations lined up...
2011-01-28
544 reads
31 Days of SSIS – Small Package, Big Win (26/31)
Welcome to day twenty-sixth post of the 31 Days of SSIS. We’re getting near the end now. If you have...
2011-01-27
913 reads
A Half-Price Seat at the Masters’ Table
Well, it looks like I half-won the SQLskills competition for a free seat at a SQLskills Master Immersion Event on...
2011-01-27
523 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