Table of content
|
Microsoft Press - Microsoft SQL Server 7. 0 System Administration Training Kit Authors: N Published year: 1999 Pages: 1/100 |
 |
- 1
- 2
- Cover
- 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
- 1
- 2
|
Microsoft Press - Microsoft SQL Server 7. 0 System Administration Training Kit Authors: N Published year: 1999 Pages: 1/100 |
|