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

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.

Links and references

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

Previous Post
Time for an Interview: What accomplishment are YOU most proud of?
Next Post
New weekly newsletter: a SQL Server quiz, poll or cartoon each week

Related Posts

No results found

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Menu