Monday, October 10, 2011

SQL Server Tools

SQL Server 2008 R2 comes with set of command line tools.  They are handy tools which can be used in any scripting, batch program.

Category Utility
SSIS dtexec Utility (SSIS Tool)
  dtutil Utility (SSIS Tool)
SSAS Deployment Utility (Analysis Services - Multidimensional Data)
SSRS rs Utility
  rsconfig Utility
  rskeymgmt Utility
Data Tools tablediff Utility
  bcp Utility
TSQL sqlcmd Utility
  osql Utility (Deprecated)
Profiler Profiler Utility
Diagnostic SQLdiag Utility
Backup sqllogship Application
maintenance plan sqlmaint Utility
Power Shell sqlps Utility
DB Engine sqlservr Application
SSMS Ssms Utility
DB Tuning dta Utility
SQL Agent sqlagent90 Application

The blue highlight are frequently used commands.

For details on each command check out MSDN http://msdn.microsoft.com/en-us/library/ms162843.aspx

Microsoft copilot Agent

 In Copilot Chat https://m365.cloud.microsoft/chat Click on All Agents on side bar Copilot Studio Provide the details and you are agent is r...