In this post we look at a method using Extended Events (XE) to identify what parent objects are calling a given SQL function and how often. The background is...
2023-02-01 (first published: 2023-01-23)
477 reads
Today’s coping tip is to take a different route today and see what you notice. I’ve had this tip come up a few times and each time I’ve enjoyed...
2023-01-20
16 reads
Today’s coping tip is to switch off tech an hour before bedtime. I read at night often, so this is a challenging one. However, I decided to give this...
2023-01-19
23 reads
Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop
The post Impact of Eliminating...
2023-01-27 (first published: 2023-01-18)
284 reads
I’ve been doing a bit of work with PostgreSQL as part of my work with Redgate. PostgreSQL is a relational platform that is open source, free to use, available...
2023-01-18
64 reads
I’m speaking at VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel a new place for me. I’m...
2023-01-18
20 reads
I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to...
2023-01-30 (first published: 2023-01-18)
80 reads
Today’s coping tip is to say positive things to the people you meet today. In general, I don’t encounter a lot of people on any day, but I do...
2023-01-18
17 reads
Today’s coping tip is to get moving. Ideally do something outside. Taking time to walk the dogs outside, heading to the dog park to get them, and me, some...
2023-01-18
24 reads
I’m honored to be heading back to SQL Bits 2023. I was selected to deliver one session, in the professional development track. With so many people submitting, I’m not...
2023-01-17
33 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. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
Comments posted to this topic are about the item SSRS Reminded Me of the...
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