Hi, I have recently just started development on the eqemu, however I have several years experience working in IT field as a dba/server admin. Couple of things I have learned over the years.
Windows Server Admins - Never use NTFS Compression on the drive that you have SQL DB on. Can be a huge performance hit.
Always review and test a sql script on a test/dev db before running it on a production db. (Always have a test/dev db even if it is running on a vm)
Backups - learn to run multiple backups of you files and db. Offline / Online - this can save your rear when having to rollback any changes implemented. Save you from a rebuild or upsetting your players if something bad happens.
SVN / CVS - Version control even on a small scale can help you keep track of which scripts / updates have been updated and installed. I use svn local and one on my servers so I can keep track and have a copy of what I have done. (do not forget to backup your svn db)
If you are using linux - learn to use crontab, you can schedule things like backups and indexes. Which can help immensely.
WinSQL is pretty awesome for quick and dirty SQL (same Company has JaySQL for jdbc access) Its free
These may have been covered already and for that I apologize if I am restating something. I am sure I have more but I just woke up and was browser the forum before my coffee was done.
common db / server mistakes.
Hybrid Mode
