A New Word: the Kinder Surprise

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...

Get a Range of Sequence Values: #SQLNewBlogger

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...

Overcoming Imposter Syndrome: A Plan

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...

PlanTrace Now Supports PostgreSQL

PlanTrace Now Supports PostgreSQL

The same plan analysis you know from Redshift, now for PostgreSQL — including EXPLAIN ANALYZE, buffer stats, and JSON format.

When...

The secret APEX performance hack

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...

Free Webinar about Columnstore Indexes

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...

Future IT Roles – Agentic Architect and AI Boom!!

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 –...

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

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...

A Cloud Dependency Failure from Amazon

I went to sleep while reading a Kindle book on my phone. I know because my hand dropped and the phone knocked me in the forehead. I set it...

Deploying AI in logistics (the unfiltered version)

A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent looks like from the client’s side; the users who drifted away, the security work nobody...