If you’ve been watching AI roll through the data community and thinking, “this seems useful, but I have no idea where to start,” this post is for you.
The post...
2026-07-06 (first published: 2026-06-22)
200 reads
The DBA life is fraught with pain. Those battles that we endure are mostly invisible to many. Those countless sleepness nights are a testament to our dedication. Whether that...
2026-07-06
13 reads
As a SQL Server DBA with years of experience tuning production environments, I’ve seen the same patterns repeat: nightly index maintenance jobs running for hours, consuming massive CPU and...
2026-07-06 (first published: 2026-06-19)
782 reads
Annabel retired from Redgate Software this week. Across most of my career at Redgate, I’ve participated in many events, some we hosted, some we sponsored. At most of these...
2026-07-03 (first published: 2026-06-19)
227 reads
I’m off on vacation today. Which is a little weird as I just got back from a week long vacation in May, cruising with my family. Usually my trips...
2026-07-03
18 reads
It is Friday, the queries are running, and nobody is watching the bill. That is the whole charm of Redshift Serverless: you stop thinking about nodes and resizes. It...
2026-07-03 (first published: 2026-06-19)
203 reads
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of it, nobody’s fixed it, it’s just there — a handful of small compliance gaps that...
2026-07-03 (first published: 2026-07-02)
32 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is small enough to dump and restore in a maintenance window, or it isn't. Once you...
2026-07-03
25 reads
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the “true” version of a SQL that the database will run. It takes your SQL as...
2026-07-03 (first published: 2026-07-02)
20 reads
By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause. The reason I like it is that it lets you...
2026-07-02 (first published: 2026-07-01)
22 reads
The DBA life is fraught with pain. Those battles that we endure are mostly...
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Comments posted to this topic are about the item TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers