Export (0) Print
Expand All
45 out of 62 rated this helpful - Rate this topic

Features and Tools Overview (SQL Server 2008)

SQL Server contains a variety of features and tools that you can use to develop and manage your databases and solutions.

SQL Server Studios Overview

SQL Server contains "studios" to help you with development and management tasks: SQL Server Management Studio and Business Intelligence Development Studio. In Management Studio, you develop and manage SQL Server Database Engine and notification solutions, manage deployed Analysis Services solutions, manage and run Integration Services packages, and manage report servers and Reporting Services reports and report models. In BI Development Studio, you develop business intelligence solutions using Analysis Services projects to develop cubes, dimensions, and mining structures; Reporting Services projects to create reports; the Report Model project to define models for reports; and Integration Services projects to create packages.

SQL Server Profiler Reference

SQL Server Profiler is a tool that captures SQL Server events from a server. The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.

SQL Server Configuration Manager

SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers.

Database Engine Tuning Advisor Overview

SQL Server Database Engine Tuning Advisor helps you select and create an optimal set of indexes, indexed views, and partitions without requiring an expert understanding of the structure of the database or the internals of SQL Server.

Command Prompt Utilities

SQL Server provides additional tools that can be run from the command prompt.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.