Redgate and Rome
I’m at the UK Redgate office today, meeting with senior leaders in all areas of the business. I was honored to be awarded a spot in our President’s Club....
2026-05-11
49 reads
I’m at the UK Redgate office today, meeting with senior leaders in all areas of the business. I was honored to be awarded a spot in our President’s Club....
2026-05-11
49 reads
I don’t have SQL Server installed on my laptop. In an effort to keep things clean and smooth in case I need to rebuild things, I’ve gone with containers....
2026-05-11 (first published: 2026-04-29)
356 reads
the kinder surprise – . the point in your early adolescence when you realize that your parents are muddling through their lives the same as you; that many respectable...
2026-05-08
59 reads
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves...
2026-05-08 (first published: 2026-04-22)
271 reads
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework (DTEF) foundation exam. I’m blogging about it because I know a lot of people struggle...
2026-05-08 (first published: 2026-05-01)
386 reads
PlanTrace Now Supports PostgreSQL
The same plan analysis you know from Redshift, now for PostgreSQL — including EXPLAIN ANALYZE, buffer stats, and JSON format.
When...
2026-05-08
108 reads
Here’s a little secret APEX performance hack if you are running on the Autonomous database. As background, I’m running an Autonomous database with six CPUs and a terabyte of...
2026-05-08
175 reads
I’m doing a small series on indexing basics for SQL Server, and on May 14th I’ll be presenting the third part which is about columnstore indexes. You can watch...
2026-05-07
86 reads
These days everything is changing to AI World, IT roles are getting changed and it is going towards AI ways, everyone in IT should be aware of AI –...
2026-05-07
66 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
Introducing PlanTrace — a free, browser-based tool that turns raw execution plans into interactive graphs and actionable tuning insights.
plantrace.studyyourdata.com
PlanTrace...
2026-05-07
113 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers