Robert L. Davis is a program manager for Microsoft’s SQL Server Master Certification program and was previously a senior production DBA at Microsoft. He's a SQL Server 2008 Certified Master and coauthor of Pro SQL Server 2008 Mirroring (Apress).
If you’re currently using log shipping for disaster recovery, consider using asynchronous mirroring instead. Asynchronous mirroring offers enhanced manageability and more features, making it an attractive option.
The author tests four tools for comparing database schemas: Red Gate Software’s SQL Compare 9.0, ApexSQL’s ApexSQL Diff, xSQL Software’s xSQL Object, and Microsoft Visual Studio 2010 Ultimate’s Schema Compare tool.
Although log shipping isn’t as widely used as it once was, it’s still a vital tool that has many applications. Here are three techniques that can save you time and make working with log shipping painless.
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More