83
Chapter 5: SQL Server Management and Development Tools
5
You can register database engines, Analysis Services, Report Servers, SQL Server
Express, SQL Server Express LocalDB, and Integration Services servers.■ (^) Utility Explorer: Opens the Utility Explorer dashboard. Allows you to create a
Utility Control Point (UCP) and enroll instances and monitor health states of those
servers at a holistic level.
■ Template Explorer (Ctrl+Alt+T): Used to create and manage T-SQL code templates.
■ (^) Solution Explorer (Ctrl+Alt+L): Organizes projects and manages source code control.
■ Properties window (F4): Displays properties for the selected object.
■ (^) Bookmarks window (Ctrl+K, Ctrl+W): Lists current bookmarks from within the
Query Editor.
■ (^) Web Browser (Ctrl+Alt+R): Used by the Query Editor to display XML or HTML results.
■ Output window (Ctrl+Alt+O): Displays messages from Management Studio’s inte-
grated development tools.
■ Query Editor: The descendant of SQL Server 2000’s Query Analyzer, the Query Editor
is used to create, edit, and execute T-SQL batches. Query Editor may be opened from
the File ➪ New menu by opening an existing query fi le (assuming you have the .sql
fi le extension associated with Management Studio), by clicking the New Query tool-
bar button, or by launching a query script from an object in Object Explorer.
■ (^) Toolbox (Ctrl+Alt+X): Used to hold tools for some tasks.
■ Error List (Ctrl+\, Ctrl+E): Lists multiple errors.
■ (^) Task List (Ctrl+Alt+K): Tracks tasks for solutions.
The most commonly used tools — Query Editor, Object Explorer, Template Explorer, and
Properties windows — are available on the standard toolbar.
This chapter primarily discusses Management Studio because it’s used with the Relational Engine, but
Management Studio is used with the Business Intelligence (BI) tools as well. Part 9, “Business
Intelligence ,” covers the BI tools.
Window Placement
Using the Visual Studio look and feel, most windows may fl oat, be docked, be part of a
tabbed window, or be hidden off to one side. The exception is the Query Editor, which
shares the center window: the document window. Here multiple documents are presented
using tabs to select a document.
You can change any window’s mode by right-clicking the window’s title bar, and select-
ing the down arrow on the right side of a docked window or from the Window menu. In
addition, grabbing a window and moving it to the wanted location can also change the
window’s mode. Following are the available options by either dragging the tool’s window or
using the tool context menu:
■ (^) Setting the mode to fl oating instantly removes the window from Management
Studio’s window. A fl oating window behaves like a nonmodal dialog box.
c05 July 23, 2012 11:44 AM V1
c05.indd 83c05.indd 83 7/30/2012 4:14:42 PM7/30/2012 4:14:42 PM
http://www.it-ebooks.info