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

preview_player
Показать описание
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.

Predictably, my version has goofy drawings.
  1. Kendra Little
  2. Write Ahead Log
  3. Junior DBA
  4. SQL Server
  5. Dear SQL DBA
  6. Kendra Little
Рекомендации по теме
Why Walmart failed 0:18:14

Why Walmart failed in Europe

Putin's Weird Walk 0:00:39

Putin's Weird Walk EXPLAINED 🤔

How Hollywood Makes 0:11:17

How Hollywood Makes Characters Walk On Walls | Movies Insider

Walk-in root cellar 0:00:51

Walk-in root cellar Fridge REVEAL!

Wal Thornhill's Electric 0:13:36

Wal Thornhill's Electric Dipole Gravity Model

Hyundai Ioniq 5 0:02:44

Hyundai Ioniq 5 Performs 360 Degree Turn and Crab Walk

Walmart Shoppers Actually 0:10:30

Walmart Shoppers Actually Left the House Like That

How does an 0:00:51

How does an Creepuscule walk

Introducing the Walmart 0:01:00

Introducing the Walmart Advanced Vehicle Experience concept truck

Gallery Walk 0:01:59

Gallery Walk

The coldest walk 0:00:58

The coldest walk in football history 🥶🇦🇷

I Pulled the 0:01:00

I Pulled the Firealarm at Walmart… #shorts

Going beyond Juergens 0:23:36

Going beyond Juergens Electric Sun Model with Wal Thornhill

Walk around with 0:00:36

Walk around with the Hyundai Santa Fe XRT Concept

Walmart FAILED in 0:00:57

Walmart FAILED in Germany because of smiling!

Is it Better 0:02:02

Is it Better to Walk or Run in the Rain?

Making The Video 0:07:50

Making The Video with EUROPE - Walk The Earth and director Patric Ullaeus

HOW MUSLIM GIRLS 0:04:06

HOW MUSLIM GIRLS SHOULD WALK & TALK WITH MEN! - Ustadh Nouman Ali Khan @bayyinah

Walmart Advanced Vehicle 0:06:03

Walmart Advanced Vehicle Experience Concept Truck

What made Walmart 0:13:41

What made Walmart the most powerful business Empire worth $559 Billion ? : Business case study

How To Walk 0:00:59

How To Walk A Jazz Bass Line (in under 60 seconds)

$649 Dyson Fan 0:05:54

$649 Dyson Fan vs. $15 Walmart Fan: The Hard Truth

How Walmart uses 0:04:04

How Walmart uses blockchain technology

The Sounds of 0:29:16

The Sounds of Year Walk and DEVICE 6

Комментарии
Автор

Hello Kendra, Your videos are very good to understand & explain fundamentals. Thanks for keeping such information.

TheSaurabhkothari
Автор

Hi Kendra, Is there a way to control the frequency of the CHECKPOINT? how frequent or what triggers an AUTOMATIC checkpoint?

mvillegascuellar
Автор

Dear Kendra,

what happens if the server goes down suddenly? memory will be erased. Will it recover from the logs when the server comes up? Could you please help me understand this topic?

praneetiriventi