Knowing the days between events is a fairly common reporting request because a lot of reporting is created to track SLA’s (service level agreement) and other KPI’s (key performance...
2022-06-17 (first published: 2022-06-03)
298 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-03
46 reads
Christine and I are looking forward to speaking at the Improving Edge conference, co-presenting our session on Monday, June 6th. Our presentation on “Ethics in Modern Data” features topics relevant...
2022-06-03
50 reads
Slides from today’s talk at DataGrillen Branding Yourself for a Dream Job.
2022-06-02
43 reads
Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. What...
2022-06-13 (first published: 2022-06-02)
301 reads
A few years ago I gave you homework to create a SQL Agent Job and play with it a little ... Continue reading
2022-06-02
27 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-02
27 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-01
27 reads
(2022-May-31)
Personal notes of one of the recent ADF JSON pipeline development to remember how to use it next time.
Requirements:
Sourcing data comes from a SQL Server database
The destination is a...
2022-06-15 (first published: 2022-05-31)
706 reads
I jumped on the bandwagon early so to speak to use the user group feature of Sessionize and since then I’ve walked at least five user groups through setting...
2022-05-31
52 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