- Tip: Expanding a SQL statement
- WITH clause gets a 26ai boost!
- The Goldilocks problem – Materialized Views
- Blue Sky Programming – The Optimism Trap
- Keeping your tech ego in check
- First dabblings with APEXlang
- Vanishing objects; hello ORA-08103
- A very robust query
- The secret APEX performance hack
- Signal to noise ratio – the AWR trap
- The new release update experience
- My APEX installer / patcher
- The unhealthy obsession with ROLLBACK
- Unleashing Skills onto my database
- SQL skills just got MORE important
- GROUP BY ALL – Is it ALL you ever need?
- Voxxed Days Zurich
- Thank you after 21 years
- Bind Variables – Worse than you were told
- Where is my TNSPING?
- Generate INSERTs the new 26ai way
- INSERT-VALUES – Bigger is NOT always Better!
- SQL Macros make so many things easier
- 26ai Quick Tip for Database Links
- Datatype Discipline – Even more so in 26ai
- The new Boolean … What about existing apps?
- What grabbed your attention in 2025
- Software quality – Grok and my friend’s boat
- 2025 … wrapped
- Transaction Priorities in 26ai – open season on locking
- An AI generated SQL for Christmas
- The Christmas database
- Virtualbox 7.2.4 upgrade … grrr
- Tuning SQL without any access
- APAC conferences wrap up
- South Africa Oracle User Group conference was a blast!
- Turbo boost your LOBs and JSON
- XMLTYPE on Autonomous
- SQL trace on Autonomous
- The AI World 2025 mega download!
- Wrapping up Oracle AI World
- Security predicates exposed #JoelKallmanDay
- Soft Deletes via Partitioning
- My Session Picks for AI World – Thursday
- My Session Picks for AI World – Wednesday
- My Session Picks for AI World – Tuesday
- My Session Picks for AI World – Monday
- The Moment for Database Documentation has come!
- MERGE in 23ai – so much more than RETURNING
- Low code is dead
- Mixing and matching
- Troubleshooting External Scheduler Jobs
- AI World and the power of APEX
- Quick tip for OpenAI on APEX
- I got shamed into using AutoUpgrade
- Transactions on LiveSQL
- Pictorial highlights from Yatra 2025
- First dabblings with SQLcl MCP server
- Can you prioritise DDL locks?
- Are the Fundamentals Too Much to Ask?
- The junior programmer at your company might not be a human being
- The first 10 years
- A new optimizer constant
- Database timezone versus OS timezone
- Customizing the Oracle Documentation
- In-Database SQL formatter
- Old style export/import and Autonomous
- AWR extract – Why did SYSAUX explode?
- Statistics on Global Temporary Tables
- Smashing a database on my PC
- APPEND_VALUES redux – Why Community Matters
- Calling out LinkedIn Clickbait
- APEX 24 exports – PL/SQL and SQLcl
- You can’t beat FREE STUFF !
- Can you REALLY drop those columns?
- UNION versus UNION ALL
- Don’t jump on that Zoom call … at least not right away
- Spaghetti code is Good code
- More Features just by Patching
- Global Temporary Tables and Dynamic Sampling
- Vectors in Oracle Database 23ai FREE
- International Women’s Day
- Sequences in PL/SQL
- The APEX data dictionary
- Understanding REUSE STORAGE
- Creating rows from nothing – time for something better
- JSON_OBJECT_T and the PGA
- More zero outage goodies
- JDBC and the FetchSize – Part 2
- JDBC, the FetchSize and staying up to date
- DataPump – niche fix
- OPatch – The “File In Use” error that wasn’t
- The year in numbers
- Christmas Puzzle – The Solution
- Kris Kringle the Database – The Christmas MYSTERY
- Kris Kringle the Database – All gather ROUND
- Kris Kringle the Database – What a Great GROUP
- Kris Kringle the Database! What DAY is it?
- Kris Kringle the Database – Friday RANT
- Kris Kringle the Database – Taking the LEAP
One response to “Archives”
[…] All Posts […]