Assignment List for CMPTR 297 (Revised 4/24/08)

Unit 1 -

Reading Assignment:

Ch. 1 (Chambers), Ch. 1 (Raftree) and Ch. 1 (Stanek)

Assignment Type: Discussion Board Date Due: April 5, 2008
Points Possible: 30 Project Duration: 1 - 2 hours

Deliverable Length: 4 - 5 paragraphs

Part 1

Sizing Up SQL Server 2000 -

 As a SQL Server 2000 consultant, you have been hired to help a client in choosing a database vendor. The project will be an Internet-based initiative. Address the following requirements of the client with the features of SQL Server 2000 that meet each need.

1. The client has a Web consulting company contracted to build an Internet site.

They plan on building the site using XML to pass data to Web pages for display.

2. The client will require high availability of their vital Web data. They want to ensure that their Web site is always available for use, even in the event of a hardware failure.

3. The client expects the user base for their Web application to start out modestly and continue to grow over the months and years ahead. They want to make sure they choose a database system that can scale with the needs of their growing business.

4. The client is running a customer management system on an existing SQL Server in house, and they want to be able to integrate that system with the new Web system.

Ideally, data in both systems could be updated at the same time, ensuring that the two are always in sync. Identify the features of SQL Server 2000 that will help the client achieve this goal.

Part 2

Anti-malware Software and Microsoft Exchange Server 2003 -

Buddy’s Machine Shop has 30 staff, each with e-mail accounts. They are currently using

POP3 mail accounts with their ISP but have been having problems. Some days, they are going over their limit on the number of messages that can be transferred. In addition, the ISP does not allow for more than 30 e-mail accounts, which will be a problem if a new staff person is added.

Buddy is concerned that if they get their own mail server, they will be vulnerable to spam and viruses. Spam filtering and antivirus scanning is currently provided by the ISP. What features of Exchange Server 2003 should put Buddy’s mind at ease?
 

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
 

Assignment Type: Lab Due Date: April 5, 2008

Points Possible: 30 Project Duration: 2 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all five projects (Activity 1-1 through Activity 1-5) from Chapter 1 in the MCSE Guide to Microsoft Exchange Server 2003 Administration, 1st Ed. Complete all three projects (Project 1-1 through Project 1-3) from Chapter 1 in the textbook for SQL Server 2000 Administration, 1st Ed. Be sure to include screenshots for each project, showing successful completion of each significant step.  Include the screenshots in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.

 

Assignment Type: Test Due Date: April 5, 2008

Points Possible: 30 Project Duration:  1 hour

Deliverable Length: N/A

Finish the CMPTR 297 Unit 1 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 1 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  Exams for a given unit will only be displayed during the week that they are applicable.  This is an open book exam.

 

Unit 2 -

Reading Assignment:

Ch. 2 (Chambers), Ch. 2 (Raftree) and Ch. 2 (Stanek)

Assignment Type: Discussion Board Date Due: April 12, 2008
Points Possible: 30 Project Duration: 3 - 4 hours

Deliverable Length: 4 - 5 paragraphs

Integrating Database and Web Services -

You are part of a team of SQL Server consultants that is meeting a potential client.  That client needs to select a database system to support a growing Web site and has some concerns that you will address in you meeting.  First of all, in an effort to penetrate other global markets, they want to support multiple languages for their Web site, but they are worried about the costs associated with such an initiative (the possibility of additional hardware to support languages other than English).  Also, with the incredible growth in user activity the company has seen over the last few months, they want to implement a database that can offer scalability (their concerns focus on both hardware and database size limitations).  Finally, since they host a commercial-grade Web site, they want to ensure that the system is always up and running, even if a hardware error occurs. Your job is to come up with a proposal discussing the features of SQL Server 2000 that will help the client achieve their goals.  In addition to the information provided in this chapter (Chapter 2, Raftree), read case studies and testimonials on the SQL Server home pages (www.microsoft.com/sql) to provide real-world examples of how SQL Server 2000 is being used by other companies to solve similar problems.
 

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
 

Assignment Type: Lab Due Date: April 12, 2008

Points Possible: 30 Project Duration: 3 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all twelve projects (Activity 2-1 through Activity 2-12) from Chapter 2 in the MCSE Guide to Microsoft Exchange Server 2003 Administration, 1st Ed. Complete all six projects (Project 2-1 through Project 2-6) from Chapter 2 in the textbook for SQL Server 2000 Administration, 1st Ed.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.
 

Assignment Type: Test Due Date: April 12, 2008

