Connor McDonald on Database and SQL

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

Be careful when talking about 26ai IN-LIST processing. My girlfriend wasn't happy :-)

Full video on youtube youtu.be/lo1OJCv8_dM

Previously on the blog. Histograms on data (not the optimizer). https://connor-mcdonald.com/2016/01/27/histograms-on-data-not-the-optimizer

Blast from the past. Why you might add columns to external tables. https://connor-mcdonald.com/2020/04/30/adding-columns-to-external-tables-idiocy/

Previously on the blog. Multiple partitions. https://connor-mcdonald.com/2016/01/18/multiple-partitions

Vectorised my entire photo library on the home NAS with a model that supports images and text, and now I can find pics much easier with SQL :-)

With probably throw a little APEX app on top.

#26ai