Understanding and Handling Database Corruption
About the Presentation
This presentation was formerly titled “DBA 911 – Database Corruption.”
Database corruption is simply a fact of a DBA’s life – if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands such as DBINFO, CHECKDB and PAGE. You’ll learn how to monitor for corruption with SQL Server Agent Alerts and Jobs, and when it’s time to restore instead of repair. After attending this session, you will be able to check for issues such as page corruption or data purity problems, and take the appropriate measures to deal with them.
Session Level: Beginner
View Webinar & Download Presentation
Download contains:
- Webinar Recording – 60 Minutes
- PowerPoint Presentation
- Scripts
[iframe id=’powf_807B29F27A4EE61180E9C4346BDC4261′ src=’https://pocloudcentral.crm.powerobjects.net/powerwebform/powerwebform.aspx?t=vGKc9HDSM0KIvgkegLCU53UAcABzAGUAYQByAGMAaAA%3D&formId=powf_807B29F27A4EE61180E9C4346BDC4261&tver=2013′ frameborder=’0′ width=’100%’ height=’375′]
Presentations (Upcoming & Past)
- SQLSaturday #719 – Chicago, IL – March 17, 2018
- PASS Summit – Seattle, WA – October 31 – November 3, 2017
- SQLSaturday #604 – Madison, WI – April 8, 2017
- SQLSaturday #581 – Nashville, TN – January 14, 2017
- Webinar – November 9, 2016
- SQL PASS Detroit – September Meeting – Southfield, MI – September 15, 2016
- Webinar – June 14, 2016
- SQLSaturday #521 – Atlanta, GA – May 21, 2016
About the Author
David Maxwell
UpSearch Alum David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.
Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions. David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.
Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.
In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.
Learn more about David Maxwell at https://upsearch.com/david-maxwell/.
About UpSearch
UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.