Intro to Management Studio

Intro to Management Studio - Introduction to Management...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Introduction to Management Studio Mote’s Notes 2/16/2011 Getting Started Microsoft SQL Server 2008 is a commercial grade, client-server database management product. The server component (i.e., back-end or database engine) is where the actual data, indices and other objects are maintained. The server component runs 24-7. The client component is the application that allows the user to securely interact with the database via SQL commands or GUI tools. This semester we will be using a back-end server on the missql.mccombs.utexas.edu computer. Each MIS 325 student has a private storage area (i.e., database) on the server that will be used for assignments and exams. The student databases have a naming structure of mis325_msbaz789 where msbaz789 is the student's McCombs ID. The back-end server also has a public database named mis325 that will be used for sharing table data. We will use Management Studio as our client-side application for accessing the server during this second portion of the semester. [We will use ASP and PHP scripts for accessing the server during the final portion of the semester.] Management Studio is installed on all of the computers in the McCombs labs. You can download Management Studio at no cost directly from Microsoft if you want to install it on your own Windows computer. It is a fairly large application, so the download
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 6

Intro to Management Studio - Introduction to Management...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online