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
The most common phrase I see in my social media feed on just about any platform nowadays is:

"This video is generated by AI"

😡
February 19, 2026 at 12:14 AM
From the vault. Searching in Oracle Database documentation. https://connor-mcdonald.com/2018/07/18/searching-in-oracle-database-documentation/
February 18, 2026 at 6:08 PM
From the vault. Age calculations Just how old ARE you?. https://connor-mcdonald.com/2020/09/11/age-calculations-just-how-old-are-you/
February 17, 2026 at 6:08 PM
Reposted by Connor McDonald on Database and SQL
a single SQL class has brought immeasurable peace and happiness in my professional life. who knew?
February 17, 2026 at 12:20 AM
PSA: Perfect example of how to act at the baggage carousel. Stay well back, plenty of space, lets everyone see easily, avoids cramming and accidents. It ain't that hard.
February 17, 2026 at 12:22 AM
Reposted by Connor McDonald on Database and SQL
Understanding a complex data model is challenging

@connormcd.bsky.social explains how you can make this easier in Oracle AI Database with

Constraints to improve data quality
Usecase domains to describe values
Schema annotations to add metadata
The Moment for Database Documentation has come!
Confluent Director Adi Polak posted this tweet earlier today regarding SQL and understanding the data model. I’m in agreement with her on both things, namely SQL is not a difficult thing to l…
buff.ly
February 11, 2026 at 12:01 PM
Blast from the past. The missing multiplication aggregation in SQL. https://connor-mcdonald.com/2020/11/18/the-missing-multiplication-aggregation-in-sql/
February 16, 2026 at 6:08 PM
Grateful for once in a lifetime opportunity to talk to 1000+ Comp Sci students in India.... Now the goal is to turn "once" into "twice", "thrice" and so on...
February 16, 2026 at 1:11 PM
Homeward bound. I love airports that have greenery
#Bengaluru
February 14, 2026 at 11:29 AM
Pretty sure @kelseyhightower.com isn't talking about databases here 😁, but the same rules apply. Take advantage of your declarative constraints
Creating with constraints exposes craftsmanship.
February 12, 2026 at 12:21 PM
Blast from the past. The art of describing a problem. https://connor-mcdonald.com/2015/12/14/the-art-of-describing-a-problem
February 10, 2026 at 6:08 PM
Buzzing in AI world Mumbai 🔥
February 10, 2026 at 6:44 AM
Reposted by Connor McDonald on Database and SQL
What I lost in Twitter, I found in Bluesky.
February 10, 2026 at 3:14 AM
Blast from the past. Free In-memory in Oracle Database 19c. https://connor-mcdonald.com/2020/05/01/in-memory-opportunities-abound/
February 9, 2026 at 6:08 PM
What a wild day with the students in Bengaluru 🔥🔥🔥
February 9, 2026 at 2:27 PM
Reposted by Connor McDonald on Database and SQL
What has happened to the 19.29 and 19.30 RUs?

Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don't…
What has happened to the 19.29 and 19.30 RUs?
Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don't have OJVM configured but install the OJVM bundle. So, what has happened to the 19.29 and 19.30 RUs??
mikedietrichde.com
February 9, 2026 at 10:22 AM
Blast from the past. DDL gets my goat. https://connor-mcdonald.com/2020/07/22/ddl-gets-my-goat/
February 8, 2026 at 6:08 PM
There is a difference between

"Hi Connor, I tagged you on my linkedin post"

and

"Hi Connor, I tagged you on my linkedin post. You HAVE to comment on it. I am going to follow you around just to make sure that you do it"

Yeah, that ain't the way bro.
February 8, 2026 at 9:55 AM
Just a typical Sunday in Bengaluru... #oracle #community
February 8, 2026 at 3:05 AM
Previously on the blog. Larger number of Exadata storage indexes. https://connor-mcdonald.com/2019/11/19/exadata-storage-indexes/
February 7, 2026 at 6:08 PM
AIOUG multi cloud AI conference is to in Hyderabad! Full house on weekend!
February 7, 2026 at 4:42 AM
Blog greatest hits :-) . Nulls are not stored in indexes most of the time. https://connor-mcdonald.com/2020/03/04/nulls-are-not-stored-in-indexes-most-of-the-time/
February 6, 2026 at 6:08 PM
When an athlete says they are just "working out the final few wrinkles" 😂
February 6, 2026 at 1:39 PM
February 5, 2026 at 6:08 PM
Blast from the past. Take care with regular expressions. https://connor-mcdonald.com/2018/08/22/take-care-with-regular-expressions/
February 4, 2026 at 6:08 PM