I’ve watched teams spend a lot of time on backup strategy. They plan out the full, differential, and log backups to ensure they can successfully meet the recovery point...
2024-04-17 (first published: 2024-04-05)
339 reads
alazia– n. the fear that you’re no longer able to change.. I don’t have alazia. I’m always thinking I change, sometimes even when I don’t want to. Certainly my...
2024-04-05
30 reads
I’m heading to the UK in a few weeks for the London Redgate Summit. This starts a wild period of travel for me, but I’m excited. This is the...
2024-04-12 (first published: 2024-04-03)
148 reads
There are so many choices and so little time. How do you go about deciding what to learn? I have to delicately balance everything I think I want to...
2024-04-15 (first published: 2024-04-02)
429 reads
I’m off on Thursday for Salt Lake City and a SQL Saturday on Friday. SQL Saturday Salt Lake City 2024 is happening, and I’m glad I get to go....
2024-04-02
63 reads
The benefits of data classification and the features of a tool like Microsoft Purview, a unified data governance service. Data classification organizes data into categories based on its type,...
2024-04-12 (first published: 2024-04-02)
411 reads
Your boss walks up to you one morning and says, “Hey, I wanna list of all of our databases and when they were last accessed”. If you’ve got some...
2024-04-15 (first published: 2024-04-02)
1,172 reads
I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks...
2024-04-02
7 reads
I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks...
2024-04-10 (first published: 2024-04-02)
216 reads
As a Software Engineer, I would like to deploy my AWS Amplify react js project using Terraform so that I can automate my workflow and eliminate any manual intervention...
2024-04-01
29 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