---

Microsoft SQL Server 7.0 System Administration Training Kit

ISBN: 1572318279
EAN: 2147483647

Year: 1999
Pages: 100

Authors: Microsoft Press

BUY ON AMAZON

• Cover
• LOC Page
• Chapter 1 -- Overview of SQL Server
• Lesson 1: What Is SQL Server?
• Lesson 2: SQL Server Components
• Lesson 3: Overview of SQL Server Architecture
• Lesson 4: Overview of SQL Server Security
• Review
• Chapter 2 -- Installation
• Lesson 1: Preparing to Install SQL Server
• Lesson 2: Running SQL Server Setup and Testing the Installation
• Lesson 3: Running an Unattended Installation
• Review
• Chapter 3 -- Upgrading to SQL Server 7.0
• Lesson 1: Introduction to Upgrading SQL Server
• Lesson 2: Using the SQL Server Upgrade Wizard
• Lesson 3: After Using the SQL Server Upgrade Wizard
• Review
• Chapter 4 -- System Configuration and Architecture
• Lesson 1: Preparing to Use SQL Server
• Lesson 2: Working with SQL Server
• Lesson 3: SQL Server Databases
• Review
• Chapter 5 -- Database Files
• Lesson 1: Introduction to Databases
• Lesson 2: Creating and Dropping Databases
• Lesson 3: Managing Databases
• Lesson 4: Managing Databases on Multiple Disks
• Lesson 5: Capacity Planning
• Review
• Chapter 6 -- Transferring Data
• Lesson 1: Introduction to Transferring Data
• Lesson 2: Introduction to Data Transformation Services
• Lesson 3: Transforming Data with DTS
• Lesson 4: Linked Servers
• Review
• Chapter 7 -- Web Publishing and Full-Text Indexing
• Lesson 1: Publishing Database Data to Web Pages
• Lesson 2: Full-Text Indexing and Searching
• Review
• Chapter 8 -- Backup and Restore Overview and Strategy
• Lesson 1: Backup Overview
• Lesson 2: Backup Strategy
• Review
• Chapter 9 -- Backing Up Databases
• Lesson 1: Backup Devices
• Lesson 2: Performing Backups
• Review
• Chapter 10 -- Restoring Databases
• Lesson 1: The SQL Server Recovery and Restore Processes
• Lesson 2: The RESTORE Statement
• Lesson 3: Performing a Database Restore
• Lesson 4: Using a Standby SQL Server
• Lesson 5: Restoring System Databases
• Review
• Chapter 11 -- Logins, User Accounts, and User Roles
• Lesson 1: Adding Login Accounts
• Lesson 2: How Login Accounts Are Authenticated When Users Connect
• Lesson 3: Granting Access to Databases
• Review
• Chapter 12 -- Permissions and Security Planning
• Lesson 1: Types of Permissions
• Lesson 2: Assigning Permissions to Users and Roles
• Lesson 3: Planning Security
• Lesson 4: Managing Application Security
• Review
• Chapter 13 -- Automating Administrative Tasks
• Lesson 1: Introduction to SQL Server Automated Administration
• Lesson 2: Automating Routine Maintenance Tasks
• Lesson 3: Creating Alerts
• Lesson 4: Troubleshooting SQL Server Automated Administration
• Lesson 5: Establishing a Multiserver Environment
• Review
• Chapter 14 -- Monitoring and Maintaining SQL Server
• Lesson 1: Why Monitor SQL Server?
• Lesson 2: Tools for Monitoring SQL Server
• Lesson 3: Maintaining SQL Server
• Review
• Chapter 15 -- Introducing Replication
• Lesson 1: Introduction to Distributed Data
• Lesson 2: Introduction to SQL Server Replication
• Lesson 3: SQL Server Replication Types
• Lesson 4: Physical Replication Models
• Review
• Chapter 16 -- Planning and Setting Up Replication
• Lesson 1: Planning Replication
• Lesson 2: Preparing the Servers
• Lesson 3: Publishing
• Lesson 4: Subscribing
• Review
• Chapter 17 -- Managing Replication
• Lesson 1: Monitoring and Troubleshooting Replication
• Lesson 2: Replicating in Heterogeneous Environments
• Review
• Appendix A -- Questions and Answers
• Appendix B -- Database Schemata
• Glossary
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• About This Electronic Book