SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking about SQL Server on Linux.
2023-12-15 (first published: 2023-11-28)
210 reads
Giving a Security Webinar this Wednesday
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern Standard Time, I’m presenting a webinar on how to harden SQL Server. Link to Register...
2023-11-27
20 reads
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until suddenly it starts mysteriously failing with the error… Write to backup block blob device https://******...
2023-12-13 (first published: 2023-11-27)
703 reads
Comparing Two Scripts with kdiff3
I had a customer recently ask if SQL Compare could show them the differences in two scripts they’ve written. They weren’t using version control (tsk, tsk, shame), but saw...
2023-12-15 (first published: 2023-11-27)
403 reads
VMUG Ireland End of Year Event
This Thursday, November 30th, is the next VMUG Ireland event…our end of year social meetup! We’re going to be down in BrewDog Dublin: – THREE LOCKS SQUARE, 4, DUBLIN...
2023-11-27
17 reads
Job Description of a DBA
I have curated the list of activities of a DBA or one can say Job Description of a DBA. DBA needs to adapt and keep learning new technologies
The...
2023-12-11 (first published: 2023-11-27)
1,854 reads
Last Weeks Reading (2023-11-26)
📰 News Deploy a Delta Sharing Server on Azure Want to learn how to deploy a DeltaSharing server on Azure, but don’t know where to begin? Why Structured Streaming...
2023-11-26
15 reads
Testing Microsoft Fabric - Part 2
To quickly summarize where we are, we started testing Microsoft Fabric with a 10GB tar file, which took over 20 hours to extract, and now...
2023-11-24
4 reads
Memories of the PASS Data Community Summit 2023
I’ve been to a lot of conferences, and one that I’ve probably attended the most is the annual PASS Data Community Summit. It’s been listed under various names, but...
2023-11-24
91 reads
A New Word: Emodox
emodox – someone whose mood is perpetually out of sync with everyone else around them, prone to feelings of naptime panic, heart-to-heart snark, or dance club pensiveness. I had...
2023-11-24
60 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
Alamat Kontak Bank BCA KCP Cijerah WA {08218154393}
WA:08218154393 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...
Alamat Kontak BCA KCU BANDUNG WA {08218154393}
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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