The presentation will cover Effective Indexing
6:15 - 6:30: Registration & Intro
6:30 - 7:15: DBCC CHECKDB
7:15 - 7:45: Break and Refreshments
7:45 - 8:30: Database Backups and Database Corruption
Sign up can be found https://www.eventbrite.co.uk/e/sql-user-group-dbcc-checkdb-database-backups-and-database-corruption-tickets-11761363555
Consistency checks are one of the most important tasks that DBAs need to perform regularly, to ensure database integrity is maintained and data services up time requirements are met. In this session we will discuss how the DBCC CHECKDB process works and techniques for managing DBCC CHECKDB executions on large highly transnational databases that require no interruption to data services availability. Through this discussion, we will cover a wide range of DBCC CHECKDB parameters and how they affect the manner in which DBCC CHECKDB command is executed. When you leave this discussion, you will have the knowledge to take these techniques directly to your own database landscape and ensure database integrity is maintained and possible internal errors are proactively resolved.
About Henry:Henry Sinclair is a SQL Server Professional currently working for one of the largest insurance companies based out of the United States. Over his many years of working with SQL Server, he’s gained an in-depth knowledge base of how SQL Server manages engine internals, to how SQL Server interacts with external resources such as Windows Server. He utilizes this information to adapt a highly tuned methodology to daily success, all the way to writing and performing detailed SQL Server presentations for sharing a wealth of information with the SQL Server Community and more.
Ensuring backups are free from corruption is a key task of the DBA so that it is possible to restore data in the event of database corruption being detected or having to restore data. In this session we will walk through a number of scenarios to show what happens if you don’t detect corruption within your backup process.