T-SQL Tuesday #183: Improving Permission Management
This is my (late) answer to my own invitation for T-SQL Tuesday #183. I was very busy a few weeks ago when the invite when out (glad it was...
2025-03-07 (first published: 2025-02-26)
437 reads
The Voice of the DBA
Monday Monitor Tips: VLF Alerts
A recent change made to Redgate Monitor to add a new alert for VLF count. This post looks at the change. This is part of a series of posts...
2025-03-03 (first published: 2025-02-24)
316 reads
A New Word: Tangency
tangency– n. a fleeting glimpse of what might have been. I tend to live in the real world as it is, not too dreamy or wishful that things were...
2025-02-21
14 reads
Making a PostgreSQL Backup in a Container
I needed to back up a PostgreSQL database as a part of the repro for an issue I had. I hadn’t ever made a backup of PostgreSQL, so this...
2025-02-19
136 reads
T-SQL Tuesday #183 Roundup
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions. I didn’t get my own post completed in time, but I’ll add it in the...
2025-02-28 (first published: 2025-02-18)
242 reads
A Little Brainstorming with an AI
I was asked to do some a little thinking and brainstorming recently. Rather than send some emails or get on a call, I decided to ask my local AI...
2025-02-26 (first published: 2025-02-17)
358 reads
Choosing to not drive the Tesla
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla at home recently. A few people asked me about it, so I decided to do...
2025-02-14
37 reads
Advice I Like: Transactions and Relationships
Life gets better as you replace transactions with relationships. – from Excellent Advice for Living This is incredible advice. I think that much of the complaints about the US...
2025-02-14
17 reads
Adding Manual Relationships Between Tables in the TDM Subsetter
I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and a follow up post on using your own backup. One of the things...
2025-02-24 (first published: 2025-02-12)
124 reads
Creating a GitHub Actions Self-Hosted Runner
I had to demo the Flyway Autopilot system recently and created a GitHub Actions runner as a part of that. This post documents how this went. First, if you...
2025-02-21 (first published: 2025-02-10)
202 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Huge frustration - Database watcher with two elastic pools
Think there's a reason why this is still in preview, but have someone manage...
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers