Moving Databases using Detach-Attach rapidly using metascripts

The Detach-Attach tecnique is really powerfull and fast but if you have to move many databases with many datafiles using Management Studio could be very boring.
This is a very useful metascript to generate massivly database detach scripts, datafile move os script and re-attach script:

“Massive SQL Server Database Moving Using Detach – Attach: The Complete Procedure”

Analyze SQL Server trace to investigate events…

Log File Grow frequency, Missing Statistics, unexpected objects status… you can check and monitor many different kind of events just using simple queries…. It’s only the beginning and this is the article:  “Analyze SQL Server default trace to investigate events”