Blowing Kisses: Un-SQL Friday #003 Roundup
We at MidnightDBA sure do love a blog party, and what’s better than a blog party about love? I invited the...
2011-02-21
643 reads
Blog Posts
Data Driven Subscriptions for SSRS Report with Parameters from multiple data sources
Just to give the context of the problem I faced recently.. our application is very data intensive, GB of data received...
2011-02-21
653 reads
Hello, My Name is Hugo and I haven't Blogged in Two Months
Oh gracious sin 🙂
No apologies, just that life gets in the way from volunteer work.
My regular political passions have gotten in...
2011-02-21
750 reads
How Should the PASS Nominating Committee Be Selected?
Over the past few months, the Elections Review Committee (ERC) has been looking into how the community should select its future leaders in the PASS organization. We started with...
2011-02-21
8 reads
How Should the PASS Nominating Committee Be Selected?
Over the past few months, the Elections Review Committee (ERC) has been looking into how the community should select its...
2011-02-21
655 reads
How to Avoid SQL Server 2008 Lingering Evaluation Installs - Validation Before Applying SP2 (10.0.2531 to 10.0.4000)
We wound up in a nasty situation recently where SP2 could not be applied to an instance of SQL Server. ...
2011-02-21
1,612 reads
London UK SQL Server User Group – It’s Back!
"We're back with a Bang!"
In case you missed it, being tucked away amongst all the other UK SQL Server User...
2011-02-21
646 reads
Moore’s Law May Be The Death of NAND Flash
"It ain’t what you don’t know that gets you into trouble. It’s what you know for sure that just ain’t...
2011-02-21
1,010 reads
Pragmatic Transition: Lighthouses and Shipwrecks
Sometimes your mistakes are the greatest lessons...
This is the next post in my series about transitioning from a DBA to...
2011-02-21
697 reads
SQLSaturday#69 - Update - Schedule Posted! - You Can Still Register
It's just a little less than 2 weeks to SQLSaturday#69 at DeVry University, 1140 Virginia Drive, Ft. Washington, PA 19034...
2011-02-21
872 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