Coming from pretty heavy background in MSSQL internals, this article is really great.
I keep telling myself that I need to invest time into learning PostreSQL as a (far less expensive) alternative to MSSQL for some use cases.
I keep telling myself that I need to invest time into learning PostreSQL as a (far less expensive) alternative to MSSQL for some use cases.
Do you know of any good resources for the undocumented function fn_dblog? I'm looking to understand the structure of RowLog Contents and Log Record in different Operations/Contexts to reconstruct DDL/DML.
http://www.sqlskills.com/blogs/paul/inside-the-storage-engin... is a good example but is really just an introduction.