Points Possible: 30 Project Duration: 1 hour

Deliverable Length: N/A

Finish the CMPTR 297 Unit 2 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 2 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.
 

Unit 3 -

Reading Assignment:

Ch. 3 – 6 (Chambers), Ch. 3 (Raftree) and Ch. 3 (Stanek)

Assignment Type: Discussion Board Date Due: April 19, 2008
Points Possible: 30 Project Duration: 1 - 2 hours

Deliverable Length: 3 - 4 paragraphs

Evaluating Client Access Methods -

Many of the users at Magnetewan Industries are deployed to client locations for periods ranging from a week to many months.  All of these users are provided with laptops computers that include the Office 2003 suite.  What options should the administrators at Magnetewan consider implementing to allow deployed staff to access the new Exchange Server 2003 system?  What are the pros and cons of each method?

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
 

Assignment Type: Lab Due Date: April 19, 2008

Points Possible: 30 Project Duration: 2.5 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all ten projects (Activity 3-1 through Activity 3-10) from Chapter 3, all ten projects (Activity 4-1 through Activity 4-10) from Chapter 4, all eleven projects (Activity 5-1 through Activity 5-11) from Chapter 5, and all nine projects (Activity 6-1 through 6-9) from Chapter 6 in the MCSE Guide to Microsoft Exchange Server 2003 Administration, 1st Ed. Complete all five projects (Project 3-1 through Project 3-5) from Chapter 3 in the textbook for SQL Server 2000 Administration, 1st Ed.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.
 

Assignment Type: Test Due Date: April 19, 2008

Points Possible: 30 Project Duration: 1 hour

Deliverable Length: N/A

Finish the CMPTR 297 Unit 3 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 3 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.
 

Unit 4 -

Reading Assignment:

Ch. 11 (Chambers)

Assignment Type: Discussion Board Date Due: April 26, 2008
Points Possible: 30 Project Duration: 1 - 2 hours

Deliverable Length: 2 - 3 paragraphs

Preventing Exchange Server Failure -

Gigantic Life Insurance has 4,000 users and availability of Exchange is critical to productivity.  If an Exchange server is down for even half an hour, thousands of dollars in staff time are lost.  What would you suggest to prevent server failure and minimize downtime in the event of a server failure?

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
  

Assignment Type: Lab Due Date: April 26, 2008

Points Possible: 30 Project Duration: 2 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all nine projects (Activity 11-1 through Activity 11-9) from Chapter 11 in the MCSE Guide to Microsoft Exchange Server 2003 Administration, 1st Ed.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.

Assignment Type: Test Due Date: April 26, 2008

Points Possible: 30 Project Duration: 30 minutes

Deliverable Length: N/A

Finish the CMPTR 297 Unit 4 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 4 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.
 

Unit 5 -

Reading Assignment:

Ch. 7 (Raftree)

Assignment Type: Discussion Board Date Due: May 3, 2008
Points Possible: 30 Project Duration: 1 - 2 hours

Deliverable Length: 3 - 4 paragraphs

Disaster Recovery and Business Continuity with SQL Server 2000 -

Assume that your company is implementing their disaster recovery strategy and that they would like you to determine and implement a plan that would limit system downtime to under one hour.  Using your knowledge from this chapter and SQL Server Books Online, how will you deliver the desired results to your employer?

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
 

Assignment Type: Lab Due Date: May 3, 2008

Points Possible: 30 Project Duration: 30 minutes

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all four projects (Project 7-1 through Project 7-4) from Chapter 7 in the textbook for SQL Server 2000 Administration, 1st Ed.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.
 

Assignment Type: Test Due Date: May 3, 2008

Points Possible: 30 Project Duration: 30 minutes

Deliverable Length: N/A

Finish the CMPTR 297 Unit 5 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 5 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.
 

Unit 6 -

Reading Assignment:

Ch. 10 (Chambers)

Assignment Type: Discussion Board Date Due: May 10, 2008
Points Possible: 30 Project Duration: 1 - 2 hours

Deliverable Length: 2 - 3 paragraphs

Choosing Roles to Delegate -

As part of the planning process, you are meeting with your administrators to identify who should have access to each of the administrative groups within your Exchange Server 2003 organization.  Your organization consists of multiple administrative groups and you have a decentralized administrative model.  You have a requirement to be able to view each administrative group but make changes only to your own administrative group.  How would you go about setting this up and what roles would you use to implement this type of model within your e-mail organization?

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
 

Assignment Type: Lab Due Date: May 10, 2008

