Database development & administration

Databases are easy to create, but as you succeed, your amount of data will grow larger, and slowly your website will get slowly. At some point you will ask yourself, what happened here? Why is it so slow? After all, you didn't make any considerable changes....

Take a proper look at your databases once a month


Routine maintenance. It is easy to ignore the warning signs, the growing pains of your data as it gets bigger. You should take a look at your infrastructure regularly. It isn't hard, but you should get yourself to do the pro-active maintenance. I can take over this sometimes tedious task over from you.

  • Check database job history
  • Check backups
  • Review server logs
  • Test restore (Oops!)
  • Look at resource monitor
  • Run database built-in indexing and integrity checks

Performance monitoring. It is easy to ignore the warning signs, the growing pains of your data as it gets bigger. You should take a look at your infrastructure regularly. It isn't hard, but you should get yourself to do the pro-active maintenance. I can take over this sometimes tedious task over from you.

  • Real-time monitoring, performance monitor, analytics
  • Code review, optimize your T-SQL
  • Job & backup planning
  • Troubleshooting - it happens to all of us


Development. Someone still has to create and update your database. You can do this yourself, or I can do this for you.

  • Database architecture
  • Table planning & creation
  • Development of data layer