This video goes through SQL Server installation for Team Foundation Server 2010. I did the SQL Server install as if it were for the TFS 2010 standard install option (the one with TFS and all the SQL Server features on one server), but I’ve included enough information in the audio track that it ought to be helpful whatever SQL Server topology you want to create. I am using SQL Server 2008 R2, but it’s almost exactly the same installation as the original SQL Server 2008.
If you want text to follow along with the video or to review afterwards, this MSDN topic on installing SQL Server 2008 for TFS 2010 will get you really close. I never updated the topic for the SQL Server R2 release. I remember discussing it with the team when R2 released, but we felt it was close enough that people would manage. If people are interested in an update, it’s still an option.
I’ve been teaching myself how to do instructional screen capture videos and this is my first effort. I’m pleased with how it came out. If you like it, let me know. If you have feedback on this video or suggestions for future videos, I’d love to hear it in the comments. I think video might be helpful, especially for server installation tasks.