markwdavies

companion site to my github repo

19 September 2023 by mwd

DBA Resources

Useful resources For SQL Server DBAs

There are a few scripts to be found in my github repository. The stored procs can help locate useful information on a SQL Server Database Server.

Additionally there are numerous websites out there offering advice and scripts to the SQL Server DBA. Some that I have found to be useful are listed below :


  • Who Is Active
    • Adam Mechanic’s essential addition to sp_who2 to show the current active processes.


  • Ola Hallengren’s Maintenance solution
    • A SQL Server Maintenance Solution that is quick to get up and running !
    • I don’t know a quicker way to set up a backup solution , but be wary when enabling the indexing jobs without tweaking the parameters.


  • SQL Undercover
    • sp_RestoreScript is a very handy resource to generate DB restore commands.
    • many other scripts in a github repository - see also the blog posts.

tags: sql