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
"Oh, I'll just attend the webinar"
"Maybe I will download the slides"
Neither of that will EVER reproduce the value of sharing your knowledge and experiences face to face with your community colleagues at a meetup.
Support your local user group
"Maybe I will download the slides"
Neither of that will EVER reproduce the value of sharing your knowledge and experiences face to face with your community colleagues at a meetup.
Support your local user group
November 26, 2025 at 7:32 AM
"Oh, I'll just attend the webinar"
"Maybe I will download the slides"
Neither of that will EVER reproduce the value of sharing your knowledge and experiences face to face with your community colleagues at a meetup.
Support your local user group
"Maybe I will download the slides"
Neither of that will EVER reproduce the value of sharing your knowledge and experiences face to face with your community colleagues at a meetup.
Support your local user group
Plenty of new security features in the latest Oracle Database version. HT @GavinSoorma
November 26, 2025 at 12:38 AM
Plenty of new security features in the latest Oracle Database version. HT @GavinSoorma
Blog greatest hits :-) . Formula 1 data staying up to date. https://connor-mcdonald.com/2021/11/12/formula-1-data-staying-up-to-date/
November 25, 2025 at 6:08 PM
Blog greatest hits :-) . Formula 1 data staying up to date. https://connor-mcdonald.com/2021/11/12/formula-1-data-staying-up-to-date/
SQL is not just great at analyzing your data, it can also be used to analyze hypothetical scenarios where you do NOT have data.
youtu.be/AJNUidMKMSg
youtu.be/AJNUidMKMSg
"Hypothetically speaking ... RANK my data"
YouTube video by SQL and Database explained!
youtu.be
November 25, 2025 at 3:00 AM
SQL is not just great at analyzing your data, it can also be used to analyze hypothetical scenarios where you do NOT have data.
youtu.be/AJNUidMKMSg
youtu.be/AJNUidMKMSg
TIL if your android mobile/tablet judges that its clock is too far away from reality, it will not allow most Google apps to start at all. No play store, no google services etc etc...
Simple fix ... once you know :-)
Simple fix ... once you know :-)
November 25, 2025 at 12:35 AM
TIL if your android mobile/tablet judges that its clock is too far away from reality, it will not allow most Google apps to start at all. No play store, no google services etc etc...
Simple fix ... once you know :-)
Simple fix ... once you know :-)
Retro blog post. dbms_output and the scheduler. https://connor-mcdonald.com/2016/06/27/dbms_output-and-the-scheduler
November 24, 2025 at 6:08 PM
Retro blog post. dbms_output and the scheduler. https://connor-mcdonald.com/2016/06/27/dbms_output-and-the-scheduler
Toasting a successful Perth AUSOUG conference. Kudos to the committee and team
November 24, 2025 at 1:12 PM
Toasting a successful Perth AUSOUG conference. Kudos to the committee and team
Nice buzz in Perth for the AUSOUG conference
November 24, 2025 at 2:59 AM
Nice buzz in Perth for the AUSOUG conference
Blast from the past. A cool thing with EXCHANGE PARTITION (part2). https://connor-mcdonald.com/2016/05/19/a-cool-thing-with-exchange-partition-part-1
November 23, 2025 at 6:08 PM
Blast from the past. A cool thing with EXCHANGE PARTITION (part2). https://connor-mcdonald.com/2016/05/19/a-cool-thing-with-exchange-partition-part-1
Blog greatest hits :-) . Easy as pi...hole.. https://connor-mcdonald.com/2018/10/03/easy-as-pi-hole
November 22, 2025 at 6:08 PM
Blog greatest hits :-) . Easy as pi...hole.. https://connor-mcdonald.com/2018/10/03/easy-as-pi-hole
That awkward moment when you come up with a hypothesis, craft a test case and proof for your theory, validate your theory, share it with colleagues, get their buy in....
... and then lying in bed you realise that your theory, proof and demo are complete bullshit 🤦♀️
... and then lying in bed you realise that your theory, proof and demo are complete bullshit 🤦♀️
November 22, 2025 at 12:31 AM
That awkward moment when you come up with a hypothesis, craft a test case and proof for your theory, validate your theory, share it with colleagues, get their buy in....
... and then lying in bed you realise that your theory, proof and demo are complete bullshit 🤦♀️
... and then lying in bed you realise that your theory, proof and demo are complete bullshit 🤦♀️
Retro blog post. Time zones- blockchain and stopping hackers. https://connor-mcdonald.com/2021/07/30/time-zones-blockchain-and-stopping-hackers/
November 21, 2025 at 6:08 PM
Retro blog post. Time zones- blockchain and stopping hackers. https://connor-mcdonald.com/2021/07/30/time-zones-blockchain-and-stopping-hackers/
Retro blog post. Index compression working out the compression number. https://connor-mcdonald.com/2015/08/05/index-compressionworking-out-the-compression-number
November 20, 2025 at 6:08 PM
Retro blog post. Index compression working out the compression number. https://connor-mcdonald.com/2015/08/05/index-compressionworking-out-the-compression-number
The absolutely perfect first 30 seconds of tonight's Office Hours 🐕🤮
November 20, 2025 at 3:23 PM
The absolutely perfect first 30 seconds of tonight's Office Hours 🐕🤮
Later today, once you've tucked into that fine DOAG conference lunch and just need somewhere quiet to rest your tummy.... come check out today's database Office Hours :-)
asktom.oracle.com/ords/asktom....
asktom.oracle.com/ords/asktom....
asktom.oracle.com
November 20, 2025 at 7:53 AM
Later today, once you've tucked into that fine DOAG conference lunch and just need somewhere quiet to rest your tummy.... come check out today's database Office Hours :-)
asktom.oracle.com/ords/asktom....
asktom.oracle.com/ords/asktom....
Blog greatest hits :-) . Syntax formatter might change your data. https://connor-mcdonald.com/2016/08/12/syntax-formatter-might-change-your-data
November 19, 2025 at 6:08 PM
Blog greatest hits :-) . Syntax formatter might change your data. https://connor-mcdonald.com/2016/08/12/syntax-formatter-might-change-your-data
Reposted by Connor McDonald on Database and SQL
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
November 19, 2025 at 8:23 AM
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
Blog greatest hits :-) . More Boolean features in 23ai. https://connor-mcdonald.com/2023/06/09/more-boolean-features-in-23c/
November 18, 2025 at 6:08 PM
Blog greatest hits :-) . More Boolean features in 23ai. https://connor-mcdonald.com/2023/06/09/more-boolean-features-in-23c/
Got my November DOAG FOMO 😢
November 18, 2025 at 11:22 AM
Got my November DOAG FOMO 😢
Retro blog post. Using ROWID for efficient parallel execution. https://connor-mcdonald.com/2023/10/16/using-rowid-for-efficient-parallel-execution/
November 17, 2025 at 6:08 PM
Retro blog post. Using ROWID for efficient parallel execution. https://connor-mcdonald.com/2023/10/16/using-rowid-for-efficient-parallel-execution/
New video! OPatch is a critical part of the database patching process, but that doesn't mean you should be revealing its details to everybody.
youtu.be/npB7KHxmpOw
youtu.be/npB7KHxmpOw
Do NOT do this with OPatch
YouTube video by SQL and Database explained!
youtu.be
November 17, 2025 at 11:53 AM
New video! OPatch is a critical part of the database patching process, but that doesn't mean you should be revealing its details to everybody.
youtu.be/npB7KHxmpOw
youtu.be/npB7KHxmpOw
Blog greatest hits :-) . Standard Edition - different optimizer but still cool. https://connor-mcdonald.com/2018/07/03/standard-edition-different-optimizer-but-still-cool/
November 16, 2025 at 6:08 PM
Blog greatest hits :-) . Standard Edition - different optimizer but still cool. https://connor-mcdonald.com/2018/07/03/standard-edition-different-optimizer-but-still-cool/
November 16, 2025 at 4:13 AM
Blog greatest hits :-) . Switching services on Autonomous now easier. https://connor-mcdonald.com/2024/04/02/switching-services-on-autonomous-now-easier/
November 15, 2025 at 6:08 PM
Blog greatest hits :-) . Switching services on Autonomous now easier. https://connor-mcdonald.com/2024/04/02/switching-services-on-autonomous-now-easier/