One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this week it was just my oldest, going on 15....
2019-01-21
9 reads
Blog Posts
One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this...
2019-01-21
209 reads
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...
2019-01-21 (first published: 2019-01-14)
2,894 reads
Things I Wish I Knew When I Started
Way back in August, Matt Cushing (blog|twitter) was preparing to teach and asked for a list of “what do you wish you’d known when you started” items that he...
2019-01-21
20 reads
What could you achieve with 60% more time?
Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If...
2019-01-21
201 reads
Last Week Reading (2019-01-20)
Hello folks! Good morning on Monday morning and let’s go through some interesting news from the #data world. Press Using...
2019-01-20
159 reads
Containerization
Docker has containers to work on processes or application. now docker containers has some limitations as it uses resources from...
2019-01-19
124 reads
Error – Hung Docker
Sometime when you not actively working on Docker and on you are not actively working on the system. it could...
2019-01-19
216 reads
New page on this blog: Contact Me
This is not a technical post! Just wanted to say that I set up a public email address for this...
2019-01-19
134 reads
DBA Jobs: Threats and Opportunities (Dear SQL DBA Episode 66)
Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and...
2019-01-18
13 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