A complete procedure to accomplish this task using Extended Events (starting from SQL Server 2008)
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”
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”
Introducing a new area for MySQL useful queries. We’ll start with common queries every DBA must keep in his toolbox query list. This is the article: “Queries to see rapidly what your MySQL is doing NOW”
It’s time to make some tuning in your SQL Server instance (you know it is!). Let’s start finding unused indexes and creating a report for your lazy developers… :). This is the article: “How to make your old and big databases faster: find unused indexes”
Some usefull and fast query published here
Published the first tool under the tool menu: a complete procedure to migrate big instances with many databases, using only metascripts. Enjoy.
“Massive Database Migration between SQL Server instances: the complete procedure”
Pubblished a new tool to allow file system monitoring for security and troubleshoting.
FREE download of software and complete sources available under Software category
A simple but useful tool posted under Software main menu.