Blog Post

Transaction Log Internals - My session ingredients

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.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating