Ola Hallengren's SQL maintenance scripts

[pete]

https://ola.hallengren.com/

 

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance

 

The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016. The solution is based on stored procedures, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical environments, and it is used in many organizations around the world. The SQL Server Maintenance Solution has been voted as Best Free Tool in the 2013, 2012, 2011, and 2010 SQL Server Magazine Awards, and a top session at PASS Summit 2014. The SQL Server Maintenance Solution is free.

 

TLDR: If you're having to herd SQL Express instances due to terrible curriculum software, these may be useful. If you're using full SQL, they still might be useful as a supplement to maintenance plans.