It's not sexy, but it sure is fun.
Santosh recently had a great post on what it's like being in test at microsoft. For those who read my posts from last year on campus and industry recruiting at microsoft, I would encourage you to also read this to get the sense of why being an SDET at Microsoft can be so rewarding.
Michael Hunter, aka the Braidy Tester, has had an excellent set of posts on my team's approach to test automation. It is essential reading, as will be his upcoming example series.