Book review - SQL Server Secret Diary (Know the unknown secrets of SQL Server)
Like a lot of people within the SQL community, I can never read enough on the subject. Books, whitepapers, academic...
2011-12-31
2,318 reads
Blog Posts
Good Bye 2011
Good Bye 2011
Hey there, this year is going to an end and just want to recall what all happened this...
2011-12-31
1,293 reads
Happy New Year
Image: ponsuwan / FreeDigitalPhotos.net
As 2011 draws to a close and as people look forward to evening of partying and celebrating I’d...
2011-12-31
1,952 reads
SQLServerDBA News - 2011 Review for SQLServerDBA
2011 was a great year on a personal and professional level
1) Completed the Brighton Marathon in 4hrs 36 secs
2) Blogged...
2011-12-31
1,571 reads
January 2012 Las Vegas SQL UG
This month I am attempting to get a jump on things a bit. I am hoping to get the info out in a more timely fashion throughout this new...
2011-12-30
7 reads
January 2012 Las Vegas SQL UG
This month I am attempting to get a jump on things a bit. I am hoping to get the info...
2011-12-30
1,691 reads
January Midlands PASS meeting - Hosting Ed Wilson, the "Scripting Guy"
On January 10, 2012, Midlands PASS is pleased to welcome back PowerShell expert and teacher, Ed Wilson (blog | twitter), and...
2011-12-30
1,698 reads
Re-blog – December 23 – December 29
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-30
1,441 reads
Thoughts on SSSOLV December Meeting
This is very late – I know. The meeting was held on December 8, 2011 and I haven’t yet shared my recap/thoughts about the meeting. We hold the SQL...
2011-12-30
6 reads
Thoughts on SSSOLV December Meeting
This is very late – I know. The meeting was held on December 8, 2011 and I haven’t yet shared my...
2011-12-30
1,474 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
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...
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