When SQL Server Does NOT Use Write Ahead Logging (Dear SQL DBA Episode 35)

on March 23, 2017

A few episodes ago, I talked about how learning about Write Ahead Logging was a light bulb moment for me, and helped me learn tons of concepts about backups and recovery.

This week, we talk about when SQL Server turns things upside down and doesn’t use write ahead logging: and what it has to do for recovery in these special cases.

Watch this week’s 24 minute video. Subscribe to my YouTube channel, or check out the audio podcast to listen anywhere, anytime. Links from this episode are below the video.

Download Kalen Delaney’s In-Memory OLTP Whitepaper for 2016: http://sqlblog.com/blogs/kalen_delaney/archive/2016/07/12/sql-server-2016-rtm-in-memory-oltp-whitepaper.aspx.

  • The 2016 version of Kalen’s In-Memory book with Redgate is coming soon!

Erin Stellato did a demo of performance testing if In-Memory benefits a given table in the SQLSkills Insider Newsletter #149