Monthly Archives: May 2018

SCCM High Availability Role

Posted on May 22, 2018 by ConfigMgrMVP

At MMS2018, one of the more interesting items was the introduction of the new SCCM HA Role (hint: this is in 1805 TP). Now, it could be that I’m only slightly partial, given that it was one of sessions that … Continue reading →

Posted in High Availability, SCCM | 4 Comments

Giving Back – T-SQL Tuesday

Posted on May 8, 2018 by ConfigMgrMVP

This month’s topic is giving back to the community, or if you routinely give back, how did you get started? For background information. I’ve been fortunate in many ways to be acknowledged as an MVP, now for about 23 consecutive … Continue reading →

Posted in MVP, SQL, T-SQL Tuesday | Leave a comment

Enhancing WSUS database cleanup performance SQL script

Posted on May 1, 2018 by ConfigMgrMVP

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