Who Truncated That Table and What Do I Do Now?

This article describes a way to identify the user who truncated the table & how you can recover the data.

Instant File Initialization

This article describes a way to speed up various file operations performed by SQL Server.

Automating Database Restores

This article describes a way to automatically restore multiple database backups from a directory.

Backups