Pee-Lo 2003/04
54
Conclusion: Future Improvements
Improvement at the Database Layer
Implement the usage of stored procedures; that is to create SQL
methods and have it being compiled and stored on the SQL Server
to quicker access, more secure and easier management.
Setup the SQL Server to backup the data
daily.
Monitor the traffic/access
of the database access using the
transaction log of the SQL Server.
Create a dummy administrator account with a messed-up
password
(the password which is not meant to be remembered) to confuse the
cracker/hacker.
Make shadow copies of the database
and have it set to auto failover
when the main database goes down.