Points Possible: 30 Project Duration: 3 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all eight projects (Activity 10-1 through Activity 10-8) from Chapter 10 in the MCSE Guide to Microsoft Exchange Server 2003 Administration, 1st Ed.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.
 

Assignment Type: Test Due Date: May 10, 2008

Points Possible: 30 Project Duration: 30 minutes

Deliverable Length: N/A

Finish the CMPTR 297 Unit 6 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 6 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.
 

Unit 7 -

Reading Assignment:

Ch. 8 (Raftree)

Assignment Type: Discussion Board Date Due: May 17, 2008
Points Possible: 30 Project Duration: 1 - 2 hours

Deliverable Length: 3 - 4 paragraphs

Windows Authentication Mode versus Mixed Authentication Mode in SQL Server 2000 -

You have been hired as a consultant to help a company named Tweezer, Inc. evaluate their potential network environment and to recommend how best to deploy SQL Server 2000.  The company is planning to have 100 users on a Windows 2000 network and 10 users on a separate UNIX-based network.  What security would you recommend and why?  What are the advantages of the security model you selected?

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
 

Assignment Type: Group Project: Due Date: May 17, 2008

Points Possible: 10 Project Duration: 4 - 6 hours

Deliverable Length: 5 - 7 pages

Begin working on the Group Project that is due during Week 9/Unit 9.  See the full assignment description in the Unit 9 – Group Project section/forum under the Group Pages - > Group (number) -> Discussion Board.  The first draft of your Group Project is due before Sunday of this week.  Get an early start on this Group Project.  Have one member of your group post a rough draft of your Group Project in the "Digital Dropbox" for your group before midnight on Saturday.
 

Assignment Type: Lab Due Date: May 17, 2008

Points Possible: 30 Project Duration: 3 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all six projects (Project 8-1 through Project 8-6) from Chapter 8 in the textbook for SQL Server 2000 Administration, 1st Ed.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.
 

Assignment Type: Test Due Date: May 17, 2008

Points Possible: 30 Project Duration: 1 hour

Deliverable Length: N/A

Finish the CMPTR 297 Unit 7 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 7 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.
 

Unit 8 -

Reading Assignment:

Ch. 7 – 9 (Stanek)

Assignment Type: Discussion Board Date Due: May 24, 2008
Points Possible: 30 Project Duration: 2 - 3 hours

Deliverable Length: 4 - 5 paragraphs

Securely Accessing Internet Information Server (IIS) 6.0 -

You are configuring a new FTP site for Dover Leasing’s Web server.  The managers would prefer the information to be physically stored on another server.  The site will used to provide access to some of your company’s Web content to network users and an external customer.  Your managers are concerned about security because no other external clients or business partners should be allowed to access this content.  You have been asked to create a document addressing some of the issues and concerns.

1. Outline each of the steps in creating and configuring the new FTP site.

2. Security is a major issue and has been emphasized by your managers.  Include in your document the various options you will use to secure the new FTP site so that only the appropriate users have access.  Be sure to include information about Active Directory User Isolation mode.

3. Include in your document how NTFS and IIS permissions can be used together to provide the most security.

4. Your managers are also concerned with the security of IIS 6.0 and want to make sure that the latest service packs and hot fixes are always applied.  How will you track what hot fixes and patches need to be installed on your server?

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.

Assignment Type: Lab Due Date: May 24, 2008

Points Possible: 30 Project Duration: 2 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all ten projects (Project 8-1 through Project 8-10) found in the “File Exchange” area of the “Group Pages” on WAOL.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.

Assignment Type: Test Due Date: May 24, 2008

Points Possible: 30 Project Duration: 30 minutes

Deliverable Length: N/A

Finish the CMPTR 297 Unit 8 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 8 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.
 

Unit 9 -

Reading Assignment:

Ch. 13 (Chambers)

Assignment Type: Discussion Board Date Due: May 31, 2008
Points Possible: 30 Project Duration: 1 - 2 hours

Deliverable Length: 3 - 4 paragraphs

Choosing a Tool for Troubleshooting -

You are the e-mail administrator for Blather Consulting Inc. and are responsible for maintaining and troubleshooting the Exchange 2003 servers in your company.  You receive a help desk ticket identifying an issue with a client not being able to connect to an Exchange 2003 server.  You investigate the problem and connect to the user's mailbox from another workstation in your environment.  What other tools can you use to determine what the problem might be between the client and the server?

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
 

Assignment Type: Group Project: Due Date: May 31, 2008

