SQLBits 2014
Do's and don'ts of database corruption
In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.
Database corruption is one of the worst things you can encounter as a DBA. It can result in downtime, data loss, and unhappy users. What’s scary about corruption is that it can strike out of the blue and with no warning, and without having some way of telling if a database has become corrupt, it could be that way for months or even years before anything gets done about it.
In this session we’ll look at:
- Easy maintenance operations you should be running right now to ensure the fastest possible identification and resolution of corruption
- Best practices for handling a database that you suspect may be corrupted
- Actions that can worsen the problem
- Appropriate steps to take and options for recovery
Speakers
Gail Shaw's previous sessions
Regressions, neurons and decisions. Oh My!
Linear regression, neural networks and neural networks are three of the foundational algorithms in machine learning. In this session, we'll look at how they work and how they generate the results that they do.
All about Indexes
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at the design considerations for clustered indexes and for nonclustered indexes.
All about Indexes
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at guidelines for index creation
Do's and don'ts of database corruption
In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.
Bad Plan! Sit!
In this session we'll look at the common causes of bad execution plans and examine options for resolving the problem, short term and long term.