3 min read
2
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,…
Year: 2020
2 min read
2
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…
1 min read
2
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“.…