Category Archives: TechEd 2014

How to recover a ConfigMgr 2012 site using a restored db

This process makes the assumption that the ConfigMgr 2012 Sp1 (or later) SQL Server database was manually restored. There are two ways to restore a CM database; use the SQL Server Enterprise Management Studio restore database wizard or use the … Continue reading

Posted in ConfigMgr, SQL Server, TechEd 2014 | 7 Comments

PowerShell – SQL Audit Script

  As demonstrated at TechEd 2014, here is the PowerShell script. Actually there are two scripts. The first script is contained in this page, copy/paste (as Johan says ‘steal with pride’ 😉 and name the first: ‘SQLAuditv02.ps1’ The second was … Continue reading

Posted in PowerShell, SQL Server, TechEd 2014 | 20 Comments

TechEd 2014 – MVP Experts Panel

On Monday, May 10 2014, 5 MVPs presented at TechEd. I had the privilege of appearing on stage with Greg Ramsey, Jason Sandys, Johan Arwidmark and Kent Agerlund. Session bio: In this session, Configuration Manager MVPs demonstrate how to take … Continue reading

Posted in ConfigMgr, PowerShell, Server 2012, TechEd 2014 | Leave a comment