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
🔥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
Previously on the blog. Is fragmentation still a dirty word?. https://connor-mcdonald.com/2023/05/21/is-fragmentation-still-a-dirty-word/
All I need is a browser .... uh huh
....and a sh*tload of RAM :-(
....and a sh*tload of RAM :-(
January 17, 2026 at 6:09 AM
All I need is a browser .... uh huh
....and a sh*tload of RAM :-(
....and a sh*tload of RAM :-(
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!
Congratulations to all ACEs for being part of this amazing community!
January 16, 2026 at 11:12 PM
Big news this week, we have crossed the 1000-member line!
Congratulations to all ACEs for being part of this amazing community!
Congratulations to all ACEs for being part of this amazing community!
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
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/
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…
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
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…
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…
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
From the vault. Cloning a table without CTAS. https://connor-mcdonald.com/2018/01/12/clone-a-table/
We're back with AskTOM Live in 2026! See you shortly!
asktom.oracle.com/ords/asktom....
asktom.oracle.com/ords/asktom....
asktom.oracle.com
January 15, 2026 at 10:13 AM
We're back with AskTOM Live in 2026! See you shortly!
asktom.oracle.com/ords/asktom....
asktom.oracle.com/ords/asktom....
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
From the vault. APEX demos Formula 1 Racing Data ?. https://connor-mcdonald.com/2021/11/05/apex-demos-formula-1-racing-data/
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
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
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
youtu.be/tPVfJrxXSpI
From the vault. SAMPLE costing. https://connor-mcdonald.com/2016/01/27/sample-costing
January 13, 2026 at 6:08 PM
From the vault. SAMPLE costing. https://connor-mcdonald.com/2016/01/27/sample-costing
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
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
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
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
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 :-) . ChatGPT versus India. https://connor-mcdonald.com/2023/08/01/chatgpt-versus-india/
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
Blog greatest hits :-) . Complex materialized views and fast refresh. https://connor-mcdonald.com/2018/07/05/complex-materialized-views-and-fast-refresh/
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
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/
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!
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
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!
After fixing countless database nightmares, this resonates deeply.
What tech skill is most underrated? DM me your thoughts!
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
Previously on the blog. Counting business days between 2 dates. https://connor-mcdonald.com/2021/02/08/counting-business-days-between-2-dates/
Boolean is finally coming! Here's how to make the leap!
January 9, 2026 at 9:48 AM
Boolean is finally coming! Here's how to make the leap!
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
Blast from the past. Avoiding public embarrassment with triggers. https://connor-mcdonald.com/2015/08/21/avoiding-public-embarrassment-with-triggers
That kinda week here in Aus
January 8, 2026 at 2:43 PM
That kinda week here in Aus
What's the first thing *you* are going to do?
January 8, 2026 at 1:28 PM
What's the first thing *you* are going to do?
Heads up for long term LiveSQL users:
January 8, 2026 at 6:36 AM
Heads up for long term LiveSQL users:
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
Previously on the blog. Database dictionary corruption ? Maybe not.. https://connor-mcdonald.com/2016/03/16/database-dictionary-corruption-maybe-not
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
I do not every Slack workspace I'm a member of to suggest I send a "Happy New Year" message 😡
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
Blog greatest hits :-) . Mr DISTINCT might not be your friend. https://connor-mcdonald.com/2015/08/15/mr-distinct-might-not-be-your-friend
Great post for any IT professional to read
addyosmani.com/blog/21-less...
addyosmani.com/blog/21-less...
21 Lessons From 14 Years at Google
Lessons learned from 14 years of engineering at Google, focusing on what truly matters beyond just writing great code.
addyosmani.com
January 6, 2026 at 8:15 AM
Great post for any IT professional to read
addyosmani.com/blog/21-less...
addyosmani.com/blog/21-less...