Category Archives: Uncategorized

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

Properly size SQL Server TempDB for ConfigMgr

At MMS 2017, Benjamin Reynolds and I covered properly sizing TempDB as one facet in our Optimizing and Tuning SQL Server for ConfigMgr session. Because of a few conversations that occurred that week at MMS, I think it is appropriate … Continue reading

Posted in Uncategorized | 5 Comments

Top 5 blog posts for 2016

Read another post of top 5 blog posts… thank you for viewing my work. SQL Server Backup Recommendations for Configuration Manager https://stevethompsonmvp.wordpress.com/2013/06/07/sql-server-backup-recommendations-for-configuration-manager/ Optimizing ConfigMgr databases https://stevethompsonmvp.wordpress.com/2013/05/07/optimizing-configmgr-databases/ Running Powershell as an SQL Server Agent task https://stevethompsonmvp.wordpress.com/2013/10/07/running-powershell-as-an-sql-server-agent-task/ How to recover a ConfigMgr … Continue reading

Posted in Uncategorized | Leave a comment

ConfigMgr – List all Servers with Maintenance Windows

Developed a report to show all servers that have collection maintenance windows. Very handy for cross checking servers in multiple maintenance windows, or supplying a list to support change control. Here is the query: — List Computers with Maintenance Window … Continue reading

Posted in Uncategorized | 2 Comments

Blog 2014 Year In review

Thank you for the support and comments through the year! > The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Senior Systems Engineer Needed – Dallas, TX

Microsoft Senior Systems Engineer Needed Softchoice – Dallas, TX Anyone with System Center skills in the Dallas, TX area looking for work? Softchoice has a great opportunity: https://www.linkedin.com/jobs2/view/13441840 Contact me for more information: steve (dot) thompson (at) softchoice (dot) com

Posted in Softchoice, Uncategorized | Leave a comment

What is PSR?

Not sure if I’m the only one that had not heard of this tool. PSR is the Problem Steps Recorder, included with Windows 7 & Windows 8.  This will be really useful for recording interactive sessions, particularly for documentation From … Continue reading

Posted in Uncategorized | 2 Comments