TechNet Magazine: feature article on understanding logging and recovery

Wow – today is all about new content. As if I haven't already blogged about enough stuff to keep you reading through next week, the February issue of TechNet Magazine is now available and contains a feature article I wrote about understanding how logging and recovery work inside SQL Server.

The article covers:

  • What is logging?
  • What is recovery?
  • The transaction log (include logical and physical architecture)
  • Recovery models and how they affect the behavior of the transaction log

There's also a ten-minute screencast video where I demonstrate a runaway transaction log.

Check it out at http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx.

Daily SQL Server 2008 tips from TechNet Magazine

TechNet Magazine is publishing a series of SQL Server 2008 tips every day through January – mostly taken from upcoming Microsoft Press books on SQL Server 2008. Later this month it will include some tips from our upcoming book Microsoft SQL Server 2008 Internals. Check out the tips at http://technet.microsoft.com/en-us/magazine/dd391795.aspx.

Enjoy!

Comprehensive tempdb blog post series

Over the last few weeks Sunil Agarwal (from the SQL Storage Engine team) has posted a great series of blog articles about tempdb and the version store, over on my old stomping ground – the Storage Engine blog. The articles are well worth reading – the links are:

Enjoy!