I concur 100% with grant. You can do a ton with TSQL, use Powershell for stuff you cant do with TSQL.
Redgate tools are awesome too: The comparison utilities (schema and data compare) have helped a ton lately.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001