Better Trigger Design: #SQLNewBlogger
I had someone ask me about using triggers to detect changes in their tables. This is the third post in the series. The first one Another post for me...
2025-06-18
31 reads
SQL Server in the Cloud – Are DBAs Still Needed?
Things your cloud vendor may not tell you Here’s a common theme I hear from small IT teams: “Our SQL Server is in the cloud now. We don’t...
2025-06-18
38 reads
SQL Server error 18456
Working with thousands of instances of Microsoft SQL Server, I often encounter users having issues. A common error is 18456 which indicates a login failure.
The post SQL Server error...
2025-06-18
109 reads
ColumnStore Indexes: The Secret to Fast SQL Queries
🎥 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
How To Test SQL Server Disk IO Throughput
When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...
2025-06-18
5 reads
Becoming a Presenter: My Journey and Tips
I still remember my very first presentation many years ago. Someone in my team asked me to demo a project I’d been working on, and I was absolutely terrified....
2025-06-17
14 reads
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
In an era where cloud computing drives innovation, understanding its fundamentals is no longer optional—it’s essential. The AZ-900: Microsoft Azure Fundamentals certification is the perfect starting point for anyone...
2025-06-17
29 reads
Are Your Disks Lagging?
Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...
2025-06-17
2 reads
Moving to Rancher Desktop
I’ve been very happy with Docker Desktop for years, running it on both laptop and desktop. However, a corporate decision was made to move to Rancher Desktop, so I...
2025-07-04 (first published: 2025-06-16)
360 reads
Logging in Azure Data Factory data flows
(2025-June-15) Long gone are the days when a data engineer could simply focus on building a new data integration solution. You’d establish connections to one or more source datasets, review...
2025-06-30 (first published: 2025-06-16)
465 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 Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
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