Connor McDonald on Database and SQL
banner
connormcd.bsky.social
Connor McDonald on Database and SQL
@connormcd.bsky.social
Hi I'm Connor McDonald!

🔥keen on tech esp. SQL/database
🔥keen on fitness
🔥keen on coffee
🔥keen on gin
🔥keen on sarcasm

I speak for me not my employer
Previously on the blog. Is fragmentation still a dirty word?. https://connor-mcdonald.com/2023/05/21/is-fragmentation-still-a-dirty-word/
January 17, 2026 at 6:08 PM
All I need is a browser .... uh huh

....and a sh*tload of RAM :-(
January 17, 2026 at 6:09 AM
Reposted by Connor McDonald on Database and SQL
Big news this week, we have crossed the 1000-member line!

Congratulations to all ACEs for being part of this amazing community!
January 16, 2026 at 11:12 PM
From the vault. JDBC, the FetchSize and staying up to date. https://connor-mcdonald.com/2025/01/17/jdbc-the-fetchsize-and-staying-up-to-date/
January 16, 2026 at 6:08 PM
Reposted by Connor McDonald on Database and SQL
Your chance: Full-day Upgrade to 26ai Workshop in Sydney on Jan 20, 2025

Happy New Year to all of you at first. And just at very short notice a quick announcement for next week in case you are in the Sydney area in Australia. This is Your chance: Full-day Upgrade to 26ai Workshop in Sydney on Jan…
Your chance: Full-day Upgrade to 26ai Workshop in Sydney on Jan 20, 2025
Happy New Year to all of you at first. And just at very short notice a quick announcement for next week in case you are in the Sydney area in Australia. This is Your chance: Full-day Upgrade to 26ai Workshop in Sydney on Jan 20, 2025 has still a few open seats, and you could join, I'd be happy to see and meet you there.
mikedietrichde.com
January 15, 2026 at 11:06 PM
From the vault. Cloning a table without CTAS. https://connor-mcdonald.com/2018/01/12/clone-a-table/
January 15, 2026 at 6:08 PM
We're back with AskTOM Live in 2026! See you shortly!
asktom.oracle.com/ords/asktom....
asktom.oracle.com
January 15, 2026 at 10:13 AM
From the vault. APEX demos Formula 1 Racing Data ?. https://connor-mcdonald.com/2021/11/05/apex-demos-formula-1-racing-data/
January 14, 2026 at 6:08 PM
When it comes to simplifying JOIN syntax, and being able to take a human step-to-step approach to the set based theories of relational databases, the LATERAL join is making so many queries easier to compose and run.
youtu.be/tPVfJrxXSpI
I'm loving LATERAL joins more and more
YouTube video by SQL and Database explained!
youtu.be
January 14, 2026 at 6:25 AM
January 13, 2026 at 6:08 PM
Reposted by Connor McDonald on Database and SQL
Op dit moment kunnen bedrijven zich als sponsor aanmelden voor APEX World 2026.

Bent u geïnteresseerd in wat de opties zijn voor u of uw organisatie? Neem contact op met de nlOUG via [email protected] voor meer informatie over onze sponsormogelijkheden!

#APEXWorld2026 #orclAPEX #sponsors
January 13, 2026 at 10:11 AM
Blog greatest hits :-) . ChatGPT versus India. https://connor-mcdonald.com/2023/08/01/chatgpt-versus-india/
January 12, 2026 at 6:08 PM
Blog greatest hits :-) . Complex materialized views and fast refresh. https://connor-mcdonald.com/2018/07/05/complex-materialized-views-and-fast-refresh/
January 11, 2026 at 6:08 PM
Previously on the blog. Get the SQL_ID for a SQL statement BEFORE you run it. https://connor-mcdonald.com/2021/10/04/get-the-sql_id-for-a-sql-statement-before-you-run-it/
January 10, 2026 at 6:08 PM
Reposted by Connor McDonald on Database and SQL
Just read a study on database skills for healthcare pros - SQL fluency ranked #1! Proper DB design literally saves lives while poor modelling creates medical errors.

After fixing countless database nightmares, this resonates deeply.

What tech skill is most underrated? DM me your thoughts!
January 9, 2026 at 4:30 PM
Previously on the blog. Counting business days between 2 dates. https://connor-mcdonald.com/2021/02/08/counting-business-days-between-2-dates/
January 9, 2026 at 6:08 PM
Boolean is finally coming! Here's how to make the leap!
January 9, 2026 at 9:48 AM
Blast from the past. Avoiding public embarrassment with triggers. https://connor-mcdonald.com/2015/08/21/avoiding-public-embarrassment-with-triggers
January 8, 2026 at 6:08 PM
That kinda week here in Aus
January 8, 2026 at 2:43 PM
What's the first thing *you* are going to do?
January 8, 2026 at 1:28 PM
Heads up for long term LiveSQL users:
January 8, 2026 at 6:36 AM
Previously on the blog. Database dictionary corruption ? Maybe not.. https://connor-mcdonald.com/2016/03/16/database-dictionary-corruption-maybe-not
January 7, 2026 at 6:08 PM
I do not every Slack workspace I'm a member of to suggest I send a "Happy New Year" message 😡
January 7, 2026 at 1:04 AM
Blog greatest hits :-) . Mr DISTINCT might not be your friend. https://connor-mcdonald.com/2015/08/15/mr-distinct-might-not-be-your-friend
January 6, 2026 at 6:08 PM