Dear SQL DBA

82 Episodes

1. Should I Upgrade to SQL Server 2016?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Published: 9/06/2016