If you work with SQL Server it is essential that you learn SQL.
While the majority of administrative tasks can be performed using Management Studio, and some limited queries can also be performed, you are missing out on some of the real power of the product if you don't know SQL.
The problem with learning something as powerful and complex as SQL is that it is not obvious where to start. There are some very good books available, but where do you look on the internet? This section of SQL Server Pro is intended to teach the language, starting with the basics and gradually introducing more advanced concepts.
I have structured this section into a number of tutorials, starting with a summary of the basic SQL commands, moving onto ways of selecting data, and then covering some more advanced topics. I will add more tutorials soon, describing how to insert, update and delete rows.
I highly recommend SQL CoPilotI can investigate performance issues, get a big picture of the state of my servers, find out what is causing all those deadlocks, and more.
SQL CoPilot answers all my questions, and is a FREE download.