I have developed a stored procedure based maintenance solution that has become widely used in the SQL Server community (
http://ola.hallengren.com). In this session I will go through how the solution works, how it can be used in different scenarios for backup, integrity check, and index and statistics maintenance in an enterprise environment, and how it fits into the new world of AlwaysOn, Hekaton, Azure, and SQL Server 2014.