May 28, 2013 at 10:22 pm
What are client tools in SQL Server and why do we really need them.
May 29, 2013 at 3:19 am
SSMS and BOL. They provide GUI tools to connect and manage SQL Server.
Joie Andrew
"Since 1982"
May 29, 2013 at 4:31 am
SQL Server Management Studio (SSMS) is the front end for managing SQL Server. It provides two things, a graphical user interface for managing your SQL Server instances, your databases, the objects inside them, plus additional functionality around management objects such as extended events, SQL Agent (the scheduling service), and others. It also provides a mechanism to run T-SQL, the primary means of manipulating most of SQL Server. However, you don't need it. You can do almost everything you need to do through a combination of code through the SQL Server Management Objects (SMO) and T-SQL. However, it'll take quite a lot of code to do simple things you can do more easily through SSMS. In addition to that, if you're working with other services offered by SQL Server such as Analysis Services, Integration Services or Reporting SErvices, you'll need to have the Visual Studio shell. That provides you with a GUI and code to manipulate those unique services.
There are a couple of other utilities that are also part of the management of SQL Server such as SQL Server Configuration Manager which lets you manipulate the settings for the Services that compose the actual SQL Server system.
Or, are you asking about third party tools made by software vendors other than Microsoft?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 2, 2013 at 11:21 pm
Command line tools that allow you to interact with SQL Server like sqlcmd.exe and bcp.exe would qualify as clients tools, as would the PowerShell snap-ins that to allow us to manage and interact with SQL Server from a PowerShell prompt.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply