Microsoft SQL Server 7.0 System Administration Training Kit
Microsoft SQL Server 7.0 System Administration Training Kit
ISBN: 1572318279
EAN: 2147483647
EAN: 2147483647
Year: 1999
Pages: 100
Pages: 100
Authors: Microsoft Press
- 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
Microsoft SQL Server 7.0 System Administration Training Kit
ISBN: 1572318279
EAN: 2147483647
EAN: 2147483647
Year: 1999
Pages: 100
Pages: 100
Authors: Microsoft Press