Category Archives: SQL Server

Create the Optimize Database Solution using PowerShell and dbatools

Posted on August 25, 2021 by ConfigMgrMVP

As a follow on to a frequently referenced, and still accurate blog post: Optimizing SCCM Databases Revisited – Let’s automate the creation of this optimization solution using PowerShell and DBATools. Let’s get building! If you have not used dbatools, read … Continue reading →

Posted in DBA, PowerShell, SQL Server | 7 Comments

SQL Server recommendations for Microsoft Endpoint Configuration Manager environment Whitepaper Review

Posted on June 5, 2020 by ConfigMgrMVP

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

Posted on December 23, 2019 by ConfigMgrMVP

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

Posted on May 17, 2019 by ConfigMgrMVP

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

SSRS ReportServer log file uncontrolled growth

Posted on January 22, 2019 by ConfigMgrMVP

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

SQL Server – Configure Backup on Availability Replicas

Posted on October 26, 2018 by ConfigMgrMVP

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

Posted on October 17, 2018 by ConfigMgrMVP

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

Enhancing WSUS database cleanup performance SQL script

Posted on May 1, 2018 by ConfigMgrMVP

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

Backup SQL Server to an Azure Storage Account

Posted on March 12, 2018 by ConfigMgrMVP

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

How to apply a SQL Server update for ConfigMgr

Posted on January 22, 2018 by ConfigMgrMVP

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