Called in to tune an OLTP server, I ended up helping a Jr. DBA whose restore kept failing. Here is the story of that corrupted backup file.
SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup
Two DISK targets in one BACKUP command split the file, they do not copy it. Learn how a mirrored database backup takes multiple backups in a single command.
SQL SERVER – How to Stop Growing Log File Too Big
A client kept truncating the transaction log because of a growing log file. I explain why that is risky and share two better options, starting with Simple recovery.
Contained Database Users: Logins That Move With the Database
Use contained database users to move authentication with a database, inspect prerequisites, test connections, and review access ownership.
SQL SERVER – Fastest Way to Restore Database
A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.
SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup
Many developers meet a bookmark lookup or key lookup every day without knowing what to do. Here are four posts on removing the bookmark lookup from plans.
SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008
A reader’s job failed after upgrading to SQL Server 2008 because TRUNCATE_ONLY is gone. My notes on SHRINKFILE and TRUNCATE Log File, and what to watch for.