I got this message recently while committing some changes: This post shows my work in adding Git LFS support to GitHub. Another post for me that is simple and...
2024-03-04 (first published: 2024-02-21)
185 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s all happening on August the 8th! We’ve open our call for speakers, you can submit...
2024-03-01 (first published: 2024-02-21)
258 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. I missed out on January 2024’s edition because I didn’t think I had anything...
2024-02-28 (first published: 2024-02-20)
198 reads
All Spark Connect Posts
Code
What to do? At some point we will want to do something with delta lake and so I wanted to explore the options. Before we do...
2024-02-17
15 reads
I’ve collaborated with two industry experts to design a transformative course for data leaders: “The Technical and Strategic Data Leader.” This six-week intensive learning journey is crafted to elevate...
2024-02-28 (first published: 2024-02-16)
349 reads
maugry – adj. afraid that you’ve been mentally deranged all your life and everybody around you knows, but none of them mention it to you directly because they feel...
2024-02-16
43 reads
A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I showed them it does and decided to write a post on this. I’ve been working...
2024-03-01 (first published: 2024-02-16)
177 reads
I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have...
2024-02-26 (first published: 2024-02-15)
496 reads
For years I’ve assumed I knew the string defaults, but I realized that’s not right. This post looks at what I learned. Another post for me that is simple...
2024-02-26 (first published: 2024-02-14)
351 reads
First of all, wow! What an incredible event! Loved seeing everyone and meeting so many wonderful new people. Thank you to everyone who organized, spoke, and attended this event!...
2024-02-14
41 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