Starting last week is a rollout of the public preview of a new and fully reimagined Microsoft Purview data governance solution. Data governance has become so much more important...
2024-04-29 (first published: 2024-04-17)
896 reads
Let's get one thing straight: database administration isn't the most glamorous tech job out there. You won't be building flashy user interfaces or trendy AI models. But if you...
2024-05-01 (first published: 2024-04-17)
701 reads
I know if you are a SQL Server DBA using Azure SQL DB, you’ve been sorely missing the agent. Enter Elastic Jobs to help you schedule jobs more easily...
2024-04-29 (first published: 2024-04-16)
343 reads
Full documentation on the Undercover Catalogue can be found HERE It’s been a while since the Undercover Catalogue last received an update but having had a few of those...
2024-05-01 (first published: 2024-04-16)
294 reads
Yesterday was a long day in London. I arrived late in the am, and as I was walking from the plane to the border check, I went down the...
2024-04-16
34 reads
It was awesome to see the Kentucky data community come out for the first Derby City Data Days in Louisville, KY! Bringing together communities from Ohio, Tennessee, and Kentucky,...
2024-04-16
29 reads
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be on SQL Server security. It’s scheduled for 1 PM EDT / 5 PM UTC. Sign...
2024-04-15
31 reads
the wends– n. the frustration that you’re not enjoying an experience as much as you should, which prompts you to try plugging in various through combinations to trigger anything...
2024-04-12
39 reads
The world runs on data, and SQL is the key to unlocking its secrets. If you're ready to level up your SQL game, online training is a power move....
2024-04-26 (first published: 2024-04-10)
1,313 reads
This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using the automated process. I have other posts on SQL Monitor as well. I heard from...
2024-04-10
61 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
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