Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most valuable asset: their information. But basic SQL knowledge won't get you far when it's time...
2024-05-11
85 reads
ioia – n.the wish that you could see statistics overlaid on every person you encounter – checking the signal strength of their compatibility, a measure of their trustworthiness. I...
2024-05-10
40 reads
In a previous blog post we went through how to build a Docker container image from a remote (Github) repository. Here we’re going to expand on that by actually...
2024-05-10 (first published: 2024-04-25)
390 reads
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and Developers has been a subject of intrigue, debate, and occasional drama. Do they collaborate harmoniously...
2024-05-10 (first published: 2024-04-29)
319 reads
As I look at the state of information technology today, I see one constant: rapid change. We all see it. While this is the type of post I would...
2024-05-08 (first published: 2024-04-22)
190 reads
Can we normalize a couple of things? 1 – Trade Schools. Back in the 80’s trade classes in high school and post high school were frowned upon, or looked...
2024-05-08
40 reads
A brief introduction to the tool and its advantages for database migrations DevOps is a culture and a set of practices that aim to deliver software faster and more...
2024-05-08 (first published: 2024-04-25)
199 reads
I love Chicago. I went to visit three times in 2023: a Redgate event, a volleyball tournament, and a wedding. Each time was a lot of fun and I...
2024-05-08
68 reads
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on github.
The post Techorama 2024 – Slides first appeared on Under the kover of business intelligence.
2024-05-08
58 reads
When I look at a system and think about its security model, the first thing I start poking around at is where I think security is weakest. For instance,...
2024-05-06
61 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