http://www.sqlservercentral.com/blogs/livingforsqlserver/2012/10/30/transaction-log-internals-my-session-ingredients/

Printed 2014/07/25 02:45PM

Transaction Log Internals - My session ingredients

By Ramkumar (LivingForSQLServer), 2012/10/30

Still 18 days to go for my session on Transaction Log Internals for Chennai SQL Server User Group (17-Nov).

While seeing below two worlds best presentations on this topics, I wonder what more I could add for my one hour session.

1. Paul Randals Transaction Log Internals Maintenance (MCM Readiness Videos)

http://technet.microsoft.com/en-us/sqlserver/gg313762.aspx

http://technet.microsoft.com/en-us/sqlserver/gg313763.aspx

2. Brad Mcgehee's Inside the SQL Server Transaction Log (and references)

http://bradmcgehee.com/wp-content/uploads/presentations/PASS%202011--Inside%20the%20SQL%20Server%20Transaction%20Log.pdf

Excellent presentations.

In my presentation, I would like to cover essence in 30 minutes and explore how recovery works with some transaction scenarios
(as explained by Paul Randal in MCM readiness videos).

and also I am going to try interpreting Log entry of simple INSERT/DELETE/UPDATE in fn_dblog.
I would be more happy, If I could understand atleast little bit of pattern. miles to go.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.