DTS Import/Export Wizard
This Data Transformation Services Import/Export Wizard
allows you to Import, Export, and/or transforms data between many popular
Database Tuning Advisor
This tool is an automated physical database design tool that
provides recommendations for indexes, views and horizontal partitioning. Figure
F. show you an example of the current interface of the Database Tuning Advisor
or DTA tool.
Figure G and Figure H. show the DTA in action.
Figure G. DTA in Action
Figure H. DTA in Action
SQL Server Management Studio
My favorite area is the SQL Server Management Studio where
all the meat of your DBA work will be done. When you first launch the studio
from the Start Menu, you are presented with a Connect to Server dialog box as
shown in Figure I.
Figure I. Connect to Server
After you connect to the server, the studio appears as shown
in Figure J. As you can see, the interface is very intuitive. You can use the
view menu to display various toolbars and functions. Figure J. displays the
Registered SQL Servers in addition to the Object Explorer that allows you
navigate throughout the database. Additionally, you have a Summary window and a
New Query toolbar to work with. I am having a really good time playing around
with this beta and I recommend that you download and evaluate today.
Figure J. Microsoft SQL Server Studio
In my next article, I will go over how to install SQL Server
2005 in a clustered environment.
See All Articles by Columnist Steven S. Warren