Author Archives: ConfigMgrMVP

SQL Server recommendations for Microsoft Endpoint Configuration Manager environment Whitepaper Review

The team at Microsoft has done a great job in outlining many of the important SQL Server settings for MEMCM. If you have not read it, I recommend downloading, reading and implementing these settings. Update [6-2020]: Here is the latest … Continue reading

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

What’s new in SQL Server 2019

Now generally available, here’s what’s new. Each version of SQL Server tends to build and add additional capabilities onto the prior version. SQL Server 2019 is no exception this trend. Probably the most interesting enhancements are: SQL Server 2019 introduces … Continue reading

Posted in SQL Server, SQL Server 2019 | Leave a comment

The ConfigMgr Accidental DBA

Or, Be Your Own DBA! An Administrator for Microsoft System Center Configuration Manager (ConfigMgr) either becomes the lead administrator for ConfigMgr because it was planned, or unplanned. Once they assume control of ConfigMgr, in most cases, they are now the … Continue reading

Posted in DBA, SCCM, SQL Server | 2 Comments

MMS 2019–Planned Sessions

Are coming to one of the premier System Center Configuration Manager events, MMS 2019 (Midwest Management Summit)? If so, consider coming to see Benjamin Reynolds and myself for one or all of the following sessions. Stop by and say hello. … Continue reading

Posted in MMS, MMS 2019 | Leave a comment

SSRS ReportServer log file uncontrolled growth

When installing SSRS, there are two databases that get installed (default); ReportServer and ReporServerTempDB. With SSRS, whether for SCCM or reporting in general, by default the ReportServer database Recovery model is enabled as FULL. Which means that all activity in … Continue reading

Posted in SCCM, SQL Server, SSRS | Leave a comment

Microsoft MVP Anniversary – 23 years!

In cleaning out some old paperwork, I re-discovered my original MVP award letter, dated 12-13-1995. Yes, it was a real letter, mailed to me! The following year, this letter from Bill Gates was included. Some very insightful comments here… one … Continue reading

Posted in MVP | Leave a comment

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