• 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: modelling

June 8, 2018 Uncategorized

The AskTOM data model

I popped out a tweet yesterday in Throwback Thursday style showing the date of the first question we took AskTOM

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

October 6, 2016 Uncategorized

Data denormalization … another take

I read an interesting article the other day about data modelling and data denormalization. I’ll paraphrase the topic and requirement

Continue reading

March 11, 2016 Uncategorized

Tightening up your data model

Having NOT NULL constraints declared on columns that are genuinely not nullable not only is good practice, but can yield

Continue reading

November 23, 2015 Uncategorized

A justification for referential integrity constraints

Yes, I know what you’re thinking. “Here we go again.  Another database dude about to get stuck into us telling

Continue reading

October 10, 2015 Uncategorized

Why I love working on AskTom

Today a question came in, and Swapnasis provided a nice simple test case, which makes my job so much easier. 

Continue reading

May 14, 2013 Uncategorized

Datatype discipline

(This is based on some ‘issues’ a client was having, so the example is architected to make a particular point,

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

    • Bringing Multimedia back into 19c!
    • How do I stop the use of TRUNCATE
    • Let's talk about Techiquette
    • Adding APEX 23.1 to your Database Free VM
    • Why I blog
    • How to do a GRANT on an entire schema
    • Implementing dynamic partitions AND subpartitions
    • How to generate random unique values
    • How to TREAT data in a CLOB as JSON
    • Is "fragmentation" still a dirty word?
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 863 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