Find blocking by T-SQL Queries

Blocking is an unavoidable and by-design characteristic of any relational database management system (RDBMS) with lock-based concurrency. As mentioned previously, in SQL Server, blocking occurs when one session holds a…

Read Full

Find who dropped Database at what time

Find who dropped Database at what time As a DBA often we face a scenario that someone has dropped the database and we need to find out who dropped it.…

Read Full

Provide a SQL Login ALTER TRACE permission

Provide a SQL Login ALTER TRACE permission One SQL login holder asked DBA team "Please provide me profiler access urgently". Mentioned user using a SQL login and he wants to…

Read Full