SQL Server 2022: The Future of Data Management
SQL Server 2022 and its enhancement … Continue reading SQL Server 2022: The Future of Data Management →
2023-02-27
359 reads
SQL Server 2022 and its enhancement … Continue reading SQL Server 2022: The Future of Data Management →
2023-02-27
359 reads
Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process...
2023-03-13 (first published: 2023-02-26)
252 reads
In February 2023, Microsoft released some new Power BI themes that are more accessible than the other themes available by default. The blog post mentions the prevalence of color...
2023-02-25 (first published: 2023-02-24)
97 reads
I am saddened to report that I will not be able to attend SQLBits in person this year as originally planned. I was involved in a terrible car accident...
2023-02-24
20 reads
I will not even attempt to hide it, I’m very much in the learning phase of my PostgreSQL journey. As such, I’m constantly picking up new facts. However, I’m...
2023-02-24
16 reads
Today’s coping tip is to be gentle with someone you feel inclined to criticize. It’s very easy, and maybe very human, to start to criticize others for doing something...
2023-02-24
20 reads
I’m pleased to announce that I’ll be talking about how you can migrate your SSIS skills to Azure Data Factory at Data Saturday Rheinland. At the time of writing...
2023-02-24
19 reads
I’m thrilled to announce that the “Architecting Microsoft SQL Server on VMware vSphere” 8.0 best practices guide has been released! I’m pleased to have been able to contribute to...
2023-02-23
204 reads
Today’s coping tip is to give sincere compliments today to people. A tough day recently coaching, but I kept this in mind. Complementing parents, competitors and fellow coaches, and...
2023-02-23
22 reads
I’ll be at VS Live in Las Vegas this March to discuss zero downtime deployments. If you want to come and join me for this session, or any of...
2023-03-03 (first published: 2023-02-22)
177 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