Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-11-20
10 reads
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-11-20
10 reads
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-11-20
5 reads
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-11-20
4 reads
Sharding is a method for distributing data across multiple machines. MongoDB uses sharding to support deployments with very large data sets and high throughput operations.(more...)
2020-11-20
15 reads
Recently we had a quick online tutorial for Mural, a way of collaborating online with a group. It’s often used for design, but it can be used for brainstorming...
2020-11-20
25 reads
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t ... Continue reading
2020-11-19 (first published: 2020-11-05)
364 reads
The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1,000 attendees! We were honestly blown away by how successful the...
2020-11-19
60 reads
The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1,000 attendees!
We were honestly blown away by how successful the first...
2020-11-19
12 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-19
18 reads
Earlier this week I announced the release of a new Power Platform book. While I’m super excited about that book I’m also excited to announce
2020-11-19 (first published: 2020-11-06)
692 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...
WA:08218154393 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
Comments posted to this topic are about the item 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