2011-02-02
6 reads
Blog Posts
2011-02-02
8 reads
2011-02-02
7 reads
Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features
This series of Videos will walk through on how to prepare one box HyperV lab to understand, evaluate & validate SQL...
2011-02-02
720 reads
Something BIG in Boston - SQLSaturday#71
BIG in BOSTON
Last time, I blogged about the first upcoming event in the North East in Philadelphia, PA – SQLSaturday#69, but...
2011-02-02
634 reads
Work Isn’t the Most Important Thing
I had quite an adventure today, away from work. We had a pipe freeze in the house, a sick kid,...
2011-02-02
1,091 reads
24 Hours of PASS Sessions Announced
In case you missed it last week, PASS has announced the speaker lineup for the next 24 Hours of PASS. ...
2011-02-01
565 reads
31 Days of SSIS – SSIS Naming Conventions (31/31)
31 Days of SSIS
We’re at the thirty-first, and last, post for the 31 Days of SSIS. The series started with...
2011-02-01
1,449 reads
February Question: Share with us your “best” restore disaster stories.
As DBAs, making backups and restoring data is one of the foundational skills we all must master. But sometimes things...
2011-02-01
453 reads
Is a clustered index best for range queries?
I see a lot of advice that talks about the clustered index been the best index for use for range...
2011-02-01
1,739 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