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
October
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: Category: technology
Jul 7, 2016

You're a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to level up your DBA career?

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.

May 25, 2016

Kendra Little answers a question about early adoption of SQL Server, discusses why testing in production isn't necessarily crazy, and recommends how to handle requests to upgrade your SQL Server to use new features.

« Previous 1 2 3