C# Corner is holding a virtual SQL Server conference on Jan 29-30, 2021. This is a charitable event, aimed at raising money for children affected by COVID-19. I’ll be...
2021-01-15 (first published: 2021-01-07)
199 reads
If you have come from a windows background you may be curious about the world of SQL Server Linux. Yes, the operating system and the implementation of it differs...
2021-01-15
438 reads
Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes at scale. This post is NOT about what Azure Data Factory is, neither how to...
2021-01-15
10 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...
2021-01-14
21 reads
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
5 reads
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
632 reads
It is a tiny query in size but can play a crucial role to avoid overhead, caused due to missing SET NOCOUNT ON definition in the stored procedures and...
2021-01-14
389 reads
When we built the first SQLSaturday it was about 2 pages of HTML. No login, no tools, just get it done. Worked ok. Didn’t work so well for the...
2021-01-14
8 reads
As I promised in my previous post T-SQL script to find hierarchy of tables – Columnar result – SQL Server Carpenter, here is another version of the query to...
2021-01-14 (first published: 2021-01-07)
951 reads
Intro If you are considering deploying your own Microsoft SQL Server instances in AWS EC2 you have some decisions to make regarding the resiliency of the solution. Sure, AWS...
2021-01-14 (first published: 2021-01-08)
470 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Comments posted to this topic are about the item BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers