Dear SQL DBA

82 Episodes

1. Should I Upgrade to SQL Server 2016?

   Published: 11/17/2016
2. What's Adaptive Query Processing?

   Published: 11/3/2016
3. Where Do You Get Your Creativity? (Dear SQL DBA Episode 20)

   Published: 10/20/2016
4. Should You Rebuild or Reorganize Large Indexes?

   Published: 10/13/2016
5. Can I Use Statistics to Design Indexes?

   Published: 10/6/2016
6. Setting up Free Blocking Alerts and Deadlock Monitoring

   Published: 9/29/2016
7. Which is Worse: an Unused Index, or an Un-Indexed Foreign Key?

   Published: 9/22/2016
8. Finding Your Voice as a Speaker

   Published: 9/1/2016
9. Collect and Baseline Wait Statistics

   Published: 8/25/2016
10. Developer Seeks DBA Career

    Published: 8/18/2016
11. Teach Yourself SQL Server Performance Tuning

    Published: 8/11/2016
12. Altering an INT Column to a BIGINT

    Published: 8/4/2016
13. Should I Automate Windows Updates for SQL Server?

    Published: 7/28/2016
14. Why Upgrades can Cause Performance Regression

    Published: 7/21/2016
15. Max Degree of Confusion

    Published: 7/14/2016
16. How to Level Up Your DBA Career

    Published: 7/7/2016
17. Index Usage Stats Insanity

    Published: 6/30/2016
18. Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery

    Published: 6/23/2016
19. Outside the Big SAN Box

    Published: 6/16/2016
20. Next Door to Derpton

    Published: 6/9/2016