Uncategorized – Page 2 – Learning is not a spectator sport

SQL Macros – complex SQL made easy. Elapsed time calculation

The more you play with SQL macros, the more you find simple but powerful use cases which will make life

Yesterday I posted some demonstrations of the impressive power of indexes in relational databases for data retrieval even when those

I happened across an interesting thread on Twitter today which posed the question about when you should intervene with alternative

Just an addenda to what I posted last week about downloading the Formula 1 motor racing data where I provided

Thanks for attending my talk on Futuristic SQL during Database World.If you missed it, or want to rewatch it at

Naturally there was an overwhelming urge to title this post “The Need for Speed” and sprinkle Maverick and Goose references

If you head over to the official database sample schema github repo you’ll find all the standard schemas that you’ll

With the recent change to the licensing rules for SQLcl, a simple “yum” command on your Linux box gets you

What happens when you get two mates who haven’t had a chance to catch up at a conference like they

Since 18c, Express Edition (XE) has typically been my “Go-To” release of the Oracle Database. It is free, quick to