YourSqlDba: There is a free maintenance tool that is described in the readme portion of this page at his adress. https://github.com/pelsql/YourSqlDba
It covers the five basic maintenance requirements : Update statistics, Index maintenance, Integrity check, database backups (full and logs) and some server log shrink.
The stength of this solution is that it is entirely based on SQL, and that database management selection is based on multiple wildcard filters. You can then filter in/ filter out wanted and unwanted database for maintenance. This automatically includes or exclude new databases.
The script that deploys it is located at: https://github.com/pelsql/YourSqlDba/blob/master/YourSQLDba_InstallOrUpdateScript.sql
This script create a small database YourSqlDba that contains all the sql code needed to run the maintenance.
The documentation is maintained up-to-date and can be found at:
Once the script is deployed, another stored procedure Install.InitialSetupOfYourSQLDba, needs to be run once to create SQL Agent jobs, and configure database mail for maintenance reporting. There is a link in the quick start page of the documentation.
Maintenance is done through a single entry point (a main stored procedure).
This solution is used by most schoolboards in Quebec to manage their SQL Servers (data sizes around 1GB to 1TB). Its received a SQL Server Magazine innovator award in SQL2008 and has considerably evolved since.
There is a lot of goodies (maintenance stored procedures) that can also help. Few examples are: doing ad-hoc backup, gain exclusive access for database maintenance, setup standbyserver. It also helps a lot in migrating SQL Server through the standby server feature, by reducing maintenance window for migration to a few minutes.