SQL Server’s “index usage stats” dynamic management view is incredibly useful-- but does it tell you what you THINK it tells you? Kendra explains the quirks of how sys.dm_db_index_usage_stats works, as well as why she thinks the information is so valuable.

You’re setting up SQL Server log shipping for disaster recovery. What else do you need to do to best prepare for a failure?

You believe that your expensive SAN is slowing down the SQL Server. How can you make your case without making enemies?

What do you do when your fellow DBA is a ticking time-bomb of bad decisions, waiting to explode your production environment?

The SQL Server is slow, what should you do? Kendra shares her strategy for performance troubleshooting.