Ajay Dwivedi's SQL Server Blog

As a SQL Server DBA, it is very important to learn concepts by doing or implementing. Following this rule, I often create a SQL Server Lab setup for

I often see various SQL Server DBA & professionals struggling with tempdb. As a DBA it is very common to see issues where some user processes causing tempdb

Why Linux? To start with, I think everyone agrees that Linux is core skills, and no doubt every IT professional should be familiar with it. Almost all enterprise

Are you tired of not knowing what is usual workload of your server? Do you want to know what is speed of your server? If you are a

Recently I have been working on setting up baselining for my SQL Server lab environment. As part of baselining, I capture all the required Perfmon counters both at

As DBA, there are various scenarios where I display duration in results. More often, for visual effects, I like to convert the same duration into [DD hh:mm:ss] format.

As a DBA & instructor, very often I like to generate heavy workload on my SQL Server instances to re-produce scenarios like 100% CPU, zero PLE, high IO,

As a DBA, I often receive user requests to check server slowness. Quite often, slowness is directly linked with active blocking on the server. I find many scripts

In my current organization, we have lot of postgres databases running on linux. So thought to learn the same by building my own CentOS 8 vm on VirtualBox.

Yesterday I was trying to install dbatools powershell module in one virtual machine that I created for online SQL Class. Resolution:- In order to solve this issue permanently,