What to do when a Database Delete happens in MSSQL

I recently had a situation where 3 database deletes happened with no one taking ownership of having done the deletes. Some important things that you should back up are:

  • The Master database.
  • The log folder for that instance of MSSQL. It contains some trace files (extension trc), the SQL event log files and the SQL error logs.
  • All of the windows event logs

Read more

Joins in SQL

If you ever struggle with joins in SQL this should help you:

Database Joins