Jan 10, 2018: A DBAs Guide to the Proper Handling of Corruption

Brandon Leach
A DBAs Guide to the Proper Handling of Corruption

Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have a profound impact on our company. In this session we will learn how to detect and respond to various types of corruption.

First we will be focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing your backups. We’ll look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances.

Then we will move onto how to respond. We’ll discuss the importance of incident management and the Disaster Recovery mindset and look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database. Additionally we will look at a few common examples of corruption and how to fix them.

Brandon is a Senior DBA and Microsoft Data Platform MVP working for SurveyMonkey. He is deeply passionate about building highly scaleable and well documented solutions.

Arnie Rowland
15 Presentation Tips in 15 Minutes

In this fast paced presentation, you will review, and perhaps gain a few new tips, that will help you anytime you are called upon to present to a group.

Arnie is a long serving Microsoft SQL Server MVP (10 years), has been a Subject Matter Expert (SME) working on SQL Server training courses since version 2000, and has been involved as a SME with the development of the SQL Server Microsoft Certification Exams. Arnie has also been a Microsoft Certified Trainer, and has served as a technical editor for several publishers, including multiple SQL Server titles in the Microsoft Official Curriculum. Arnie has served as adjunct faculty at both University and Community College. Clients include Fortune 500 and Multi-National companies, Federal and State agencies, Foreign governments, nationally recognized training facilities, and local enterprises –both public and private.

Don’t miss this meeting!

Refreshments graciously provided.

Featured Sponsor: Redgate
Visit our website for more details.

We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.