I would recommend SQLDeveloper by Oracle. It has the same feature set as Toad, but is completely free. It can attach to Oracle, MySQL, and SQL Server simultaneously. I...

Just another point of view. I live in an Oracle, DB2, SQL Server world. Here is a companion article on Oracle's forums which came out about the same time as...

The "Never Use NULL's" rule only holds true in OLTP. BI and Reporting almost always need to have some way of distinguishing: unknown, not applicable, empty, and zero.

Take Date...

Troy,

Sorry to be so critical. I have been burned by people who use the title "Data Modeller" and they really are not. Or the Object crowd that don't care about...

This article is so "motherhood and apple pie" it says nothing. I do not think the work normalize or denormalize is even used. The author also did not even mention...