Dear SQL DBA

82 Épisodes

1. Batch Mode Hacks in SQL Server

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

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

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

   Publié: 20/04/2017
5. Index Maintenance and Performance

   Publié: 13/04/2017
6. Lock Timeouts & Memory

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

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

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

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

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

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

    Publié: 23/02/2017
13. Confused by sp_Who2

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

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

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

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

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

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

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

    Publié: 24/11/2016