In a word, Yes (see the Tip at the top of the page).
There has been some confusion because in previous version of Team Foundation Server, you had to make a few adjustments to the cluster to get Team Foundation Server to play nice with your SQL Server cluster. In Team Foundation Server 2010, you don’t have to do any nonsense.
It just works.
