This year the PASS Summit is virtual. I’m speaking, as a donation, and Monica Rathbun has written some thoughts on the event. I’m hoping that attendance is high enough...
2020-08-14 (first published: 2020-08-06)
340 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-13
17 reads
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was ... Continue reading
2020-08-13
88 reads
When I got a new machine, I had SQL Clone on my old machine, in a few VMWare VMs. I decided to move this to my new machine, so...
2020-08-13 (first published: 2020-08-04)
351 reads
Do you run SQL Agent Jobs in your environment? Do you know what is running at any given time? Most people do not know what is currently running if...
2020-08-13 (first published: 2020-08-04)
555 reads
Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your...
2020-08-12
17 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-12
37 reads
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:
It's an Honor: Microsoft MVP July 1, 2019
How...
2020-08-12
58 reads
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available in Azure SQL Database, UTF-8 is exciting if you have a legacy database and application...
2020-08-12
59 reads
As you can tell from previous posts, I’ve taken a few Microsoft Certification exams here in 2020. As you may have also heard, there’s been this Coronavirus pandemic happening...
2020-08-12 (first published: 2020-08-01)
361 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