Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jan 28, 2005

SQL Server 2005 - Interface Overview - Page 2

By Steven Warren

DTS Import/Export Wizard

This Data Transformation Services Import/Export Wizard allows you to Import, Export, and/or transforms data between many popular formats.

Click for larger image

Figure E. Data Transformation Services Import/Export Wizard

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 F.

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

MS SQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM