Select SIFISO Blogs

For a while now, I have ensured that the source code of new projects that I have undertaken (in both...

2015-10-26

238 reads

Execute All Packages Within SSIS Project Catalog

The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the...

2015-07-15 (first published: 2015-07-06)

2,796 reads

When SQL Server Reporting Services (SSRS) successfully renders a given report control (i.e. Table, Matrix, List etc.), the result set can...

2015-06-24 (first published: 2015-06-15)

2,293 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...

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

Comments posted to this topic are about the item SQL Server Enum Implementation: A...

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;