Dare Obasanjo says do not normalize immutable data, and refers to Pat Helland’s presentation. Database Normalization is an activity in database design to reduce redundancy and eliminate update anomalies. In short, it minimizes possibility of loss of data integrity while updating data. [Continue]
Thomas Mueller, in a very clear and detailed manner, explains the various ways of preventing SQL Injection. SQL Injection is one of the biggest security worries. If not handled properly you can leave your entire application open for getting hacked. [Continue]
SQL Injection is probably the best reason, other than speed of execution sometimes, to use stored procedures instead of dynamic SQL queries. Ill-intentioned users can inject character literals through their input that can be used to comment out part of the query being executed. Scott Glu has a tip on ways of preventing it (via Miguel de Icaza). [Continue]