I have a blog post series about some nice features in the Snowflake cloud data warehouse; one of them is about the IS [NOT] DISTINCT FROM predicate. I was...
2022-08-17 (first published: 2022-08-04)
1,251 reads
I’ve been tracking my usage and comparing that with the estimates for my solar power system. I wrote about the database design and tracking the usage and some of...
2022-08-19 (first published: 2022-08-03)
411 reads
Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan Kehayias. The chart has...
2022-08-15 (first published: 2022-08-03)
401 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-08-03
16 reads
I remember going into Andy Leonard’s session at PASS Summit in Denver. I’m not going to lie, it was kind of sparsely attended, so I got to sit up...
2022-08-02
13 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-08-02
17 reads
You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really ... Continue reading
2022-08-15 (first published: 2022-08-02)
259 reads
I’m giving a free webinar for MSSQLTips.com at 11th of August 2022. The abstract: When building a data warehouse (DWH) in the Microsoft Data Platform stack, you typically have...
2022-08-02
63 reads
Looking forward to jambalaya at #SQLSatBR in THIS SATURDAY! Also looking forward to speaking and seeing all of you there, I guess... Register today: https://sqlsaturday.com/2022-08-06-sqlsaturday1026/After I stepped down from the...
2022-08-02 (first published: 2022-08-01)
28 reads
One of our clients in Vietnam, his name is Son Vu, who is developing a website running on VPS (his homepage trainghiemmuasam.com) encountered an error that MySQL could not...
2022-08-12 (first published: 2022-08-01)
186 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