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

Video and slides available on Channel 9: http://channel9.msdn.com/Events/TechEd/NewZealand/2013/WCL307

Blog: Management Point replica

https://blog.ctglobalservices.com/kea/working-with-database-replicas-on-your-management-point/

http://myitforum.com/myitforumwp/2012/08/06/next-sccm-guru-webcast-features-brian-mason/

 

SQL Scripts:

Index and Statistics Maintenance: http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Pre-creating the SQL database: Download

 

My generel SQL recommendations: https://blog.ctglobalservices.com/kea/system-center-2012-configuration-manager-sql-recommendations/

 

Planning for Cloud based Distribution Points

http://technet.microsoft.com/en-us/library/jj613909.aspx

 

Getting started with PowerShell: https://blog.ctglobalservices.com/kea/coretech-wmi-powershell-explorer-part-ii/