Monthly Archives: May 2014

ConfigMgr 2012 Index Optimization

Posted on May 27, 2014 by ConfigMgrMVP

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

Posted on May 19, 2014 by ConfigMgrMVP

  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

Posted on May 19, 2014 by ConfigMgrMVP

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