Snowflake Editions
You have decided that snowflake is the technology you want to use to build your next gen data platform, you have decided your cloud provider (Azure, AWS, GCP) then...
2022-07-13
137 reads
You have decided that snowflake is the technology you want to use to build your next gen data platform, you have decided your cloud provider (Azure, AWS, GCP) then...
2022-07-13
137 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Deborah Melkin (blog | twitter) asks us for a database-related rant.
I...
2022-07-12
19 reads
This month’s T-SQL Tuesday is hosted by Deborah Melkin(b|t), and she has an interesting topic. She wants us to write a rant on a scenario we encountered at a...
2022-07-25 (first published: 2022-07-12)
325 reads
Good morning dear reader. Today I am writing this blog while sitting at a trampoline park. My six-year-old son loves this place, and we tend to find ourselves here...
2022-07-27 (first published: 2022-07-12)
275 reads
Deb Melkin (b | t) is hosting T-SQL Tuesday this month and is letting us rant. Who doesn’t like to rant about databases and the famous “it depends”. She...
2022-07-13 (first published: 2022-07-12)
36 reads
I know I can say that I’m a friend of Allen White without getting into trouble. Allen and I have a shared a lot of things over the years...
2022-07-12
114 reads
Often enough I get questions regarding partitioning to try to help alleviate performance issues with very large tables. A common misconception is that due to the table being large,...
2022-07-12
51 reads
In my first post, I reference that by the end of your first 30 days you should have a 90-day plan of things to tackle at your job and...
2022-07-25 (first published: 2022-07-12)
562 reads
A great invitation this month from Deborah Melkin. I thought this was very apt, as I use this phrase often. Many of us do. This was a tougher post...
2022-07-12
32 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-07-12
20 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