T-SQL Tuesday #188: Growing the Community
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has been a great help in multiple communities over the years, and he has quite an...
2025-07-08
105 reads
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has been a great help in multiple communities over the years, and he has quite an...
2025-07-08
105 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, John Sterrett
(blog) asks us:
What are you doing, or what can we do...
2025-07-08
19 reads
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that has evolved over decades. It is known for its reliability, feature richness, and strong community...
2025-07-08
91 reads
Logging is a necessity in the database world, well, the entire tech world. You need to know what is happening in and around your databases. It’s easy to setup...
2025-07-07
244 reads
☁️ Cloud vs. On-Premises Database Security: A Strategic Transformation The approach to securing databases has evolved significantly with the rise of cloud computing. In a traditional on-premises setup, organizations...
2025-07-07
15 reads
🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍 What Are Columnstore Indexes? Unlike traditional row-based indexes, Columnstore Indexes organize and store data by...
2025-07-07 (first published: 2025-06-18)
1,049 reads
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media logs, website user interactions, and financial transactions. So, working with streaming datasets can place you...
2025-07-07
181 reads
I decided to update software on my laptop recently during a trip. I’m loathe to do this on most trips, as I don’t want any instability before a presentation....
2025-07-07 (first published: 2025-06-25)
361 reads
It’s been a week since I flew home from London and Redgate to begin my sabbatical. Actually, at this time last week I was just about to land in...
2025-07-05
17 reads
When you're searching about the future of a career in MS SQL Server, you're not just looking for a pat on the back. You want to know the truth....
2025-07-05
110 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