I wrote recently about finding multiple backups in a file. This post looks at how to restore one of those. The one you choose. Another post for me that...
2023-06-02 (first published: 2023-05-17)
217 reads
2023-05-17
65 reads
I saw someone noting that AIs shouldn’t write obituaries. Since I maintain sqlmemorial.org, I wanted to see what would happen for me. This is part of a series of...
2023-05-16
30 reads
The second VMUG Ireland event of the year is taking place on the 15th of June in Belfast! When: Thursday 15th of June @ 2pm until 5pm Where: Ormeau...
2023-05-16
27 reads
When you've got the symptoms of a database issue you can run a series of diagnostic queries to try and drill down on the problem and then start figuring...
2023-05-26 (first published: 2023-05-16)
661 reads
The OS default Power Plan for Windows is Balanced Power. This can cause degraded overall performance for SQL Server. Balanced Power is a great concept to help conserve energy...
2023-05-16
28 reads
This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases...
2023-05-31 (first published: 2023-05-15)
494 reads
I’m heading to Austin today for Redgate’s internal Level Up conference. This is designed to help employees improve their skills in some way. The original ones focused on technology...
2023-05-15
49 reads
Next week is Microsoft Build and there is a Microsoft Digital Event occurring on May 24 - 25 starting at 9 AM Pacific Time for a live simulcast with a lot...
2023-05-15
21 reads
Hello Dear Reader!! We also have some really, really, BIG NEWS for next week! It also happens that next week is Microsoft Build, make sure to register for free! But...
2023-05-15
31 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...
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...
Comments posted to this topic are about the item BIT_COUNT II
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