Points Possible: 90 Project Duration: 4 - 6 hours

Deliverable Length: 5 - 7 pages

Using good APA format, complete the Group Project whose description can be found under the Unit 9 – Group Project section/forum under the Group Pages - > Group (number) -> Discussion Board. You may want to select a group leader from the members of your group.  You can view group membership using the following links on WAOL/BlackBoard Communication -> Group Pages.  I would suggest assigning a portion of the project to each member of your group. Make use of the group collaboration resources of BlackBoard. This includes a group chat room, a group discussion board, and a group-members-only virtual classroom for each group. Make use of student e-mail, if necessary. This assignment is due no later than midnight on Saturday of this week. There is a minimum length and a maximum length to this assignment.  Stay within these guidelines to avoid any unnecessary penalties and to receive full points for this assignment. Each member must also turn in a peer evaluation form before the project deadline. The blank peer evaluation form can be found on the "Professors Online" website for this class. Peer evaluation forms should be submitted via the classroom “Digital Dropbox.” When you're done with the group project, drop off one copy of the assignment in the classroom "Digital Dropbox" on behalf of your entire group before midnight on Saturday.

Your grade will be based on content, adherence to proper APA style format, and the combined scores of your peer evaluations.

Examples of acceptable APA style formatting can be found on the “Professors Online” website.  See the following link - http://faculty.olympic.edu/kblackwell/docs/APA/APAStyleGuide.htm.

Remember, no one in the group can receive a grade until all peer evaluations have been received. 50% of your grade on this assignment will be based on the average score from all peer evaluations.  The other 50% of your grade will come from a combination of the content and formatting (APA Style) of your final paper.

Assignment Type: Lab Due Date: May 31, 2008

Points Possible: 30 Project Duration: 3 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all fourteen projects (Activity 13-1 through Activity 13-14) from Chapter 13 in the MCSE Guide to Microsoft Exchange Server 2003 Administration, 1st Ed.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.


Assignment Type: Test Due Date: May 31, 2008

Points Possible: 30 Project Duration: 30 minutes

Deliverable Length: N/A

Finish the CMPTR 297 Unit 9 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 9 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.
 

Unit 10 -

Reading Assignment:

Ch. 6 (Raftree)

Assignment Type: Discussion Board Date Due: June 7, 2008
Points Possible: 30 Project Duration: 1 - 2 hours

Deliverable Length: 2 - 4 paragraphs

Optimizing and Troubleshooting Databases -

A company has just deployed SQL Server 2000 to house data for its financial systems.  As more people within the organization use the system, the response time for operations degrades and users begin to complain that the performance is unacceptable.  Assuming that the hard drive configuration and the placement of indexes and tables across filegroups are optimized, poorly performing queries must be the culprit.  Based on the information in this chapter and the documentation contained in SQL Server Books Online, define a SQL Profiler trace that will help to identify poorly performing queries.  Discuss how to limit the amount of data captured through filters as well.

Post your answer on the Discussion Board. Be an active participant in the discussion by responding to a few posts and showing your appreciation for the contributions from your colleagues.
 

Assignment Type: Lab Due Date: June 7, 2008

Points Possible: 30 Project Duration: 1.5 hours

Deliverable Length: N/A

Using a dedicated computer or virtual machine technology, complete all four projects (Project 6-1 through Project 6-4) from Chapter 6 in the textbook for SQL Server 2000 Administration, 1st Ed.  Be sure to include screenshots for each project (where appropriate) and/or answers to the questions posed (where applicable), showing successful completion of each significant step.  Include the screenshots and answers to the questions in a Microsoft Word document.  Do not use APA format for this assignment. Create a file with your responses and drop your assignment in the digital drop box before midnight on Saturday. Be sure to follow the guidelines for naming your file as found in the course syllabus.


Assignment Type: Test Due Date: June 7, 2008

Points Possible: 30 Project Duration: 30 minutes

Deliverable Length: N/A

Finish the CMPTR 297 Unit 10 - Exam before next Sunday.  Log into http://www.evtestcenter.com/ and specify my name - kblackwell - for your "Instructor ID:"  Select "CMPTR 297 Unit 10 - Exam."  Then specify your "ID:" as your Student ID (including the hyphens, i.e. 860-11-1111) and your password is your home phone that you provided during registration time (without the area code and with the hyphen, i.e. 555-1212).  Once you've logged in you can take your exam.  The results will automatically be e-mailed to your instructor.  The exam is not timed.  This is an open book exam.