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/
I don’t see the option to download the slides on the Channel 9 site.
Hello, Is the SQL pre-create script still a good thing in SQL 2017 and ConfigMgr CB?
/Thanks