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
Blog greatest hits :-) . Math and SQL: Two of my favourite things. https://connor-mcdonald.com/2020/11/02/math-and-sql-two-of-my-favourite-things/
December 10, 2025 at 6:08 PM
Blog greatest hits :-) . Math and SQL: Two of my favourite things. https://connor-mcdonald.com/2020/11/02/math-and-sql-two-of-my-favourite-things/
Christmas is nearly here ... and so is the new database :-)
connor-mcdonald.com/2025/12/10/t...
connor-mcdonald.com/2025/12/10/t...
The Christmas database
With Oracle AI Database 26ai finally ready for on-prem release, it means we can all celebrate a little something at Christmas time :-) On the first day of Christmas, my DB gave to me… A VECTO…
connor-mcdonald.com
December 10, 2025 at 10:19 AM
Christmas is nearly here ... and so is the new database :-)
connor-mcdonald.com/2025/12/10/t...
connor-mcdonald.com/2025/12/10/t...
From the vault. Taking the LEAP. https://connor-mcdonald.com/2024/12/19/kris-kringle-the-database-taking-the-leap/
December 9, 2025 at 6:08 PM
From the vault. Taking the LEAP. https://connor-mcdonald.com/2024/12/19/kris-kringle-the-database-taking-the-leap/
Why take your tech journey alone, when you could take a guide with you... In fact, many many guides.
🎉 We’re live! The #OracleACE Apprentice program is officially open—welcome to everyone who pre-registered (check your inbox soon!) and all new applicants.
Ready to start your advocacy journey? Learn more & register here 👉
ace.oracle.com/apprentice
Ready to start your advocacy journey? Learn more & register here 👉
ace.oracle.com/apprentice
December 8, 2025 at 11:00 PM
Why take your tech journey alone, when you could take a guide with you... In fact, many many guides.
Blast from the past. Ubers move to MySQL. https://connor-mcdonald.com/2016/08/10/ubers-move-to-mysql
December 8, 2025 at 6:08 PM
Blast from the past. Ubers move to MySQL. https://connor-mcdonald.com/2016/08/10/ubers-move-to-mysql
Reposted by Connor McDonald on Database and SQL
New - or updated - event
Multicloud AIWorld 2026
on www.clocwise.org.
CfP ends on 25-DEC-2025, but dont wait and head over to https://www.aioug.org/mc-cfp now and submit!
@aioug
Multicloud AIWorld 2026
on www.clocwise.org.
CfP ends on 25-DEC-2025, but dont wait and head over to https://www.aioug.org/mc-cfp now and submit!
@aioug
December 8, 2025 at 1:00 PM
New - or updated - event
Multicloud AIWorld 2026
on www.clocwise.org.
CfP ends on 25-DEC-2025, but dont wait and head over to https://www.aioug.org/mc-cfp now and submit!
@aioug
Multicloud AIWorld 2026
on www.clocwise.org.
CfP ends on 25-DEC-2025, but dont wait and head over to https://www.aioug.org/mc-cfp now and submit!
@aioug
New video!
We're all familiar with upgrading your application, or upgrading your database, but what on earth does upgrading your bind variables mean? It might be a good thing, it might be a bad thing.
youtu.be/lKhMtyit-WI
We're all familiar with upgrading your application, or upgrading your database, but what on earth does upgrading your bind variables mean? It might be a good thing, it might be a bad thing.
youtu.be/lKhMtyit-WI
My bind variable got UPGRADED. What does that mean?
YouTube video by SQL and Database explained!
youtu.be
December 8, 2025 at 7:35 AM
New video!
We're all familiar with upgrading your application, or upgrading your database, but what on earth does upgrading your bind variables mean? It might be a good thing, it might be a bad thing.
youtu.be/lKhMtyit-WI
We're all familiar with upgrading your application, or upgrading your database, but what on earth does upgrading your bind variables mean? It might be a good thing, it might be a bad thing.
youtu.be/lKhMtyit-WI
Want to see all the Oracle tech diagrams in one place? It's here in the docs
docs.oracle.com/en/database/...
HT Kevin
docs.oracle.com/en/database/...
HT Kevin
December 8, 2025 at 2:21 AM
Want to see all the Oracle tech diagrams in one place? It's here in the docs
docs.oracle.com/en/database/...
HT Kevin
docs.oracle.com/en/database/...
HT Kevin
Nice new modern look to MOS
December 7, 2025 at 11:59 PM
Nice new modern look to MOS
Previously on the blog. Why I blog. https://connor-mcdonald.com/2023/05/29/why-i-blog/
December 7, 2025 at 6:08 PM
Previously on the blog. Why I blog. https://connor-mcdonald.com/2023/05/29/why-i-blog/
Previously on the blog. Loading file data easier than you think. https://connor-mcdonald.com/2015/08/17/loading-file-data-easier-than-you-think
December 5, 2025 at 6:08 PM
Previously on the blog. Loading file data easier than you think. https://connor-mcdonald.com/2015/08/17/loading-file-data-easier-than-you-think
Tuning a bad SQL can be a breeze when you're a DBA and have access to the "all the things", but how about SQL tuning when you DON'T have many database privileges...
connor-mcdonald.com/2025/12/04/t...
connor-mcdonald.com/2025/12/04/t...
Tuning SQL without any access
Wherever our database resides, it is often the case that we want our developer to have access to performance tools in order to ensure that the SQL they write will not cause any issues when it arriv…
connor-mcdonald.com
December 5, 2025 at 7:37 AM
Tuning a bad SQL can be a breeze when you're a DBA and have access to the "all the things", but how about SQL tuning when you DON'T have many database privileges...
connor-mcdonald.com/2025/12/04/t...
connor-mcdonald.com/2025/12/04/t...
Blog greatest hits :-) . Top Ten Travel hints and Tips. https://connor-mcdonald.com/2017/06/27/top-ten-travel-hints-and-tips/
December 4, 2025 at 6:08 PM
Blog greatest hits :-) . Top Ten Travel hints and Tips. https://connor-mcdonald.com/2017/06/27/top-ten-travel-hints-and-tips/
It's not new to 26ai, but it's the first time we've described it in the docs. So if you're still thinking there's only an SGA and a PGA ... let me introduce you to the MGA
docs.oracle.com/en/database/...
docs.oracle.com/en/database/...
December 4, 2025 at 7:24 AM
It's not new to 26ai, but it's the first time we've described it in the docs. So if you're still thinking there's only an SGA and a PGA ... let me introduce you to the MGA
docs.oracle.com/en/database/...
docs.oracle.com/en/database/...
For my english friends.... Miiitttcccchhhheeeellllll STAARRRCCCCCC 😄
a man in a white shirt is standing in front of a crowd holding a ball .
ALT: a man in a white shirt is standing in front of a crowd holding a ball .
media.tenor.com
December 4, 2025 at 4:06 AM
For my english friends.... Miiitttcccchhhheeeellllll STAARRRCCCCCC 😄
I ... am ... pumped....
December 3, 2025 at 10:02 PM
I ... am ... pumped....
Blog greatest hits :-) . Auto-backups of PLSQL source. https://connor-mcdonald.com/2016/02/02/auto-backups-of-plsql-source
December 3, 2025 at 6:08 PM
Blog greatest hits :-) . Auto-backups of PLSQL source. https://connor-mcdonald.com/2016/02/02/auto-backups-of-plsql-source
Fresh video! One of the coolest innovations in recent releases of the Oracle Database was the ability to perform common maintenance tasks without needing downtime simply by adding the ONLINE keyword. But how online is it really?
youtu.be/qphx7HTyx-M
youtu.be/qphx7HTyx-M
The Truth About ALTER TABLE MOVE ONLINE - is it REALLY online?
YouTube video by SQL and Database explained!
youtu.be
December 3, 2025 at 9:17 AM
Fresh video! One of the coolest innovations in recent releases of the Oracle Database was the ability to perform common maintenance tasks without needing downtime simply by adding the ONLINE keyword. But how online is it really?
youtu.be/qphx7HTyx-M
youtu.be/qphx7HTyx-M
User group conferences are great ANYWHERE, but there's a special feeling when it's in your own part of the world.
connor-mcdonald.com/2025/12/03/a...
connor-mcdonald.com/2025/12/03/a...
APAC conferences wrap up
Conferences ARE BACK in APAC – Perth, Melbourne, and New Zealand! After not having conferences last year, it was fantastic to see a full APAC conference circuit this year. This season took me…
connor-mcdonald.com
December 3, 2025 at 4:28 AM
User group conferences are great ANYWHERE, but there's a special feeling when it's in your own part of the world.
connor-mcdonald.com/2025/12/03/a...
connor-mcdonald.com/2025/12/03/a...
Blog greatest hits :-) . Technology debates. https://connor-mcdonald.com/2016/04/08/technology-debates
December 2, 2025 at 6:08 PM
Blog greatest hits :-) . Technology debates. https://connor-mcdonald.com/2016/04/08/technology-debates
When you guys all gonna move to Perth so I can join in :-)
December 2, 2025 at 3:44 AM
When you guys all gonna move to Perth so I can join in :-)
A friend of mine at their workplace got an email: "Putting up christmas decorations in the office is fine, but remember no sticking tape is to be used due to workplace injury risk".
Serious question - how does sticking tape create such a risk?
Serious question - how does sticking tape create such a risk?
December 2, 2025 at 3:38 AM
A friend of mine at their workplace got an email: "Putting up christmas decorations in the office is fine, but remember no sticking tape is to be used due to workplace injury risk".
Serious question - how does sticking tape create such a risk?
Serious question - how does sticking tape create such a risk?