Ajay Dwivedi's SQL Server Blog

Build a Morning Routine by following my morning routine tips.

Build desktop for running SQL Server Lab setup.

Losing single_user database connection is painful, and this script helps to regain the database access by getting database back to multi_user mode.

Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor

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