Teaching at the SC Statewide Audit Conference
Instead of teaching the CISA exam prep course, I'm teaching in the IT track. With Artificial Intelligence (AI) being a central focus in most audit and security tracks, I'm...
2025-06-25
16 reads
Blog Posts
PESTLE Analysis for Databases Explained | Real-World Use Cases & Tool
📘 Understanding PESTLE PESTLE is a strategic framework used to evaluate external macro-environmental factors that influence business operations. It stands for This model is particularly useful for assessing how...
2025-06-24
22 reads
SQL Server TempDB: The Most Overlooked Bottleneck
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk drawer – everyone uses it, nobody monitors it, and eventually it becomes a bottleneck you...
2025-06-23 (first published: 2025-06-04)
835 reads
SSMS 21 Fixes Irritating Problem
I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today, celebrate with me that SSMS 21 finally, at long last, fixes the irritating fact that...
2025-06-23 (first published: 2025-06-09)
1,033 reads
SQL Bits 2025 Wrap
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend, with lots of friends, a family atmosphere, and some amazing speakers from whom I learn...
2025-06-22
38 reads
A New Word: Lackout
lackout – n. the sudden awareness that you’re finally over someone, noticing that the same voice that once triggered a cocktail of emotions now evokes nothing at all –...
2025-06-21
28 reads
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common pitfalls.Image from haalkab on Pixabay.Kubernetes is hands-down the go-to tool for managing containerized applications, yet it...
2025-06-21
41 reads
Cyber Scams and Operation Shamrock
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East conference on cyber scams. How bad is it? Well, according to the Internet Crime Complaint...
2025-06-20 (first published: 2025-06-06)
327 reads
Delta Lake over Spark Connect
All Spark Connect Posts
I have just finished an update for the spark connect dotnet lib that contains the DeltaTable implementation so that we can now use .NET to maintain...
2025-06-20
27 reads
Easily query your GitHub Contribution activity
For a variety of reasons, including your Microsoft MVP activity reports, you might want to summarize your GitHub activity across multiple repos. For contributors to Microsoft open-source docs on GitHub,...
2025-06-20 (first published: 2025-06-05)
289 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 KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas 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