Ajay Dwivedi's SQL Server Blog

Setup/Configure Blocking Mail Notification Alet for SQL Server on-prem & cloud including Azure, AWS, etc.

What are the tips and tricks of resume writing and interviewing.

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 cause 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