As mentioned by Bryan Harry in his blog post, TFS 2010 will not support SQL 2012. This means for TFS users that they will need to upgrade to TFS 2012 if they plan to install SQL server 2012. The decision has been justified in the post.
If you are looking for information about database development with SQL server, you can watch our latest webcast on our video channel.