As promised in the session here are the scripts and links that I was using.

Video and slides available on Channel 9:

Blog: Management Point replica


SQL Scripts:

Index and Statistics Maintenance:

Pre-creating the SQL database: Download


My generel SQL recommendations:


Planning for Cloud based Distribution Points


Getting started with PowerShell: