Now that Windows 8 (which btw ROCKS!) and Windows 2012 is out, Microsoft has released a KB highlighting the support for SQL Server in respect to these operating systems.
In KB2681562, lists the support requirements, issues with install, etc. So a one-stop-shop or so… 🙂