We looked earlier at the various places our data lives – on disk, in memory, in-transit across the network. A good strategy will protect all of these locations –...
2022-12-28 (first published: 2022-12-14)
554 reads
Today’s coping tip is to offer to help someone who is facing difficulties now. I’ve been very lucky in life. I find that success often has me associating with...
2022-12-14
26 reads
This blog is intended to be a follow up from the SQL Saturday 2022 in Oregon & SW Washington. In that session I presented an introduction to FHIR and...
2022-12-21 (first published: 2022-12-13)
291 reads
It’s that time of the month, and I’m late. I’ve been on holiday for a week, so this is a quick post for T-SQL Tuesday. This month is hosted...
2022-12-23 (first published: 2022-12-13)
244 reads
This month’s T-SQL Tuesday is being hosted by ME. The subject I chose is “What are your year-end activities?” My post for T-SQL Tuesday #157 will outline some examples...
2022-12-21 (first published: 2022-12-13)
158 reads
Today’s coping tip is to contact someone you can’t be with to see how they are. Maybe the one thing the pandemic did for me is make me think...
2022-12-13
24 reads
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the ... Continue reading
2022-12-15 (first published: 2022-12-13)
53 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Garry Bargsley (blog | twitter) wants to know what activities we...
2022-12-13
26 reads
SQL Server has had the native ability to encrypt data since SQL Server 2005. This included functionality that could be used to encrypt individual items and columns of data...
2022-12-12
146 reads
Today’s coping tip is to look at life through someone else’s eyes and see their perspective. I have my own views, beliefs, and thoughts about the world. However, I...
2022-12-12
12 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...
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
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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