Connor McDonald on Database and SQL

a single SQL class has brought immeasurable peace and happiness in my professional life. who knew?

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.

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…

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

Blast from the past. The missing multiplication aggregation in SQL. https://connor-mcdonald.com/2020/11/18/the-missing-multiplication-aggregation-in-sql/

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...

Homeward bound. I love airports that have greenery
#Bengaluru

My first request to microdnf is typically "hey, go get your big brother for me" 😁

Pretty sure @kelseyhightower.com isn't talking about databases here 😁, but the same rules apply. Take advantage of your declarative constraints

Blast from the past. The art of describing a problem. https://connor-mcdonald.com/2015/12/14/the-art-of-describing-a-problem

Buzzing in AI world Mumbai 🔥

What I lost in Twitter, I found in Bluesky.

Blast from the past. Free In-memory in Oracle Database 19c. https://connor-mcdonald.com/2020/05/01/in-memory-opportunities-abound/

What a wild day with the students in Bengaluru 🔥🔥🔥

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??

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…

Blast from the past. DDL gets my goat. https://connor-mcdonald.com/2020/07/22/ddl-gets-my-goat/

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.

Just a typical Sunday in Bengaluru... #oracle #community

Previously on the blog. Larger number of Exadata storage indexes. https://connor-mcdonald.com/2019/11/19/exadata-storage-indexes/

AIOUG multi cloud AI conference is to in Hyderabad! Full house on weekend!

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/

"Client-(is the)-Server"

When an athlete says they are just "working out the final few wrinkles" 😂

Retro blog post. Upgrade with no effort. https://connor-mcdonald.com/2017/09/04/upgrade-with-no-effort/

Blast from the past. Take care with regular expressions. https://connor-mcdonald.com/2018/08/22/take-care-with-regular-expressions/

Retro blog post. EXPORT not GATHER with DBMS_STATS. https://connor-mcdonald.com/2019/01/16/export-not-gather-with-dbms_stats

"Asking for a fiend" will be filed away for a long time 😂

Jumping on a plane but will get back to this.

But one cool thing ... the plan does not just growing out to "never ending" OR iterators. Above a certain threshold we pick a new vector based plan.

Thrilled to be heading back to the Indian Oracle community...but not all family members are happy about it 🥲

YouTube video by SQL and Database explained! IN-LIST changes in 26ai - My Girlfriend Dumped Me

As the saying (almost) goes: "64K should be enough for anybody" :-)
youtu.be/lo1OJCv8_dM

Blog greatest hits :-) . Code enhancements without changing code. https://connor-mcdonald.com/2016/11/01/code-enhancements-without-changing-code