One Week until PASS 2009
It's one week until the PASS Summit. At this time next week I'll be on a plane, heading to Seattle...
2009-10-26
677 reads
Blog Posts
People I Can’t PASS on Meeting
One week from today I will be in Seattle for my first ever PASS Summit. One of the things I...
2009-10-26
601 reads
Special Events at PASS Summit
Besides giving two Community Session presentations (here and here), next week, I will be involved in the Birds of a...
2009-10-26
616 reads
SQL Saturday #21 (Orlando) Presentation Downloads
Here are the slide decks and code samples from my sessions at SQL Saturday #21 Orlando on 10\17. I've also...
2009-10-26
407 reads
SQL Saturday #21 (Orlando) Recap
Saturday, 10\17, marked the third year for SQL Saturday here in Orlando and each year it gets bigger and better....
2009-10-26
794 reads
SQLSaturday Sensation in NJ
Well, it's a wrap! Saturday has come and gone, but memories will go on. It was great to see so...
2009-10-26
755 reads
Business Cards – Again
I posted some thoughts on business cards awhile back, had used up the ones I had and was time to...
2009-10-25
682 reads
My Eval Results from SQLSaturday #21
I presented Social and Not So Social Networking for the DBA. Of the attendees, 16 submitted an eval. Here are...
2009-10-25
555 reads
Phil Factor SQL Speed Phreak Competition
If you have a database application that is running slowly, or is straining the server, what do you do? After...
2009-10-25
3,150 reads
SQL University: Authentication and Authorization
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,877 reads
Blogs
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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