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
December 29, 2025 at 6:08 PM
December 28, 2025 at 6:08 PM
December 27, 2025 at 6:08 PM
Previously on the blog. Bitwise operations. https://connor-mcdonald.com/2016/02/08/bitwise-operations
December 26, 2025 at 6:08 PM
Previously on the blog. Session killin time. https://connor-mcdonald.com/2017/04/24/session-killin-time
December 25, 2025 at 6:08 PM
Reposted by Connor McDonald on Database and SQL
Do you remember the famous #Earthrise photo from #Apollo8? On Christmas Eve in 1968, William Anders turned his camera toward Earth and captured the legendary photo. It showed humans a new perspective, with the moon in the foreground and Earth floating in distant space. 🌎🚀🔭📸
buff.ly/s01u0Ww

📸 NASA.
December 24, 2025 at 3:30 PM
Twas the night AFTER Christmas,
And all through the house,
Not a creature was stirring,

..because we all ate and drank waaayyyy too much
December 25, 2025 at 10:22 AM
We're Aussies...we get shit done
The Australian government has announced a gun buyback in the wake of the Bondi Beach attack. The scheme is the largest since the Port Arthur massacre in 1996, which left 35 people dead & prompted Australia to introduce world-leading gun control measures. www.bbc.com/news/article...
Australia announced gun buyback scheme in wake of Bondi attack
It is the largest scheme since the Port Arthur massacre in 1996, which prompted massive gun law reform.
www.bbc.com
December 25, 2025 at 10:15 AM
From the forward timezone, wishing you a Merry Christmas if you celebrate, and a relaxing restful time if you don't. #BestCommunityEver
a cat is surrounded by christmas lights and the word woohoo is on the bottom
ALT: a cat is surrounded by christmas lights and the word woohoo is on the bottom
media.tenor.com
December 24, 2025 at 11:25 PM
Previously on the blog. PGA memory consumption with BLOBs. https://connor-mcdonald.com/2020/04/07/will-a-blob-eat-all-my-memory/
December 24, 2025 at 6:08 PM
My only issue with apps that are following the deployment methodology of "Minimum Viable Product" is that my definition of "viable" of vastly different to theirs :-)
December 23, 2025 at 11:33 PM
Blast from the past. Existence checks. https://connor-mcdonald.com/2015/10/19/existence-checks
December 23, 2025 at 6:08 PM
Finished editing the last video of the year ...time to celebrate
December 23, 2025 at 1:56 PM
December 22, 2025 at 6:08 PM
Blog greatest hits :-) . The ultimate database FREE edition. https://connor-mcdonald.com/2023/12/18/the-ultimate-database-free-edition/
December 21, 2025 at 6:08 PM
Blast from the past. DIY parallel task execution. https://connor-mcdonald.com/2017/06/22/diy-parallel-task-execution/
December 20, 2025 at 6:08 PM
Retro blog post. Some must-have ideas for your next meetup. https://connor-mcdonald.com/2023/05/24/some-must-have-ideas-for-your-next-meetup/
December 19, 2025 at 6:08 PM
We had 2minutes left in last night's AskTOM Live when someone asked "Will AI take my job?". That's a BIG question, but here's my 2 minute take.
December 19, 2025 at 5:15 AM
Reposted by Connor McDonald on Database and SQL
Will you have some "downtime" between Christmas and New Year?

How about using that time to learn how to upgrade your database to Oracle AI Database 26ai and be ready for the January release?

I’m compiling high-quality material in this blog post.

alexzaballa.com/everything-y...
December 18, 2025 at 5:22 PM
Blast from the past. Converting LONG to CLOB. https://connor-mcdonald.com/2016/01/20/converting-long-to-clob
December 18, 2025 at 6:08 PM
One of the last AskTom Live sessions of the year!
It's a pretty casual one tonight - come along and hang out :-)
asktom.oracle.com/ords/r/tech/...
asktom.oracle.com
December 18, 2025 at 11:21 AM
Quick tip. When refreshing a materialized view and you get ORA-1031: Insufficient privileges, before you race off granting anything, first thing to do is check you didn't just simply misspell the mview name
December 18, 2025 at 3:59 AM
and ... we're in!

Details on Jeff's blog
www.thatjeffsmith.com/archive/2025...
December 18, 2025 at 12:22 AM
Reposted by Connor McDonald on Database and SQL
ICYMI, ORDS 25.4 is available for download and being updated across the Autonomous fleet. Link: www.oracle.com/database/sql...

We've updated our image in the Oracle Container Registry, made doc improvements, and added fixes too. Release Notes: www.oracle.com/tools/ords/o... #newrelease #ords #apis
December 17, 2025 at 10:33 PM