Jeff I made no personal attack. I said the *point* was silly, not the person. And it is. Trying to tell me that *if I had written...

<< If you hit the average business user with your training, they're not coming to the second session.>>

Not been my experience, and I just finished a contract at SLAC that...

YES, but first you must set the classifier function to null for the governor. then you can alter the function. then you will have to reconfigure the governor to...

<<I would imagine that the first thing you would do is explain the concept of entities and tables >>

Actually, no, not at all. The first thing I do is...

Hi Paul,

What I try to do when I train beginners in DB work is to emphasize Codd's fundamental logical concepts- in layman's language.

I start out with...

Well I guess you totally and completely missed my point. If there is a more fundamental and foundational concept to db design than preventing duplicates, I don't know what...

I have to admit I am surprised that the consensus seems to be here that it takes an expert to design a database that will prevent duplicates or that the...

<<To trash this article and say it doesn't provide good information is a fairly poor commentary. >>

I respectfully disagree. To provide a teaching example for a database design that...

<<struggling with the same points you find yourself struggling on>>

Happily, I haven't struggled with the issues I have just described since many years 🙂 Thanks to Fabian Pascal...

re. new customer record. And there is no unique index on the business key. So as a result, an unlimited number of exact duplicate customer records could also...

re. Inroduction. Well I suppose it depends on what you feel are the "fundamentals" of our work in DB design. Personally, concepts such as natural business keys (the...

I should dd that bob's original paper receipts were MORE accurate than the DB design offered. At least the paper receipts would always return accurate info for the customer...

I believe there are some serious flaws in this article. For example, recepts represent a historical record of a transaction occuring in a moment in time.

If one normalizes...

Hi,

And if you need more tsql programmers to compensate for less c# programmers, where is the gain?

In my opinion, *less* code is almost always a good thing -...

Having different specifications for a finished deliverable does not mean the methods one uses to implement the deliverable have to be different.

I worked for years in custom manufacturing industry. ...