(2022-Jun-06) This blog post is a collaborative effort of several people, some of them I currently work with, and others' contributions came from their writing, so it’s more than natural...
2022-06-22 (first published: 2022-06-07)
547 reads
As I’ve been working more with PostgreSQL, I’ve found that I’m basically pretty happy just issuing SQL commands to get work done. However, it’s handy to have an actual...
2022-06-06
15 reads
I was doing a little experimenting with graph databases. My goal was to run Neo4j in a docker container, but it wasn’t quite as simple as I expected. I...
2022-06-06
37 reads
T-SQL Tuesday is the blog party started by Adam Machanic (b|t) over a decade ago and is now maintained by Steve Jones (b|t) on tsqltuesday.com. On the first Tuesday of...
2022-06-06
54 reads
There are many different family groups for Azure VMs each with its own purpose. Below is a summary of what can be selected. This is important because for example...
2022-06-06
25 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-06
21 reads
Introducing S3 in SQL Server 2022 S3 compatible object storage integration is a new feature introduced in SQL Server 2022. There are two significant areas where SQL Server leverages...
2022-06-22 (first published: 2022-06-06)
240 reads
I’m late to the party on May’s T-SQL Tuesday, but thought it was an interesting enough topic to be worth a belated blog post. It’s about first technical jobs...
2022-06-05
40 reads
SQL Server can run in any Virtual Machine that has the appropriate operating system (yes, I said that because I have some hope, that we will one day learn...
2022-06-20 (first published: 2022-06-03)
466 reads
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. A few days late, and I missed April, but I’m...
2022-06-03
46 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
Comments posted to this topic are about the item 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