Printed 2015/12/01 03:54PM

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)

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

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-2015 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.