SQL Server triggers: The good and the scary
SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues.
Will You Touch a Server Again?
Steve doesn't think he will ever work on server class machine again in terms of hardware. He wonders how many of you feel the same.
Product Training Sessions from Redgate University
In 2020 Redgate introduced a series of live training sessions on a selection of their most popular tools, offering customers top tips and demonstrations of new features. If you didn't get a chance to join then check out the recordings available here and be sure to subscribe for news about upcoming sessions.
SQL Server SET STATISTICS IO ON Deep Dive
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
Azure Data Factory Pipeline Logging Error Details
In this article we will cover how to capture and persist Azure Data Factory pipeline errors to an Azure SQL Database table.
Getting Comfortable Writing Code in Azure Data Studio
Learn some of the ins and outs of working with Azure Data Studio to develop SQL code.
President's Day 2021
It's a holiday in the US, President's Day, and I'm off. Hopefully, I'm coaching and enjoying a day with kids away from work and the stress of the world. I hope you have a good day as well.
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