Published Books
Practical Handbook for Reporting
Recommended Content
Recommended Blogs
-
Recent Posts
- SQL Performance Tips for MEMCM – Part 2
- SQL Performance Tips for MEMCM – Part 1
- Upgrade MEMCM site Windows Server 2012 to Server 2016 – Lessons learned
- Create the Optimize Database Solution using PowerShell and dbatools
- SQL Server recommendations for Microsoft Endpoint Configuration Manager environment Whitepaper Review
Visitor Info
Archives
- March 2022
- February 2022
- August 2021
- June 2020
- December 2019
- May 2019
- March 2019
- January 2019
- December 2018
- October 2018
- August 2018
- July 2018
- May 2018
- March 2018
- January 2018
- December 2017
- September 2017
- August 2017
- June 2017
- May 2017
- March 2017
- January 2017
- December 2016
- November 2016
- October 2016
- September 2016
- August 2016
- July 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- October 2015
- September 2015
- August 2015
- July 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- July 2013
- June 2013
- May 2013
- April 2013
- February 2013
Recent Comments
Categories
- 2015 Dev Connections
- Active Directory
- Always ON
- Android
- Azure
- Azure SQL Server
- ConfigMgr
- DBA
- GPO
- High Availability
- Intune
- Microsoft
- Migration
- MMS
- MMS 2013
- MMS 2014
- MMS 2018
- MMS 2019
- MSI
- MVP
- OSD
- Power BI Report Server
- PowerBI
- PowerShell
- SCCM
- Server 2012
- Softchoice
- Software Center
- SQL
- SQL Server
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2019
- SQLTuesday
- SSRS
- System Center 2012 R2
- T-SQL Tuesday
- TechEd 2014
- UD-B407
- Uncategorized
- VBScript
- Windows 10
- Windows 8
- Windows Server 2012
- WSUS
About
Category Archives: Uncategorized
SQL Performance Tips for MEMCM – Part 2
Tips for optimizing SQL Server performance for MEMCM – Part 1 started with the Windows Server platform. This blog covers the optimizing performance for SQL Server from the focus of MEMCM. SQL Server Recommended SQL Server settings SQL Server Version … Continue reading
SQL Performance Tips for MEMCM – Part 1
Tips for optimizing SQL Server performance for MEMCM, we’ll start with the Windows Server platform. This is the first in a series of performance tips. Windows Server Since SQL Server is installed on Windows Server, and in many cases co-located … Continue reading
Upgrade MEMCM site Windows Server 2012 to Server 2016 – Lessons learned
Issue MEMCM was no longer downloading servicing updates. Service updates stuck in downloading state. Site server running on Windows Server 2012, MEMCM build was stuck at v2103.. Planning/Research Upon investigating, it seemed likely the issue was related to the Windows … Continue reading
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
31 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
6 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
Steve Thompson [MVP] 