Database Management in one of the least respected and talked about arts in technology.

The DBA is responsible for installing and upgrading updates and patches to the database server, monitoring the health of the database server, using storage properly, managing database users / security and most importantly backup and recovery of all databases.

In a dynamic driven website, the data is the most important component. Without this, there would be no website.

Working at a few different companied across North America prior to joining Pencilneck Software, I have found that development companies are unaware and oblivious at how important it is to have a well thought out database maintenance procedure in place, just in case.

This is where Pencilneck Software outshines all competitors. We have extensive maintenance, backup and restoration procedures in place, ensuring that in a worst case scenario we can restore all databases within a few hours, with minimal data loss.

A custom database backup script was created to backup and ftp these backups to a secure location, and multiple intervals, ensuring that we are prepared for the worst.

A second script was created to truncate the log files on a regular basis. This ensures that the transaction log files do not grow so large to crash the entire server, or prevent any new transactions from being run.

Next time you see your Database Administrator, buy him or her a coffee and let them know that you do appreciate the unseen / unmentioned work they do.