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.

SQL Server

WmiPrvSE.exe process blocking SQL Server update

Prajwal Desai Nov 17, 2018

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…

SCCM

Perform Test Database Upgrade Before Installing SCCM

Prajwal Desai Oct 13, 2018

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…

SQL Server

How to Enable Dark Theme in SQL Server Management Studio

Prajwal Desai Jul 6, 2018

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…

SQL Server

How to find Installed SQL Server Version and Edition

Prajwal Desai Dec 17, 2017

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…

SCCM

Deploy SQL Server Management Studio using SCCM

Prajwal Desai Sep 20, 2017

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

SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit

Prajwal Desai Apr 27, 2017

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

SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016

Prajwal Desai Nov 3, 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…

SCCM

Supported SQL Server versions for SCCM Current Branch

Prajwal Desai Oct 30, 2016

In this post we will look at the supported SQL server versions for SCCM current branch. When you install SCCM, you require SQL server to host the site database. This SQL server version should be…

Older Posts