You must have successfully identified business keys before.

So it must be easy for you to show couple of examples (from your experience) where natural keys were just right to identify...

Ok, I'll change it to "in many cases." My point was that it seems to...

I've worked in companies with a reliable employee number...

In most cases there isn't one. I would certainly never use an SSN for this. But that doesn't mean that this...

We have? Must have been asleep....;-)

Heh.... I would tend towards the opposite, an OLTP is much more likely to be a candidate for an identity or some kind of system generated id because an OLTP...

And if you're one of those folks that think you can identify customers or accounts by some form of natural key because "IDENTITY" columns are supposedly evil, then you need...

I agree with you, and maybe you, I, and some others can make that distinction. ...

I have also been accused of over-normalizing. In my view, however, those saying that simply weren't apply the rigor necessary to produce a correct database. And I know...

Perhaps one way to make restores easier is to generate the restore script at backup time for any particular full backup.

That could be a great way to improve the restore...

Not sure I agree with the complexity. I had a large database that took both a long time to backup and a long time to restore. Then, based...

Not sure if I'm understanding...

For the frozen values: I need to historized or version the rows in the fact table using valid from and to columns, because business wants to know the value of...

That you know it's an accumulated snapshot table shows you have some grasp of this. I'm assuming that this is correct, though from your description, it sounds correct. ...

Thanks. A blank would be good enough. I know you weren't trying to tie a bow on the "Nope" answer, but a better way in this case would...