top of page

Helful Tools

Ola Hallengren's Maintenance Solutions

  • Database Backup

  • Database Integrity Check

  • Index Optimize

SQL Power Doc

  • Baselines - know what your SQL Server environment looked like

  • Security Audits

  • Performing over checks to find hidden problems and performance bottlenecks

  • Creating a runbook that you can give to your operations team.  Be careful with this option, you might be in the "dog house" for a long time to fix all these findings.  It's a double edged sword!

Third party tools: PDA from Solarwinds, Redgate etc...

  • Provide useful information in pretty chart and graph to Management team

  • Zoom in the current database problem, make sense if you have in-house application

Other tips

  • DBA Excel CheatSheet - create your own documentation, especially non-DBA tasks

  • On the file server, keep a separate folder for each SQL Server.  Softwares, scripts and information pertain to a specific server

  • FTP software for files transfer

© 2017 by DBADude

  • w-facebook
  • Twitter Clean
bottom of page