Geek Sync Webcast : Avoiding, Detecting, and Repairing SQL Server Database Corruption
About this webcast:
This presentation will discuss how to avoid, detect, and repair database corruption – the kinds of problems that can happen due to a bad shutdown due to a power outage or a bad storage drive or controller. Some of the topics we’ll cover include page verify settings, backup with checksum, the right way to shutdown your instance, how to check for corruption, and the basics of repairing corruption. Corruption doesn’t happen often, but knowing what to do (and what NOT to do) can save you a lot of time and energy if it does happen to one of your databases.
Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.
Complete SQL performance tuning and recommendations
- Easily monitor and improve the performance of SQL Server, Azure and AWS instances.
- Instantly locate real-time performance issues with Quick Findings.
- Improve performance with updated recommendations for SQL Server 2016 and 2017, Azure SQL Database, and Amazon RDS.
- Generate executable scripts to optimize performance.
- View trends from history of analysis recommendations.