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…
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.
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 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 comes to…
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…
SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016
SCCM 1606 Upgrade SQL Server 2014 SQL Server 2016 - In this post we will see the steps to upgrade SQL server 2014 to SQL Server 2016. This post is related to SCCM as we will be performing an inplace…