Memory Corruptions, or Why You Need DBCC CHECKDB

DBCC is a mechanism that can protect you against corruptions causing substantial data loss in your database. If you use it.

The Importance of Validating Backups

You may think that if your database has backed up without errors, that it's going to restore without errors. Think again, says Paul Randal.

My SQL Server Database is Corrupt - Now What?!

How do you recover from corruption if your organization doesn't have a disaster recovery handbook? And how can you prevent the same corruption from recurring?

The Perils of Running Database Repair

In a perfect world everyone has the right backups to be able to recover within the downtime and data-loss service level agreements when accidental data loss or corruption occurs. Unfortunately we don’t live in a perfect world and so many people find that they don’t have the backups they need to recover when faced with corruption.

Wait statistics, or please tell me where it hurts

How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?

Bulk-Logged Mode

Clearing the Transaction Log

Primary Keys

Optimization

Checksums