Author Archives: ConfigMgrMVP

Properly configure SQL Server ConfigMgr database

Ideally, this will take place before you install ConfigMgr! First, estimate size(s) of the databases: SCCM SUSDB TempDB – see prior article for more detail How? Use the  SCCM DB Sizing estimator! Shown is an example of the Database sizing … Continue reading

Posted in ConfigMgr, SQL, SQL Server | 6 Comments

Supported SQL Server versions for SCCM CB upgrades

Had a question recently on what version of SQL Server is supported for upgrade to SCCM CB (current branch). Scenario was this; client was running SQL 2012 SP2 for their SCCM 2012 R2. However, in order to upgrade to SCCM  … Continue reading

Posted in ConfigMgr, SQL Server | 4 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 | 3 Comments

SQL Backup to URL (Azure Storage account)

How to backup up a copy of an on premise database, or Azure SQL Server database to an Azure Storage account. Notes: Any names that need to be added at time of creation are indicated with <>, such as <sqlstorageaccountname> … Continue reading

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

Azure SQL Migration Tools

In preparing a presentation for data migration to Azure, thought I’d share some of my research. There are other methods not specified here, but this should be a good start! Each toolset includes notes about that tool, and where to … Continue reading

Posted in Azure SQL Server, Migration, SQL Server | Tagged , | Leave a comment

SCCM File Backup Considerations

Everyone (hopefully) is aware that the SCCM database needs to be backed up. And, that there a number of other components that need to be backed up in order to have everything on hand in case there is a need … Continue reading

Posted in ConfigMgr, SCCM, SQL Server | 1 Comment

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