Paul Randal

Paul S. Randal (Paul@SQLskills.com, twitter @PaulRandal) is a world-renowned speaker, author, and instructor at SQLskills.com; he is also the CEO. He worked on the SQL Server Storage Engine team at Microsoft from 1999 to 2007, writing DBCC CHECKDB/repair for SQL Server 2005 and with responsibility for the entire Core Storage Engine during SQL Server 2008 development. Paul is an expert on disaster recovery, high availability, SQL Server internals, and database operations, and is a regular presenter at conferences worldwide. He owns and runs the company with his wife, Kimberly L. Tripp, and in their spare time they like to seek out odd-shaped bottom dwellers at remote dive sites around the world!

Interests: Doing anything with my wife, Kimberly Tripp: Sailing Scuba diving World travel Hiking Naval history Model building

All authors

Memory Corruptions, or Why You Need DBCC CHECKDB

by Paul Randal

SQLServerCentral.com

Memory Corruption

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(57)

You rated this post out of 5. Change rating

2014-10-24 (first published: 2012-11-08)

22,081 reads

Discuss

The Importance of Validating Backups

by Paul Randal

SQLServerCentral.com

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(60)

You rated this post out of 5. Change rating

2013-12-27 (first published: 2012-09-24)

11,816 reads

Discuss

My SQL Server Database is Corrupt - Now What?!

by Paul Randal

SQLServerCentral.com

Corruption

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?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(37)

You rated this post out of 5. Change rating

2013-01-29

8,757 reads

Discuss

The Perils of Running Database Repair

by Paul Randal

SQLServerCentral.com

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.