I’ve done a lot of physical database design, and use SSIS for ETL, and SSRS now and then. Most of my work is further up the stack though.
In terms of tools, I use Visual Studio 2013 commercially. I use Resharper - I don’t know what I did without it. I use TFS at the moment for source control, but I've used Subversion and Git quite a lot too among others. I use TFS currently for story and ticket management but have also used JIRA and Target Process. All the projects I've worked on in recent years have taken an agile approach in one form or another.
Regarding techniques, I try to apply SOLID principles and best practice, and use a TDD approach where possible.