Connor McDonald on Database and SQL

Blast from the past. Tightening up your data model. https://connor-mcdonald.com/2016/03/11/tightening-up-your-data-model

Previously on the blog. Free In-memory in Oracle Database 19c. https://connor-mcdonald.com/2020/05/01/in-memory-opportunities-abound/

Blog greatest hits :-) . ORDS upgrades are so easy. https://connor-mcdonald.com/2023/01/10/ords-upgrades-are-so-easy/

Time for AI world !

Blast from the past. Dealing with changes to READ ONLY data. https://connor-mcdonald.com/2023/06/06/dealing-with-changes-to-read-only-data/

Coming to AI World? Let's talk database design in the new AI-driven world reg.rf.oracle.com/flow/oracle/...

From the vault. Oh...another language is too hard. https://connor-mcdonald.com/2017/10/25/ohanother-language-is-too-hard/

Blast from the past. DBMS_JOB is an asynchronous mechanism. https://connor-mcdonald.com/2019/02/14/dbms_job-is-an-asynchronous-mechanism

Previously on the blog. APAC conferences wrap up. https://connor-mcdonald.com/2025/12/03/apac-conferences-wrap-up/

From the vault. Why I love working on AskTom. https://connor-mcdonald.com/2015/10/10/why-i-love-working-on-asktom

From the vault. JSON and the optimizer. https://connor-mcdonald.com/2023/12/07/json-and-the-optimizer/

Previously on the blog. Automatically generate audit capture for tables. https://connor-mcdonald.com/2020/08/04/level-up-your-audit-trigger-game/

Previously on the blog. My Session Picks for AI World - Tuesday. https://connor-mcdonald.com/2025/09/26/my-session-picks-for-ai-world-tuesday/

Previously on the blog. RIP Joel Kallman. https://connor-mcdonald.com/2021/05/28/rip-joel-kallman/

Previously on the blog. Translating SQL (a migration tool). https://connor-mcdonald.com/2016/10/20/translating-sql-a-migration-tool

Even this close to AI World we can still jam an AskTOM Live session in before the big event :-) Come join me in a few hours! asktom.oracle.com/ords/asktom....

Fresh vid! Advanced Queuing gives guarantees to ensure all messages are processed in the order they were enqueued. But if you change one property, you lose that guarantee! youtu.be/l8X02tO9-XY

Can you *really* use AI to design a robust database model?

Can we get faster DDL? #JoelKallmanDay connor-mcdonald.com/2026/10/14/b... @oraclebase.bsky.social @oracleace.bsky.social @oracleapex.bsky.social #orclapex

From the vault. SQL*Plus quick tip. https://connor-mcdonald.com/2016/01/27/sqlplus-quick-tip

Previously on the blog. Blockchain tables the usage model. https://connor-mcdonald.com/2021/08/03/blockchain-tables-the-usage-model/

Not a bad idea

Previously on the blog. JDBC, the FetchSize and staying up to date. https://connor-mcdonald.com/2025/01/17/jdbc-the-fetchsize-and-staying-up-to-date/

Project Hail The Exorcist

Retro blog post. KISS video series for Analytic functions. https://connor-mcdonald.com/2015/11/25/kiss-video-series-for-analytic-functions

Previously on the blog. Those pesky LONG columns. https://connor-mcdonald.com/2018/01/25/those-pesky-long-columns/

Blast from the past. The Halloween Pumpkins of Terror. https://connor-mcdonald.com/2022/11/01/the-halloween-pumpkins-of-terror/

A little self-indulgence, if you'll forgive me, but I've just hit 1,000 videos on my YouTube channel! Thanks for all the support along the way. Enjoy this little montage to mark the occasion. www.youtube.com/@databasedude

Every time I install a fresh APEX, I get reminder of the great contribution made by Joel @oracleapex.bsky.social #orclapex

Retro blog post. Why I blog -redux. https://connor-mcdonald.com/2024/08/08/why-i-blog-redux/

It's back! I love checking out the sessions at AI World and I love Oracle APEX, so I my home-grown AI World agenda app is back for 2026. Use the power of APEX to filter sessions, build your AI World agenda, save to your calendar so you can have the best conference experience. bit.ly/aiworld26

Blast from the past. From file names to directory hierarchy. https://connor-mcdonald.com/2018/05/14/from-file-names-to-directory-hierarchy/

We're 16 days in ... 84 to go :-) www.youtube.com/watch?v=Nx7F...

Good things happen when you put your reading glasses on and keep an eye on the intsy wintsy fonts on screen 😀 @oracleapex #orclapex oracleapex.com

Many developers and DBAs know that the *EXPLAIN* PLAN command might not tell you the full story...but sometimes even the FINAL execution plan might not be a true representation of how your database actually executed the query. youtu.be/uqknOzqd00E

Previously on the blog. Oracle Database 18c. https://connor-mcdonald.com/2018/02/17/oracle-database-18c/

Previously on the blog. Trip down memory lane. https://connor-mcdonald.com/2018/03/21/trip-down-memory-lane/

Zero is my favorite speed for in-flight WiFi.

From the vault. Software quality - Grok and my friend's boat. https://connor-mcdonald.com/2026/01/04/software-quality-grok-and-my-friends-boat/

Previously on the blog. Interval partitioning just got better. https://connor-mcdonald.com/2017/08/01/interval-partitioning-just-got-better/

Blast from the past. PL/SQL in 21c gets amazing new loop iterators. https://connor-mcdonald.com/2021/01/15/pl-sql-in-21c-gets-amazing-new-loop-iterators/

Fresh SQLcl ! www.oracle.com/database/sql...

Blog greatest hits :-) . Disabled EZCONNECT. https://connor-mcdonald.com/2019/03/06/disabled-ezconnect

Blog greatest hits :-) . A new dictionary view for privileges. https://connor-mcdonald.com/2022/02/06/a-new-dictionary-view-for-privileges/

Why does the database let us choose a size for our extents? Does the size even matter? What happens if we get it wrong? Do we need to worry about it at all? Let's look at the evolution of storage settings in the Oracle Database youtu.be/k5SGOu8nQXo

Blast from the past. Cleaner DDL than DBMS_METADATA. https://connor-mcdonald.com/2022/03/02/cleaner-ddl-than-dbms_metadata/

Session times are now out for AI World. Start planning your sessions today, and I'll see you there! reg.rf.oracle.com/flow/oracle/...

Previously on the blog. Testing versus the Database. https://connor-mcdonald.com/2021/11/22/testing-versus-the-database/