Daily Coping 4 Jan 2023
Today’s coping tip is to share something helpful with a friend that you learned recently. I share a lot with my wife and kids. They are a big part...
2023-01-04
10 reads
How Secure is TDE?
When we consider how secure a form of encryption is there are two things we want to consider. Let’s discuss each of these in turn. What are We Protected...
2023-01-13 (first published: 2023-01-03)
400 reads
Daily Coping 3 Jan 2023
Today’s coping tip is to use one of your strengths in a new or creative way. I have a lot of strengths. They’ve helped me to be successful. This...
2023-01-03
23 reads
Daily Coping 2 Jan 2023
Today’s coping tip is to start the new year off with something new – listen, watch, read something completely different. I started listening to more country music last year....
2023-01-02
17 reads
Running SQL Server on Apple Silicon
Last week I purchased a shiny new MacBook Air with an M2 processor. After I got all the standard stuff up and running, I set out to learn how...
2023-01-11 (first published: 2023-01-02)
768 reads
SQLPlayer is renaming
It was about time. The blog and all related services are being changed the name. From SQL Player to Azure Player. You probably noticed over several years that the...
2023-01-02 (first published: 2023-01-01)
66 reads
T-SQL Tuesday #121: Gifts received for this year Redux 2022 Edition
Trigger warning: suicidal ideation, depression, bipolar, mania If you would prefer to stick to all the positives skip to the numbered list at the bottom.
The post T-SQL Tuesday #121:...
2022-12-31
23 reads
Goal Progress for Dec 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. December is usually quiet, though this year I spent the...
2022-12-30
16 reads
Daily Coping 30 Dec 2022
Today’s coping tip is to give thanks. List the kind things others have done for you. I know that my life is great, but it’s because of a lot...
2022-12-30
26 reads
Book Review – Designing Data-Intensive Applications
The book Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems by Martin Kleppmann was recommended to me by a colleague. The author has worked at companies...
2023-01-09 (first published: 2022-12-29)
222 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Question of the Day
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