Category Archives: DBA

Create the Optimize Database Solution using PowerShell and dbatools

Posted on August 25, 2021 by ConfigMgrMVP

As a follow on to a frequently referenced, and still accurate blog post: Optimizing SCCM Databases Revisited – Let’s automate the creation of this optimization solution using PowerShell and DBATools. Let’s get building! If you have not used dbatools, read … Continue reading →

Posted in DBA, PowerShell, SQL Server | 7 Comments

The ConfigMgr Accidental DBA

Posted on May 17, 2019 by ConfigMgrMVP

Or, Be Your Own DBA! An Administrator for Microsoft System Center Configuration Manager (ConfigMgr) either becomes the lead administrator for ConfigMgr because it was planned, or unplanned. Once they assume control of ConfigMgr, in most cases, they are now the … Continue reading →

Posted in DBA, SCCM, SQL Server | 4 Comments