Practical Database Mirroring Walkthrough

There's an interesting step-by-step walkthrough of a failover scenario using SQL Server Database Mirroring on the Gaffer-Tape Engineering blog. It's not quite a transparent behind-the-scenes intervention-free example, but that real world aspect to the story is what makes it interesting; you can find the article here.