SQL Server has a rich tradition of providing the tools any data professional needs. Tools give anyone the power to develop, interact, tune, manage, and troubleshoot applications and queries with SQL Server. Tools for SQL Server encompass far more than programs or utilities. SQL Server comes built-in with a rich set of capabilities that I will discuss in this chapter as part of the topic of tools.
All tools for SQL Server have a common bond. They use or provide interfaces through the T-SQL language. Tools that are separate programs all know how to connect and execute T-SQL queries through a driver ...