-
Find blocking by T-SQL Queries
27 August 2020Blocking 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…
-
Find who dropped Database at what time
12 January 2020Find 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….
-
Provide a SQL Login ALTER TRACE permission
5 January 2020Provide 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…