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.
-
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…
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.…
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…
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…
Read More » -
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…
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…
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.…
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…
Read More » -
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…
Read More » -
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…
Read More »
- 1
- 2