For a taste of the future check out SQL Server 2017's index tuning recommendations and the Azure hosted version of SQL Server 2017 that can proactively implement these tuning recommendations on your behalf.
Automatic tuning https://docs.microsoft.com/en-us/sql/relational-databases/automatic-tuning/a...
Malcolm