Author Archives: ConfigMgrMVP

SQL Server – Configure Backup on Availability Replicas

For a recent project, I needed to create a backup maintenance task for databases in a SQL Server Always On Availability group. In three separate AO environments. Now there are several options available: Use custom backup jobs Use Ola Hallengren’s … Continue reading

Posted in High Availability, SCCM, SQL Server | Leave a comment

Failed to create Availability Group Listener

In implementing a SQL Server Always On availability group; I know I’ve run into this issue in the past, so figured I’d document the solution. The Windows Server Failover cluster was properly created. The SQL Server Always On Availability Group … Continue reading

Posted in Always ON, High Availability, SQL Server | Leave a comment

Power BI Editions Explained

We’ve recently worked with a client to get clear on licensing requirements for Power BI. Learned some interesting facts about Power BI versions that are a bit unclear on the Microsoft site, and wanted to share them as this *will* … Continue reading

Posted in Power BI Report Server, PowerBI | Leave a comment

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