Dear SQL DBA

82 Episodes

1. Batch Mode Hacks in SQL Server

   Published: 5/11/2017
2. Should I Get Certified as a DBA?

   Published: 5/4/2017
3. How Does a DBA Build Confidence After Making Mistakes?

   Published: 4/27/2017
4. Are Bad Statistics Making My Query Slow?

   Published: 4/20/2017
5. Index Maintenance and Performance

   Published: 4/13/2017
6. Lock Timeouts & Memory

   Published: 4/6/2017
7. Why is my Transaction Log Growing in My Availability Group?

   Published: 3/30/2017
8. When SQL Server Does NOT Use Write Ahead Logging

   Published: 3/23/2017
9. Using a Tail Log Backup in a SQL Server Migration

   Published: 3/16/2017
10. Stack Dumps in SQL Server

    Published: 3/9/2017
11. WAL: The concept that makes recovery models & backups make sense

    Published: 3/2/2017
12. Will the Cloud Eat My DBA Job?

    Published: 2/23/2017
13. Confused by sp_Who2

    Published: 2/16/2017
14. Should I Learn Full-Text Indexing?

    Published: 2/9/2017
15. Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes

    Published: 2/2/2017
16. What's that Garbage in my Execution Plan?

    Published: 1/26/2017
17. Why You Should Switch in Staging Tables Instead of Renaming Them

    Published: 1/19/2017
18. Limiting Downtime for Schema Changes in SQL Server

    Published: 12/15/2016
19. Signs Your SQL Server is Running with Scissors

    Published: 12/1/2016
20. Why is My Query Faster on the Second Run?

    Published: 11/24/2016