As a Database Administrator, there are certain tasks that you must complete at a fairly regular frequency. Jason Strate has put together a list of 10 things he says a Database Administrator should do each month.
Are you doing what you must to ensure that your SQL Server environment is behaving as you, or your manager, expects that it is? Whether you are veteran, involuntary, or junior DBA, there are common things that we are required to do for our SQL Servers on a regular basis. These tasks may seem like they are relatively low level items, but they are in fact critical in maintaining the health and security of our SQL Server instances.
- Update Windows Server
- Update SQL Server
- Validate Backups
- Validate Recovery Strategy
- Verify SQL Server and Windows Configuration
- Check server performance and health
- Check database performance and health
- Review and adjust baselines
- Validate capacity plan
- Submit status report
Take a look at the article for full details and see if you have any recommendations for additional items.