SCCM SQL Server Upgrade from 2014 to 2017
This post covers the steps to upgrade your SQL server installed for SCCM. I will show you how to upgrade the SQL server 2014 to 2017 on the SCCM server. This will be an in-place upgrade of SQL…
Browsing Category
SQL Server
Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.
Move SCCM Database to Another Drive
In this post I will cover the procedure to move the SCCM database to another drive. I will be moving the Configuration Manager database from C:\ drive to another drive on same server. My lab setup…
Site Database has a backlog of SQL Change Tracking Data
This post should help you to fix the warning "The site database has a backlog of SQL change tracking data". I am going to cover about SQL Server change tracking cleanup introduced in SCCM 1810.…
Installing SQL Cumulative Update on SCCM Server
When I powered on my SCCM lab, I noticed the SQL server wasn't installed with latest cumulative update. Checking for the latest SQL cumulative update, I found that a new cumulative update was…
WmiPrvSE.exe process blocking SQL Server update
I was planning to install the latest current branch update for my SCCM lab. I thought it might be a good idea to keep the SQL server updated with latest cumulative update. The SQL server installed was…
Perform Test Database Upgrade Before Installing SCCM
This post shows you how to perform test database upgrade before installing SCCM. Most of the time we skip doing test database upgrade and install the SCCM in-console update directly. I haven't come…
How to Enable Dark Theme in SQL Server Management Studio
This post shows the steps to enable dark theme in SQL server management studio. While i don't work much on SQL servers, my usual day involves working more on Configuration Manager. But you know what…
How to find Installed SQL Server Version and Edition
This post describes possible ways to find or identify installed SQL server version and edition. Assume that you are a DBA and you have been given a task to plan for SQL upgrade. The first thought that…
Deploy SQL Server Management Studio using SCCM
In this post we will look at the steps to deploy SQL server management studio using SCCM (SSMS). SQL server management studio provides tools to configure, monitor, and administer instances of SQL. If…
SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit
This post contains the SCCM SQL query for Microsoft office 32 bit and 64 bit. Many organizations today use Microsoft office to simply the work. Listing out office versions installed on all machines is…