There were a number of data platform announcements at Microsoft Build yesterday that I wanted to blog about. Everything announced at Build can be found in the Microsoft Build 2022...
2022-06-20 (first published: 2022-05-25)
255 reads
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the hardiest data storage designed...
2022-05-25
47 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-25
23 reads
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
48 reads
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
33 reads
I was lucky to attend SQSQL Saturday Jacksonville 2022L Saturday Jacksonville 2022 a couple of weeks ago. This was the first SQL Saturday of 2022 for me, and the...
2022-06-24 (first published: 2022-05-25)
176 reads
You can find my slidedeck for the session “Introduction to Azure Data Factory” on Github:https://github.com/KoenVerbeeck/SessionMaterials All demos given in the session are explained in the ADF tutorial at MSSQLTips.com.
The...
2022-05-25
26 reads
SQL Server 2022 CTP is here
It has been announced today (2022-05-24) during the MS Build event. The blog post includes a download link. Unfortunately, the Docker container is...
2022-05-24
37 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-24
24 reads
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately hit bad traffic, all four lanes of I-4 blocked that resulted in a 30 minute...
2022-05-24
72 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