We’ve all been there as DBAs…people requesting access to the servers that we look after to be able to view certain things. I’ve always got, well, twitchy with giving...
2022-12-07 (first published: 2022-11-23)
361 reads
It’s been a long journey, but I got the email from Apress yesterday to say that my book “Pro Encryption is SQL Server 2022” has now been published. You...
2022-12-05 (first published: 2022-11-23)
242 reads
Today’s coping tip is to do something playful outdoors. Easy. Skiing today. First day of the season. I started to add a daily coping tip to the SQL Server...
2022-11-22
21 reads
Hello Dear Reader! Last week was a week we have been building towards since the launch of Tales from the Field. My favorite conference every single year, Live! 360. ...
2022-11-21
39 reads
Recently I got a hold of my Untappd data. For those who don’t know the app, it’s a rating app for beers. You can check-in a beer each time...
2022-12-05 (first published: 2022-11-21)
261 reads
Today’s coping tip is to revisit a coping tip from the past and see if it helped you.. I came up with this one after I tried to do...
2022-11-21
15 reads
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
59 reads
Fairly short post here. Due to the recent events around Twitter (which I will not get into), I’m making an effort to reduce or completely cease my activity on...
2022-11-21
36 reads
You can find the slides and demo scripts for my sessions at Cloudbrew (Snowflake) and PASS Data Community Summit (Migrate SSIS skills to ADF) in my Github repo. If...
2022-11-19
18 reads
Other PASS Summit 2022 Days - Pre-Cons | Day 1 | Day 2
--
Day 3 of Summit 2022 was "Community Day" with a "community keynote" given by the amazing Kimberly Tripp (@kimberlyltripp)...
2023-01-02 (first published: 2022-11-19)
206 reads
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...
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
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
Comments posted to this topic are about the item I Can't Make You Learn
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