WAL: The concept that makes recovery models & backups make sense (Dear SQL DBA Episode 32) скачать в хорошем качестве

WAL: The concept that makes recovery models & backups make sense (Dear SQL DBA Episode 32)

Note: I do some storytelling at the beginning of this episode. The tech content starts 8 minutes in if you'd like to skip straight to that part. When you're a Junior DBA, it's really hard to take in all the information out there. Learn about write ahead logging: the concept that can help you make sense of recovery models and backup strategies in SQL Server. This is a foundational concept that can help you understand how SQL Server works, and how to take care of a SQL Server instance. In this week's episode, I tell the story of the "Wow!" moment when I learned about write ahead logging from Kimberly Tripp of SQLSkills.com way back when I was a Junior DBA. I give my own take on how write ahead logging works in SQL Server. Predictably, my version has goofy drawings.