Dear SQL DBA

82 Episodes

1. Batch Mode Hacks in SQL Server

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

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

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

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

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

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

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

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

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

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

    Published: 02/03/2017
12. Will the Cloud Eat My DBA Job?

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

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

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

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

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

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

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

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

    Published: 24/11/2016