Recover a database with a DAMAGED and/or LOST log file

In this procedure we’ll manage one of the worst situation a DBA has to manage: corrupted files…

Anayze SQL default trace to investigate instance events

Quering default trace is the best way to investigate unusual or critical events heppened in SQL…

SQL Jobs Monitoring: check last run datetime and duration

A simple query to check rapidly your job’s status and duration. Useful for fast monitoring on…

How to make your databases smaller and faster: find unused indexes

It’s a boring job but sometimes a good DBA has to do it. Applications change and you have to…

Queries to see rapidly what your SQL Server is doing NOW

1) Blocked And Blocking queries. If this query returns no rows you have no blocked queries in this…