We’ve been tracking a weird state with SQL Server virtual machines on VMware and possible warnings on database corruption while VM backups are running, largely centered around (but not...
2022-06-10 (first published: 2022-05-18)
533 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-05-18
24 reads
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-17
35 reads
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
11 reads
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
388 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-05-17
11 reads
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-16
51 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-05-16
34 reads
I’ve written many blog post and articles over the years about SQL Server backups and restore options. I am constantly amazed at how often I find databases that are...
2022-05-16
15 reads
Note: I originally wrote this a few years ago but never posted it. It resurfaced when I migrated the blog so it’s being posted now.
After watching Kevin Kline’s (blog...
2022-06-13 (first published: 2022-05-16)
556 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