"If you come to my session at AI World...that will be the end of it" :-) bit.ly/aiworld23ai

Not many companies make their senior executives available for an AMA. I got to attend a similar session in Singapore - great insight into Oracle from both a tech and business level. Put this one on your AI World calendar reg.rf.oracle.com/flow/oracle/...

Blog greatest hits :-) . Audit trails and the importance of TIMEZONE. https://connor-mcdonald.com/2023/01/06/audit-trails-and-the-importance-of-timezone/

Was an absolute joy to chat with Gilson! www.linkedin.com/posts/connor...

Blast from the past. Disabled EZCONNECT. https://connor-mcdonald.com/2019/03/06/disabled-ezconnect

Was an absolute joy to chat with Gilson! www.linkedin.com/posts/connor...

From the vault. Scalar SQL Macros -cherry pick the best features. https://connor-mcdonald.com/2024/02/26/scalar-sql-macros-cherry-pick-the-best-features/

Friday musings. List partitioning for soft deletes - the nuances involved. connor-mcdonald.com/2025/10/03/s...

Blast from the past. How long will the script take to run?. https://connor-mcdonald.com/2021/01/11/how-long-will-the-script-take-to-run/

That moment when someone pings me and says "Hey, can I get a copy of these slides?" Wha?

Less is always more ... bit.ly/aiworld23ai

Just want to geek out on Database tech at AI World?

Previously on the blog. Problematic SQL ? PL/SQL is your friend.. https://connor-mcdonald.com/2016/01/20/problematic-sql-plsql-is-your-friend

Just want to geek out on Database tech at AI World?

Coming to AI World? Here's my Thursday picks! connor-mcdonald.com/2025/10/01/m...

Blog greatest hits :-) . Interval partitioning just got better. https://connor-mcdonald.com/2017/08/01/interval-partitioning-just-got-better/

Check out our latest guest blog post by Oracle ACE Pro Daniele Bocciolini 👉 POUG 2025: The Place Where the Oracle Community Becomes a Driver of Innovation and Learning ✨ 🚀 Thanks for sharing your experience, Daniele! blogs.oracle.com/ace/post/pou...

Fresh Video! Trying to manipulate the password hashes to secure your database accounts? That might have been a good idea back in Oracle 11, but there are much better options now. youtu.be/LsmyIo5zduk

Not many companies make their senior executives available for an AMA. I got to attend a similar session in Singapore - great insight into Oracle from both a tech and business level. Put this one on your AI World calendar reg.rf.oracle.com/flow/oracle/...

Some fresh numbers for 2025 connor-mcdonald.com/2018/08/21/g...

Coming to AI World? Over the next few days, I'll post my picks for cool Database and APEX content. Here's my Wednesday picks! Or just come hang out at the Database booth :-) connor-mcdonald.com/2025/09/29/m...

Previously on the blog. Awesome DATE / TIMESTAMP enhancement in Autonomous Database. https://connor-mcdonald.com/2022/02/02/awesome-date-timestamp-enhancement-in-autonomous-database/

Retro blog post. SQL Macros complex SQL made easy. Elapsed time calculation. https://connor-mcdonald.com/2021/11/16/sql-macros-complex-sql-made-easy-elapsed-time-calculation/

Blog greatest hits :-) . Session killin time. https://connor-mcdonald.com/2017/04/24/session-killin-time

Time to break out the high brow humour :-) #OracleAIWorld

Coming to AI World? Over the next few days, I'll post my picks for cool Database and APEX content. Or just come hang out at the Database booth :-) connor-mcdonald.com/2025/09/26/m...

Blast from the past. Using AI for test data. https://connor-mcdonald.com/2023/12/08/using-ai-for-test-data/

Quick tip, aka, I keep forgetting this :-) When creating a credential, the docs typically say "Username", but *just* your username typically won't work - it needs to include the *where* that username is sourced from

AskTOM Live for Database is back tonight my time (in a little over 4 hours time), so see you there for some fun tech Q&A asktom.oracle.com/ords/asktom....

Coming to AI World? Over the next few days, I'll post my picks for cool Database and APEX content. Or just come hang out at the Database booth :-) connor-mcdonald.com/2025/09/25/m...

Blog greatest hits :-) . Why you keep getting ORA-01653: unable to extend table. https://connor-mcdonald.com/2020/10/07/why-you-keep-getting-ora-01653-unable-to-extend-table/

Joel Kallman Day 2025 : Announcement oracle-base.com/blog/2025/09... #JoelKallmanDay @oracleace @OracleAPEX #orclapex @OracleDatabase

Sadly I sat and pondered why GROUPING SETS was "broken" for way longer than I should have :-)

Time spent scritching animals is not deducted from your lifespan

Blog greatest hits :-) . TEMP is a four letter word. https://connor-mcdonald.com/2023/01/02/temp-is-a-four-letter-word/

New Video! If you are getting lots of SQL errors due to missing objects, it could be a sign that someone is using SQL injection to try hack into your system. Here's how you can track those errors, and how things are changed in Unified Audit (including 23ai) youtu.be/gnFoVvYzGnE

Reminder to pre-book your seat for AI World sessions. Last year it was sad to see people being turned away from my session because they didn't add the session with the schedule builder. bit.ly/aiworld23ai

I've been waiting decades ... but finally the documentation chickens have come home to roost !!! connor-mcdonald.com/2025/09/22/t...

Blast from the past. Securefile in 12c - part 2. https://connor-mcdonald.com/2016/09/01/securefile-in-12c-part-2

I've been waiting decades ... but finally the documentation chickens have come home to roost !!! connor-mcdonald.com/2025/09/22/t...

From the vault. Recycling saves the planet but maybe not your database. https://connor-mcdonald.com/2022/05/30/recycling-saves-the-planet-but-maybe-not-your-database/

Blast from the past. How do I stop the use o fTRUNCATE. https://connor-mcdonald.com/2015/12/18/how-do-i-stop-the-use-of-truncate

Retro blog post. UNLONG my dictionary those pesky LONG columns. https://connor-mcdonald.com/2021/04/06/unlong-my-dictionary-those-pesky-long-columns/

Less is always more ... bit.ly/aiworld23ai

Friday frivolity .... Doing DML against a SQL macro 😂

Blast from the past. How to stop your site from being Clickjacked!. https://connor-mcdonald.com/2020/08/12/clickjacked/

New post! MERGE is 23ai is even cooler than first appears... connor-mcdonald.com/2025/09/18/m...

You asked for it ... we got a happy hour at AI World! eventreg.oracle.com/profile/web/...

Previously on the blog. The performance report you are NOT using. https://connor-mcdonald.com/2021/04/30/the-performance-report-you-are-not-using/

Fresh video! The best thing about JSON is its flexibility...and the worst thing about JSON might also be its flexibility. How do you ensure your JSON data matches your business rules? 23ai can help! youtu.be/5wQqKUCQlxg