Category Archives: SCCM

Enhancing WSUS database cleanup performance SQL script

There have been many reports of slow and sluggish clean up and removal of expired updates. An old WSUS database can include 1000’s of updates that need to be removed. Turns out that adding two non-clustered indexes on SUSDB can … Continue reading

Posted in SCCM, SQL Server, Uncategorized, WSUS | 5 Comments

Backup SQL Server to an Azure Storage Account

One of the benefits of backing up SQL Server to Azure, is an immediate “off site” storage solution. Another, is that Azure storage account can be geo-replicated for additional backup copies. There are a few ways to make this work, … Continue reading

Posted in Azure, Azure SQL Server, SCCM, SQL Server | Leave a comment

SCCM File Backup Considerations

Everyone (hopefully) is aware that the SCCM database needs to be backed up. And, that there a number of other components that need to be backed up in order to have everything on hand in case there is a need … Continue reading

Posted in ConfigMgr, SCCM, SQL Server | 1 Comment