SQL Server v.Next (Denali) : The instance is down; what happened?

If you come across a SQL Server that is not running, it can be troublesome to determine what happened and when.  You can run through the Windows event viewer, but this can be a...