Database Normalization is the process of reducing or eliminating data redundancy in a database table as well as reducing the likelihood of data insertion anomalies. There are many articles online that talk about, in theory, how to normalize database tables…This post is intended to serve as a practical application demonstration.
Optimizing your database tables is an essential task and the performance results might amaze you. Optimization is essentially the process of defragmenting your database tables. Then you use variable-length database fields such as VARCHAR, BLOB, TEXT, or VARBINARY, defragmentation can occur when rows are deleted. Continue reading »
Much of what you find here will consist of my lectures and ramblings on the state of various technologies. Doesn't that sound like fun?! Hopefully you can find some useful information, experience, how-tos, code snippets, and whatever else...
