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 SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


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

Featured Database Articles

MS SQL

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


















Thanks for your registration, follow us on our social networks to keep up-to-date