Category Archives: DBA

Create the Optimize Database Solution using PowerShell and dbatools

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 | 6 Comments

The ConfigMgr Accidental DBA

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