Info

Dear SQL DBA

Kendra Little of SQLWorkbooks.com answers burning questions from SQL Server Database Administrators and talks about her experiences as a DBA, consultant, and trainer.
RSS Feed
Dear SQL DBA
2018
August
July
June
May
April


2017
December
November
October
September
August
May
April
March
February
January


2016
December
November
October
September
August
July
June
May


Categories

All Episodes
Archives
Categories
Now displaying: June, 2016
Jun 30, 2016

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.

Jun 23, 2016

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

Jun 16, 2016

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

Jun 9, 2016

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

Jun 2, 2016

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

1