I will not even attempt to hide it, I’m very much in the learning phase of my PostgreSQL journey. As such, I’m constantly picking up new facts. However, I’m...
2023-02-24
17 reads
I was talking with some developers from my team about monitoring, and I said, “We all use the same tools,” referring to other monitoring software. Then, it hit me....
2023-02-21
23 reads
The question came up that someone wanted to monitor the queries impacting tempdb using Extended Events. Initially, I was pretty sure that there was no real way to do...
2023-02-13
31 reads
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
279 reads
Over the last year, at work and after work, I’ve been teaching myself a lot of brand new technologies. As such, I’m reliant on others to have put together...
2023-01-30
20 reads
Very excited to take part in my third #PGSQLPhriday blogging event, even more so because it’s a topic that’s quite near and dear to my heart, community. To say...
2022-12-02
25 reads
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
59 reads
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
258 reads
It’s time again for the another PGSQL Phriday, this time, the question has been asked: How do you do PostgreSQL backups? Honesty up front. I’m very much just beginning...
2022-11-04
15 reads
I may have occasionally talked about the importance of Query Store, but today I want to emphasize just how much Microsoft is weaponizing query store. Of course, I don’t...
2022-10-31
14 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...
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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