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)
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.