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.
-
2 Easy Ways to Repair SQL Server Management Studio (SSMS)
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 very rare that you see…
Read More » -
Install SQL Server 2019 for ConfigMgr – Bonus Guide
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 always prefer to install the…
Read More » -
ConfigMgr SUSDB Deletion Error – Cannot drop database SUSDB
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 ConfigMgr technical preview version got…
Read More » -
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 server 2014…
Read More » -
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 is simple, the SCCM…
Read More » -
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. Starting in SCCM 1810, many…
Read More » -
Install SQL Cumulative Update on SCCM Server
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 latest SQL cumulative update, I…
Read More » -
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 SQL server 2014…
Read More » -
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 across any issue when i did that.…
Read More » -
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 at times I need to…
Read More »
