Giving back [T-SQL Tuesday #102]
This post is part of the May 2018 T-SQL Tuesday blog challenge, “Giving Back“, from Riley Major. It’s been quite a while since I’ve participated in a T-SQL Tuesday....
2018-05-08
9 reads
This post is part of the May 2018 T-SQL Tuesday blog challenge, “Giving Back“, from Riley Major. It’s been quite a while since I’ve participated in a T-SQL Tuesday....
2018-05-08
9 reads
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
38 reads
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
9 reads
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
11 reads
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
7 reads
In just a few short weeks, SQLSaturday Madison will happen in Madison, WI, and I’m happy to say that I’m...
2018-03-23
233 reads
More and more companies are considering a move to the cloud, but one aspect of such a migration that may...
2018-02-07
333 reads
PASS is our community.
It may sound a little cliche, especially with the current political climate in the US and other...
2017-09-20
351 reads
So you’re using encryption in SQL Server, but you’ve discovered that the expiration date of a certificate is expiring. What...
2017-05-17 (first published: 2017-05-05)
5,591 reads
Another installment of 24 Hours of PASS is coming up next week on May 3-4! This semiannual event features 24...
2017-04-27
592 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...
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
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