Home > 2010 Winter BTI420 > SQL Server administration toolset

SQL Server administration toolset

February 10, 2010 Leave a comment Go to comments

You will learn to use two tools for SQL Server administration. One tool is embedded in Visual Studio, while the other (Management Studio) provides full-featured DDL, DML, and administration capabilities.

This section covers the database administration tools you can use with SQL Server.

You essentially have two database administration tool choices:

  1. Visual Studio database tools
  2. SQL Server Management Studio (aka “SQL Workbench”, Start > Run > sqlwb)

There are two other choices. You can use “SQL Server Management Studio Express Edition” (Start > Run > ssmsee), or you can run a command-line tool. The two “management studio” products enable you to administer any version of SQL Server, but the full (non-express) version offers additional capabilities.

.

Getting started with the Visual Studio database tools

For best results, open your warp server-based website. On the View menu, choose Server Explorer. Your first task is to add a new connection. After you successfully finish this step, you will have an icon in the Server Explorer “Data Connections” list. Here is what Solution Explorer looks like before you add the new data connection:

Server Explorer fresh and new

Right-click Data Connections, and choose Add Connection. Complete the Add Connection dialog (as shown below).

Connection dialog

Make sure that you:

  • Enter the full host name of the database server
  • Enter your own credentials
  • Enter the database name, which is the same as your account name

Before you click OK, click the Test Connection button. If successful, you will see:

Test Connection message

The connection is created, and appears in the Data Connections list in Server Explorer:

Server Explorer showing the new connection

At this point, we suggest that you right-click the connection name, and then choose Rename to modify its name to something more meaningful to you. We suggest that you use a combination of the server name and your account name. Later, as you add more connections to different servers and/or databases, it will become important to quickly and easily identify each connection.

The next thing you can do is to click the tree/node expander (the plus + sign), to see the database objects, as shown below:

Server Explorer renamed and expanded

Please note the following:

If you try to expand the “Tables” node in your personal database, you will find that it’s empty. That’s because there are no tables in the database yet.

If you try to expand the “Database Diagrams” node in your personal database, you will be asked if you want to configure database diagramming objects. Answer “yes”.

Configure database diagramming objects

Finally, the following image shows three connections in Server Explorer, representing connections to the personal database, as well as to the two sample databases that we can use for read-only operations.

Server Explorer showing many data connections

.

Getting started with SQL Server Management Studio

This topic will be covered in a separate document titled Getting Started with Management Studio. Make sure you go through that document.

.


Advertisements
Categories: 2010 Winter BTI420
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: