• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!

Tag: design

August 10, 2022 Uncategorized

Natural Keys versus Surrogate Keys….Here we are again!

Well….that blew up! 😀 Last week I published a video (which you can watch below if you haven’t seen it)

Continue reading

August 8, 2022 Uncategorized

A simple benchmark harness

At my physical design talk at this year’s Yatra tour in India, one of the demos I do is multiple

Continue reading

a close up of a sleeping dog with its tongue hanging out
February 16, 2022 Uncategorized

INITRANS grabs a little more space

INITRANS defines how many concurrent transactions you can have within a single datablock for a segment (table, materialized view, etc).

Continue reading

August 3, 2021 Uncategorized

Blockchain tables … the usage model

When you hear the word “blockchain” we typically think of the properties associated with tamper-proof information, with terminology such as

Continue reading

September 7, 2017 Uncategorized

Please keep your foreign keys

I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key

Continue reading

June 19, 2017 Uncategorized

It’s just bad code or bad design … most of the time

Some years ago I wrote an article for the UKOUG magazine called “Want a faster database – Take a drive

Continue reading

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Tweets by connor_mc_d

    Top Posts & Pages

    • The new forums
    • How to do a GRANT on an entire schema
    • The simple fix to date queries
    • How to TREAT data in a CLOB as JSON
    • Generating INSERT scripts that run fast!
    • Connection shortcuts with a wallet
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    • Digging deeper into SQL under APEX
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 848 other followers
      • Already have a WordPress.com account? Log in now.
      • Learning is not a spectator sport
      • Customize
      • Follow Following
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar
     

    Loading Comments...