SQL Saturday #21 Orlando – Recap
This past weekend I had the pleasure of not only attending, but speaking at SQL Saturday in Orlando, FL. When...
2009-10-19
860 reads
Blog Posts
Technology with Vivek Johari: How to make database offline or online
Technology with Vivek Johari: How to make database offline or online
2009-10-19
670 reads
Visual Studio 2010 Beta 2 Available On MSDN Subscribers
Mary Jo Foley posted about Visual Studio 2010 Beta 2 being available on the MSDN Subscriber’s site today, so I...
2009-10-19
662 reads
Fundamentals of Storage Systems – The System Bus
In my last post The Basics of Spinning Disks we covered hard drives, the back bone of our IO system....
2009-10-18
1,135 reads
PASS Update #16
A one topic post this time. As a candidate for Vice President of Marketing for PASS this year I asked...
2009-10-18
626 reads
SQL Saturday #21
I presented a 1 hr session at SQL Saturday #21 session SQL Server PowerShell Extensions: In this sesssion we will...
2009-10-18
396 reads
Post SQL Saturday #21 Orlando
Today I gave a two part session at SQL Saturday in Orlando. When originally planning this years event Andy Warren said many people who...
2009-10-17
1,324 reads
Backing Up Your Data is Obvious, Or Isn’t It?
Often, when I give presentations on DBA best practices, I make the obvious point that databases need to be regularly...
2009-10-16
490 reads
Dev Days
I heard about the Stackoverflow Dev Days earlier this year and thought it was an interesting idea. We had talked...
2009-10-16
1,156 reads
Free E-Book on XSD SQL Server Schema Collections
Whether you like it or not, as a SQL Server DBA or Developer, you will eventually have to learn about...
2009-10-16
555 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