Author Archives: ConfigMgrMVP

Congratulations 2018-2019 Microsoft MVP!

Proud and honored to be awarded EMS (Enterprise Mobility + Security) MVP on Jul 1, 2018. Still humbled after 23 consecutive awards in three different technical product areas. Such a great community, congratulations to all that were awarded, and re-awarded. … Continue reading

Posted in Microsoft, MVP | Leave a comment

SCCM High Availability Role

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

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

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

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

MMS 2018 Sessions

I’m honored to be speaking at MMS, and to have some excellent co-presenters! If you are attending MMS 2018 please take a moment and check out our sessions. Sign up now, and please stop by to say hello! Configuring SQL … Continue reading

Posted in MMS, MMS 2018 | Leave a comment

How to apply a SQL Server update for ConfigMgr

This example is used to illustrate applying the latest SQL Cumulative Update to SQL 2016, this CM Site server happens to be running current branch 1710. This same process would be used to update SQL Server with a service pack … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2016 | Leave a comment