bill.sugden (3/2/2010)

---

Give the guy a break - this is aimed at newbies.

Right - it is a no-brainer for us grizzled database developers. I can add a little constructive criticism though...

Just to butt in, I would say that normalisation is the standard way of decoupling data in a relational database.

My understanding is that in this standard relational database design pattern (as highlighted by the previous posters) and what the article refers to as a 'bridge table' is commonly referred...

David Portas (3/2/2010)

---

Gary Varga (3/1/2010)

---

A great example of this is when systems use email addresses as the ID. Unless you maintain your own domain, all it takes is a change...

I am amazed how many times that users have clearly identified unique identifiers which, during their day to day operation, do not always get set, change or perhaps do not...

I tend to find that the Open Errors Policy is the best. When you have that kind of culture no error is hidden, a given error gets added to various...

Too right Tom! You have to trust the team to be mature enough to enjoy the infantile mechanisms for reasonable and professional purposes. It's crazy but it works because we...

amurray-1090291 (2/26/2010)

---

We store everything in UTC along with a "UTC Offset" in hours, calculated at the time the record was inserted. When running a query months later when DST has...

majorbloodnock (2/25/2010)

---

Gary Varga (2/25/2010)

---

...like...

...like only using agreed...

djackson 22568 (2/25/2010)

---

I agree with the article suggestions, but in today's economic environment I find that most people no longer want to hear they made any mistakes. I don't...

Hey, we are all agreeing!!!

In the right environment, a public correction can have a great deal of benefit for many. It attempts to dispel urban myths and encourages open debate. Obviously, this is different...

jcrawf02 (2/24/2010)

---

CirquedeSQLeil (2/24/2010)

---

jcrawf02 (2/24/2010)

---

String parsing like cleanup? Or extracting elements?

Just started playing with xQuery, just curious how it would compare (now I have to go find out) [rant] who...

Is it for real cash or vouchers for pork chops?