It's said that a craftsman's work is only as good as his tools. To some degree, I agree that this principle applies to SQL Server. However, many database professionals from the old school choose not to use sophisticated tools, just as many craftsmen use tools (chisels, carving knives, and so on) to do the work that is often simplified through automation. Many would even argue that the results are different, perhaps even better, when you remove automation from the equation. Regardless of the ideals to which you subscribe, a number of tools and applications are available that you can use to create and debug queries. What tools do you need? This depends a great deal on what you need to do.
Here's a breakdown of some of the common tasks you may need to perform with SQL Server: