Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

LivingForSqlServer

I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer

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.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.