The DBA Who Came In From The Cold

As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If...

2013-11-26

448 reads

My favourite online references

There is a wealth of information about SQL Server online. Absolutely hundreds of blogs, white papers, editorials, the list goes...

2013-11-19

425 reads

As my first post, I thought I’d list a few points that I would say to any new DBA. I’ll...

2013-11-07

803 reads

“Don’t aim to have others like you; aim to have them respect you.” –...

Many years ago, before I joined Oracle, I was working on a major modernisation...

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

Comments posted to this topic are about the item Is Fabric a Reliable Service...

hi , a new user wants to be able to add sql agent jobs...

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 3;