SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Paul Randal

SQLServerCentral.com profile

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!

   Items 1 to 4 of 4   

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?  Read more...
By Paul Randal 2013/01/29 | Source: SQLServerCentral.com | Category: corruption
Rating: |  Discuss |   Briefcase | 7,347 reads

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.  Read more...
By Paul Randal 2014/10/24 (first published: 2012/11/08) | Source: SQLServerCentral.com | Category: memory corruption
Rating: |  Discuss |   Briefcase | 16,358 reads

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.  Read more...
By Paul Randal 2013/12/27 (first published: 2012/09/24) | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 11,093 reads

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.  Read more...
By Paul Randal 2012/06/25 | Source: SQLServerCentral.com | Category: database repair
Rating: |  Discuss |   Briefcase | 4,737 reads
   Items 1 to 4 of 4