Focus on Core Skills
Core skills depends on the position, but the point is that ensuring you have a strong foundational base for your chosen area is better than reaching for emerging skills.
2025-03-28
108 reads
A New Word: Zverism
zverism – n. the wish that people could suspend their civility and indulge in the physical side of each other first, sniffing each other’s hair like dogs, staring unabashedly...
2025-03-28
78 reads
SQL Server Source Control on a $0 Budget
The Source Control Dilemma Every DBA has been there. Trying to keep track of database schema changes while developers have their fancy Git repositories and version control workflows. Meanwhile,...
2025-03-27
139 reads
CHOOSE’ing a Beer: #SQLNewBlogger
We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use...
2025-04-09 (first published: 2025-03-26)
282 reads
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly gathers dust—is a mistake many organizations still make. While a catalog should list what data...
2025-04-07 (first published: 2025-03-26)
297 reads
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...
2025-03-24
32 reads
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...
2025-03-24
14 reads
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...
2025-03-24
28 reads
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...
2025-04-07 (first published: 2025-03-24)
562 reads
Monday Monitor Tips: Looking Back in Time
Often we find out about a problem reported by a customer after the incident has passed. This might be from a trouble ticket or even an email that we...
2025-03-24
151 reads
Blogs
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
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