Notes from SQLSaturday – Part 2
Picking up from yesterday, once we got through the confusion of the room changes everything settled down. I checked the...
2009-10-21
615 reads
Blog Posts
Operations Manager Shell
I've started using SCOM 2007 R2, which has given me a chance to try out the Operations Manager Shell. The Ops Mgr Shell...
2009-10-21
1,017 reads
PASS Summit Birds of a Feather Lunch
Mike Walsh, who is a PASS volunteer, has done a nice job organizing the PASS Summit Birds of a Feather...
2009-10-21
914 reads
Presentations from SQL Saturday Orlando now online !
My presentation and sample files from SQLSaturday in Orlando are now online for you to download. Check them out at...
2009-10-21
390 reads
SQLSaturday #21 – Orlando Recap
In my previous post I discussed the week that led up to the SQLSaturday event. In this post I’ll tell...
2009-10-21
683 reads
Who did IT and Ran - The title of my upcoming presentation...
UPDATE: I just finished up my presentation slides for this upcoming NY/NJ SQL User Group meeting, on Saturday, 10/24/2009. I may cut...
2009-10-21
938 reads
Wildcard – Match One Character using Underscore (_)
I was recently contacted by a developer with what I would consider to be a very simple question. How do...
2009-10-21
2,702 reads
Yes, I am a square, but not the way my wife thinks.
I’ll be on the Twitter Bingo card along with a lot of other great SQL Server folks at Pass! Quest...
2009-10-21
575 reads
A Week of SQL Server
As anyone who reads this blog knows, SQLSaturday #21 – Orlando was last Saturday (Oct. 17, 2009) and as a lead...
2009-10-20
403 reads
It's NOT TOO LATE to Register....NY/NJ SQLSaturday Event 10.24.09
Hi, all;
The countdown to the NY/NJ SQL Saturday event this upcoming Saturday has begun. And it's NOT TOO LATE to...
2009-10-20
548 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