Here are some of the development and analysis tools I use daily. I highly recommend them!
SQL Toolbelt by RedGate. This is a package of several applications that can help to streamline development, deployment, and maintenance of databases. SQL Prompt in particular provides superior Intellisense (compared to SSMS) and has very helpful script generation capabilities.
Resharper by JetBrains. In my .NET development assignments, I’ve found this to be indispensable over the years. Everything from the excellent refactoring to the syntax highlighting and the helpful suggestions for optimizations… it has saved me a lot of time and even helped me to learn LINQ.