Category: SQL Agent Job

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

When I joined my current organization 2 years back, the biggest problem I faced as DBA was whenever there was Replication, log shipping, Mirroring, or AlwaysOn, the Index

In my organization, we have many SQL Agent jobs that are expected to execute within a particular time window. But there are times when some of them take

It’s very common for Database professionals to experience blocking. Even though blocking is a usual activity, it can convert into an issue anytime. And becomes pain point when

Recently as part of Server Migration, I had to move nested folders and files from Source server to Destination. This task becomes hard when directory has child folders

Being a DBA, I know the pain of a long running job creating performance issues for other jobs and user sessions. For my current organization, I have created