Profile

e-Catalog

Contact

Search

Cart

Microsoft SQL Server 7.0: Automating Administration

Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To show students how to automate the administration of SQL Server 7.0 and configure web publishing

Learning Objectives

Distinguish between the key automation components in SQL Server 7.0. Show how to create, schedule, and manage jobs. Describe how to define operators and set alerts. Identify the multiserver administration components. Point out how to create and manage multiserver jobs. Outline how to resolve some job, operator, and alert failures. Discuss the Internet access options for SQL Server 7.0. Summarize how to configure web publishing using SQL Server 7.0.

Topics Covered

Jobs - Automation - Defining jobs - Hands-on: Creating jobs Operators and alerts - Working with operators and alerts - Hands-on: Configuring operators and alerts - The multiserver environment - Hands-on: Creating a multiserver job Troubleshooting - Troubleshooting tools - Troubleshooting automation - Hands-on: Troubleshooting jobs Web publishing - Publishing data on the Web - Configuring web publishing - Hands-on: Using the Web Assistant Wizard