Advice I Like: Pyramid Schemes
If someone is trying to convince you it’s not a pyramid scheme, it’s a pyramid scheme – from Excellent Advice for Living For sure. As much as I am...
2026-01-02
21 reads
The Voice of the DBA
Using Prompt AI for a Travel Data Analysis
I was looking back at my year and decided to see if SQL Prompt could help me with some analysis. I was pleasantly surprised by how this went. This...
2026-01-16 (first published: 2025-12-31)
323 reads
2025 Wrapped for Steve
I’ve often done some analysis of my year in different ways. Last year I had a series of posts (health, music, reading, speaking, travel). This year, I took last...
2025-12-29
22 reads
The Book of Redgate: Spread across the world
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia I miss Brad. I enjoyed traveling around and working with him. I’d forgotten about Bob...
2025-12-26
37 reads
A New Word: Etherness
etherness – n. the wistful feeling of looking around a gathering of loved ones, all too aware that even though the room is filled with warmth and laughter now,...
2025-12-19
140 reads
Vibe Coding a Login Tracking System
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t do this natively, as this really needs an XEvent session. I decided to see if...
2026-01-02 (first published: 2025-12-17)
2,299 reads
Monday Monitor Tips: Native Replication Monitoring
Redgate Monitor has been able to monitor replication for a long term, but it required some work from customers. Now we’ve added native monitoring. This is part of a...
2026-01-05 (first published: 2025-12-15)
295 reads
Advice I Like: Art
Superheroes and saints never make art. Only imperfect beings can make art because art begins in what is broken – from Excellent Advice for Living Interesting advice for living...
2025-12-12
16 reads
Keeping MS Docs Up to Date
One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...
2026-01-09 (first published: 2025-12-10)
256 reads
A Note and a Message: T-SQL Tuesday #193
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he hosted (back at #4), but he answered my call for hosts and I appreciate that....
2025-12-26 (first published: 2025-12-09)
238 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers