Second, use the SQL Server Always On recovery solution, if possible. This solution maintains not only the SQL databases but also the entire instance. Third, use disk mirroring with hardware or ...

There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...