Daily Coping 10 Oct 2022
Today’s coping tip is to write down three things you can look forward to in the next month. Easy. Visiting my daughter. I’m heading up this weekend to watch...
2022-10-10
11 reads
Today’s coping tip is to write down three things you can look forward to in the next month. Easy. Visiting my daughter. I’m heading up this weekend to watch...
2022-10-10
11 reads
You can find the slides and the demo scripts (.sql files) in my Github repo. You can use the materials as you like, attribution would be nice 🙂
The post...
2022-10-10
34 reads
Hello Dear Reader!
It's been a while. I've been busy working with a few colleagues on our show Tales from the Field. This has been a learning experience.
I've had to...
2022-10-17 (first published: 2022-10-07)
158 reads
As a part of my own journey of learning within PostgreSQL, I’ve decided that I’m going to take part in PGSQL Phriday as often as I can, just as...
2022-10-21 (first published: 2022-10-07)
188 reads
Today’s coping tip is to be willing to share how you feel and ask for help when needed. This has been something that I never did well. My parents...
2022-10-07
10 reads
Apologies for the late invitation. A minor snafu has me hosting again. This is the monthly blog party where someone hosts and you all write a response. I’d like...
2022-10-06
82 reads
Today’s coping tip is to remind yourself that you are enough just as you are. This is interesting, as I’m not satisfied with who I am today. I’m not...
2022-10-06
10 reads
What you have access to is not just what you have direct permissions to. The other day I needed to ... Continue reading
2022-10-19 (first published: 2022-10-06)
259 reads
I was reminded this week that I needed to get registered for the Data Community Summit 2022 since I’m speaking. I also needed a hotel, so I took some...
2022-10-05
38 reads
Today’s coping tip is to choose to see your mistakes as steps to help you learn. I preach this with the kids I coach. Mistakes will happen, but let’s...
2022-10-05
20 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WA:08218154393 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
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