4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

CAST([Transaction Log] as T.SQL)

The aim of this session is to take the audience in a quest for the original (or equivalent) T-SQL, that was in the origin of the different transactions recorded, by inspecting the transaction log records and dissecting its data. In a session that tackles several internals storage issues, needed to fulfill its objective, we will go in a travel that starts by the end of the log and will, hopefully, only end at the birth of the database.

By learning what the Transaction Log saves for each modification statement issued we, hopefully, will get a better understanding of how can we do more efficient code and measure the impact of some “innocent” operations. This knowledge may have direct applicability in day-to-day lives of DBAs by helping them to take the right decisions so that the log impact will be minimized and also by delivering another tool for the job that enables them to analyze database modifications.
Presented by Pedro Correia at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Pedro_Correia.jpg
    Pedro Correia was born in 1976 on the 265th day of that year.

    He is currently responsible for the Data Information System that supports the Portuguese e.school Program that delivered more than 1.5 million laptops to students and teachers in Portugal.

    He has been working with SQL Server for over 12 years, since the days of SQL Server 7.0, and his specialties are security and performance tuning. He is also a SQL Server trainer and teaching is one of his passions.

    2012 was a year focused on the certification of competences and skills gained over the years, namely becoming one of the few Microsoft Certified Master - SQL Server 2008 (l<100 worldwide) and also achieving the well-known Certified Ethical Hacker Certification.
    http://www.pjcorreia.net http://sql.pt
  • Video
    The video is not available to view online.