Monthly Archives: May 2014

ConfigMgr 2012 Index Optimization

A recent blog post on index defragmentation and comments deserve some space here. The blog: http://blogs.technet.com/b/smartinez/archive/2014/03/28/talking-database-in-configmgr.aspx The blog does a really good job exposing how the Index optimizer decides to rebuild indexes. That is a good thing! Lets walk through … Continue reading

Posted in ConfigMgr, Microsoft, SQL Server, System Center 2012 R2 | 1 Comment

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 | 18 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