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.
In this post I will show you 2 ways to repair SQL Server Management Studio (SSMS). You repair SSMS when you notice that SQL Server Management Studio (SSMS) has stopped working or is crashing. It’s …
This post is a step-by-step guide to install SQL Server 2019 for ConfigMgr. The SQL Server 2019 is a supported SQL server version for ConfigMgr 1910 and above. When I build my ConfigMgr lab, I …
I got an error while deleting the ConfigMgr SUSDB. The error was cannot drop database “SUSDB” because it is currently in use. I recently had to rebuild my ConfigMgr technical preview lab. That’s because the …
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 …
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 …
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. …
This post covers the steps to install SQL cumulative update on SCCM SQL server. When I powered on my SCCM lab, I noticed the SQL server wasn’t installed with latest cumulative update. Checking for the …
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 …