Keeping MS Docs Up to Date
One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...
2026-01-09 (first published: 2025-12-10)
256 reads
One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...
2026-01-09 (first published: 2025-12-10)
256 reads
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday newsletter. It tends to hit my inbox in the wee hours of Wednesday.
2025-12-31 (first published: 2025-12-10)
251 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mike Walsh
(blog) asks us:
Write two short notes to yourself. One to the...
2025-12-29 (first published: 2025-12-09)
237 reads
It has been a while since my last T-SQL Tuesday blog. When I saw Mike Walsh’s topic for T-SQL Tuesday #193, I was intrigued and inspired – “Notes to...
2025-12-24 (first published: 2025-12-09)
244 reads
The last T-SQL Tuesday of the year is hosted by my good friend Mike Walsh. Mike’s call for us is to end the year on a poignant note –...
2025-12-24 (first published: 2025-12-09)
154 reads
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he hosted (back at #4), but he answered my call for hosts and I appreciate that....
2025-12-26 (first published: 2025-12-09)
238 reads
The setup My day job involves babysitting a lot of Git repositories hosted on GitHub. The vast majority of the commits, merges, and squashes I run on a daily...
2025-12-22 (first published: 2025-12-09)
474 reads
Recently, the world was reminded of just how fragile the internet can be. Two well established cloud services, Cloudflare and Azure Front Door, both had simultaneous outages that caused...
2025-12-22 (first published: 2025-12-08)
412 reads
In Parts 1-3, I covered how I prepare for a certification exam. In this last part, I'll talk about how I go about taking the exam.
2025-12-19 (first published: 2025-12-08)
441 reads
I was chatting with the product managers at Flyway and one asked me whether I’d seen the new tab for Automation in Flyway Desktop. I hadn’t and decided to...
2025-12-29 (first published: 2025-12-08)
171 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...
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas 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