corpus.blog
41,554 blogs · 4,969,865 posts Claim your blog
Back to connor-mcdonald.com
Blog · corpus.blog/blogs/connor-mcdonald.com/posts

connor-mcdonald.com

connor-mcdonald.com

2026

Syncing your Oracle AI skill definitionsoriginal ↗
23 Sept 2026
ORA-24369? Required callbacks? Broken binds?original ↗
17 Sept 2026
The mystery magical pluggable databaseoriginal ↗
11 Sept 2026
Your insurance policy as a DBAoriginal ↗
4 Sept 2026
Deciphering Date Differences with DATEDIFForiginal ↗
17 Aug 2026
“Where are my patches?!?!”original ↗
13 Aug 2026
More Gooey-ness from GUIDsoriginal ↗
5 Aug 2026
APEX Collections – Taking More Controloriginal ↗
3 Aug 2026
Database Features – The Bullet Point Mythoriginal ↗
30 Jul 2026
The APEX_COLLECTIONS crash puzzler…original ↗
28 Jul 2026
Not the post I was expectingoriginal ↗
16 Jul 2026
The “best” tooloriginal ↗
13 Jul 2026
Tip: Expanding a SQL statementoriginal ↗
2 Jul 2026
WITH clause gets a 26ai boost!original ↗
1 Jul 2026
The Goldilocks problem – Materialized Viewsoriginal ↗
30 Jun 2026
Blue Sky Programming – The Optimism Traporiginal ↗
26 Jun 2026
Keeping your tech ego in checkoriginal ↗
7 Jun 2026
First dabblings with APEXlangoriginal ↗
27 May 2026
Vanishing objects; hello ORA-08103original ↗
13 May 2026
A very robust queryoriginal ↗
12 May 2026
The secret APEX performance hackoriginal ↗
8 May 2026
Signal to noise ratio – the AWR traporiginal ↗
6 May 2026
The new release update experienceoriginal ↗
4 May 2026
My APEX installer / patcheroriginal ↗
1 May 2026
The unhealthy obsession with ROLLBACKoriginal ↗
30 Apr 2026
Unleashing Skills onto my databaseoriginal ↗
28 Apr 2026
SQL skills just got MORE importantoriginal ↗
22 Apr 2026
GROUP BY ALL – Is it ALL you ever need?original ↗
17 Apr 2026
Voxxed Days Zurichoriginal ↗
7 Apr 2026
Thank you after 21 yearsoriginal ↗
12 Mar 2026
Bind Variables – Worse than you were toldoriginal ↗
9 Mar 2026
Where is my TNSPING?original ↗
5 Mar 2026
Generate INSERTs the new 26ai wayoriginal ↗
2 Mar 2026
INSERT-VALUES – Bigger is NOT always Better!original ↗
27 Feb 2026
SQL Macros make so many things easieroriginal ↗
19 Feb 2026
26ai Quick Tip for Database Linksoriginal ↗
29 Jan 2026
Datatype Discipline – Even more so in 26aioriginal ↗
28 Jan 2026
The new Boolean … What about existing apps?original ↗
23 Jan 2026
What grabbed your attention in 2025original ↗
7 Jan 2026
Software quality – Grok and my friend’s boatoriginal ↗
4 Jan 2026

2025

