My Schedule at the Summit/Let’s Connect
I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If...
2009-10-27
1,212 reads
Blog Posts
SQL Server Standard, Volume 6, Issue #1
It’s alive! It’s alive!
That’s enough from Colin Clive.
It’ll be out for the Summit. SQL Server Standard lives again! Although, not quite in...
2009-10-27
709 reads
SQL University: Diving into Authorization
It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on...
2009-10-27
6,148 reads
Where Will We PASS Each Other?
In my a post on Monday, I talked about who I want to meet while at the PASS Summit. Today...
2009-10-27
870 reads
Annoyed with LinkedIn
Funny how tools can surprise you. I’ve had in mind to set up a sub-group and invite all the SQLSaturday...
2009-10-26
603 reads
Beginning T-SQL 2008
My book "Beginning T-SQL 2008" came out about two weeks ago. http://www.amazon.com/Beginning-T-SQL-2008-Kathi-Kellenberger/dp/1430224614/ref=sr_1_1?ie=UTF8&s=books&qid=1256604424&sr=8-1 It's a beginning book because I assume that the...
2009-10-26
794 reads
Book Review: Murach’s JavaScript and DOM Scripting by Ray Harris
In early September I received a complimentary copy of Murach’s JavaScript and DOM Scripting by Ray Harris (Amazon) to review. ...
2009-10-26
511 reads
DRP for SQL Server in French - traduction en français du plan de relève – part 5
Here I go again, trying to finish up the translation. Thank you very much to local MVP Eric Moreau for his help fixing...
2009-10-26
855 reads
Expert SQL Server 2008 Encryption
Encryption is a tough subject, but it’s one that’s fascinated me for years. I downloaded PGP when it came out...
2009-10-26
1,056 reads
Notes on a Migration from Oracle to SQL Server
I have to admit, when asked to perform a migration from Oracle to SQL Server over the past couple of...
2009-10-26
586 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