OPTIMIZE FOR UNKNOWN - How could that possibly make any sense???

Yes, I’m alive. I have been chatting with my wife about the times I need to “go dark” – in this case, I am working on features that I can’t discuss yet, other than to say that I am *very* excited to go to work every day.. (well, since I work out of my house,…

3

Foreign Keys are our friends...

I often find customers who question the value of database-enforced integrity constraints.   While people often create primary keys, the foreign ones are perhaps a bit more …. well, foreign.  Let’s start at the beginning. In traditional, old-school database design, you take your business object and you divide it up into tables. A foreign key (FK)…

3