2025 … wrappedoriginal ↗
30 Dec 2025
Transaction Priorities in 26ai – open season on lockingoriginal ↗
17 Dec 2025
An AI generated SQL for Christmasoriginal ↗
12 Dec 2025
The Christmas databaseoriginal ↗
10 Dec 2025
Virtualbox 7.2.4 upgrade … grrroriginal ↗
5 Dec 2025
Tuning SQL without any accessoriginal ↗
4 Dec 2025
APAC conferences wrap uporiginal ↗
3 Dec 2025
South Africa Oracle User Group conference was a blast!original ↗
2 Dec 2025
Turbo boost your LOBs and JSONoriginal ↗
6 Nov 2025
XMLTYPE on Autonomousoriginal ↗
31 Oct 2025
SQL trace on Autonomousoriginal ↗
27 Oct 2025
The AI World 2025 mega download!original ↗
21 Oct 2025
Wrapping up Oracle AI Worldoriginal ↗
16 Oct 2025
Security predicates exposed #JoelKallmanDayoriginal ↗
15 Oct 2025
Soft Deletes via Partitioningoriginal ↗
3 Oct 2025
My Session Picks for AI World – Thursdayoriginal ↗
1 Oct 2025
My Session Picks for AI World – Wednesdayoriginal ↗
29 Sept 2025
My Session Picks for AI World – Tuesdayoriginal ↗
26 Sept 2025
My Session Picks for AI World – Mondayoriginal ↗
25 Sept 2025
The Moment for Database Documentation has come!original ↗
22 Sept 2025
MERGE in 23ai – so much more than RETURNINGoriginal ↗
18 Sept 2025
Low code is deadoriginal ↗
6 Sept 2025
Mixing and matchingoriginal ↗
2 Sept 2025
Troubleshooting External Scheduler Jobsoriginal ↗
1 Sept 2025
AI World and the power of APEXoriginal ↗
17 Aug 2025
Quick tip for OpenAI on APEXoriginal ↗
14 Aug 2025
I got shamed into using AutoUpgradeoriginal ↗
12 Aug 2025
Transactions on LiveSQLoriginal ↗
4 Aug 2025
Pictorial highlights from Yatra 2025original ↗
1 Aug 2025
First dabblings with SQLcl MCP serveroriginal ↗
14 Jul 2025
Can you prioritise DDL locks?original ↗
14 Jul 2025
Are the Fundamentals Too Much to Ask?original ↗
6 Jul 2025
The junior programmer at your company might not be a human beingoriginal ↗
9 Jun 2025
The first 10 yearsoriginal ↗
2 Jun 2025
A new optimizer constantoriginal ↗
27 May 2025
Database timezone versus OS timezoneoriginal ↗
21 May 2025
Customizing the Oracle Documentationoriginal ↗
20 May 2025
In-Database SQL formatteroriginal ↗
14 May 2025
Old style export/import and Autonomousoriginal ↗
12 May 2025
AWR extract – Why did SYSAUX explode?original ↗
7 May 2025
Statistics on Global Temporary Tablesoriginal ↗
6 May 2025
Smashing a database on my PCoriginal ↗
5 May 2025
APPEND_VALUES redux – Why Community Mattersoriginal ↗
1 May 2025
Calling out LinkedIn Clickbaitoriginal ↗
30 Apr 2025
APEX 24 exports – PL/SQL and SQLcloriginal ↗
28 Apr 2025
You can’t beat FREE STUFF !original ↗
25 Apr 2025
Can you REALLY drop those columns?original ↗
23 Apr 2025
UNION versus UNION ALLoriginal ↗
22 Apr 2025
Don’t jump on that Zoom call … at least not right awayoriginal ↗
10 Apr 2025
Spaghetti code is Good codeoriginal ↗
3 Apr 2025
More Features just by Patchingoriginal ↗
31 Mar 2025
Global Temporary Tables and Dynamic Samplingoriginal ↗
25 Mar 2025
Vectors in Oracle Database 23ai FREEoriginal ↗
10 Mar 2025
International Women’s Dayoriginal ↗
8 Mar 2025
Sequences in PL/SQLoriginal ↗
4 Mar 2025
The APEX data dictionaryoriginal ↗
26 Feb 2025
Understanding REUSE STORAGEoriginal ↗
25 Feb 2025
Creating rows from nothing – time for something betteroriginal ↗
19 Feb 2025
JSON_OBJECT_T and the PGAoriginal ↗
17 Feb 2025
More zero outage goodiesoriginal ↗
30 Jan 2025
Next