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.
Presented by Ola Hallengren at SQLBits XII
Slide Deck 75 KB
Demo Code 7 KB
MP4 Video HD 545 MB