MCSE Fast Track
SQL Server 7 Administration
Published on 13. May 1999
Book
Paperback/Softback
288 pages
978-0-7357-0041-3 (ISBN)
Description
The Fast Track series already covers the four core exams (everyone must take these) and two of the most popular electives, passing all of which earn the candidate MCSE status. SQL Server 7 Administration adds to the growing list of popular electives offered in Fast Track format. Each book has two parts: Part I gets you ready for the test FAST, covering just what you need to know to pass the test, assuming you have a working knowledge of the technology to begin with. Part II takes you through the test and into the real-world use of the technology, with chapters on: Fast Facts Review Section: Digest of each chapter-ending 'What's Important-to-Know' section from Part I; Hotlists of Exam-Critical Concepts; Sample Test Questions: One question per key point made in the book; Insider's Spin: What Microsoft doesn't necessarily want you to know; Did You Know?: Invaluable real-world applications for the technology covered in the exam, taken from the author's training and consulting files.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 228 mm
Width: 152 mm
Thickness: 16 mm
Weight
385 gr
ISBN-13
978-0-7357-0041-3 (9780735700413)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
Andy Ruth has been in the computer industry since the late 1970's when he joined the U.S. Navy and provided support of flight simulators. In the corporate environment, he has provided systems support for computers ranging from large mainframes to small pc networked environments. He holds the MCT and MCSE + I certifications, as well as others, and he has written a number of other books on Microsoft products. Ruth is currently a Program Manager at Microsoft Corporation working with the Windows 2000 training curriculum and is also a guest speaker at technology seminars.
Content
I. WHAT'S IMPORTANT TO KNOW ABOUT EXAM 70-028.
1. Planning.
Product Overview. Client/Server Relationship. SQL Server Components and Integration. Tools and Online Help. Communications. Roles. Databases. Objects. System Tables. SQL Application Design. Security. NT or SQL Authentication. Using NT Groups to Control Rights. Defining Server Roles. Mapping Groups. Selecting NT Accounts for SQL Services. Planning an Application's Security Strategy. Security Requirements for Linked Databases. Capacity Planning. Physical File Placement. Using Filegroups. Growth. Hardware. Communications. Data Availability Solutions. Standby Server. SQL Server Failover Support. Migration Plan. Upgrading from a Previous Version. Migrating from Other Data Sources. Replication Strategy. Replication Models. Single Publisher/Multiple Subscriber. Multiple Publisher/Single Subscriber. Multiple Publisher/Multiple Subscriber. Remote Distributor Server. Replication Types. Snapshot. Transactional. Merge. What Is Important to Know.
2. Installing and Configuring SQL Server 7.
Installing SQL Server 7. Choosing the Character Set. Choosing the Appropriate Sort Order. Choosing the Unicode Collation Sequence. Installing Network Libraries and Protocols. Installing Services. Installing and Configuring the SQL Server Client. Performing an Unattended Setup. Upgrading from SQL Server 6.x. Configuring SQL Server 7. Configuring SQL Mail. Configuring Default ANSI Settings. Installing and Configuring the Full-Text Search Service. Installing the Full-Text Search Service. Customizing Full-Text Search. Creating and Managing the Full-Text Search Indexes. Notes. What Is Important to Know.
3. Configuring and Managing Security.
An Overview of SQL Server Security. Managing SQL Server Logins. Creating SQL Server Logins. Mapping Windows NT Accounts. Adding Users to Databases. Managing Roles. Server Roles. Application Roles. Database Roles. Creating User-Defined Database Roles. Adding Users to Roles. Managing SQL Server Permissions. Assigning Object Permissions. Auditing Database Activity. SQL Server Profiler. What Is Important to Know.
4. Managing and Maintaining Data.
Creating and Managing Data. Creating Files, Logs, and Filegroups. Growing Your Database. Loading Data. The INSERT Statement. The SELECT Statement. BCP. DTS. The BULK INSERT Statement. Backups and Restorations. Planning a Backup Strategy. Full Backups. Transaction Log Backups. Differential Backups. Filegroup Backups. Backup Strategy. Managing Replication. Configuring Servers. Creating Publications. Subscriptions. Automating Administrative Tasks. Defining Jobs. Defining Alerts. Defining Operators. Remote Data Access. Linked Server Configuration. Linked Database Security. What Is Important to Know.
5. Monitoring and Optimization.
Performance Monitoring Basics. Monitoring SQL Server Performance. Using Performance Monitor. Using SQL Profiler. Using SQL Query Analyzer. Summary of Performance Monitoring Tools. Tuning and Optimizing SQL Server. Processor and Memory Settings. Setting SQL Server Configuration Settings. Tuning Windows NT Memory Settings. Improving Query Performance. Using Stored Procedures. Setting the Query Governor Cost Limit. Other Ways to Optimize Performance. Scheduling Jobs. Setting Alerts with SQL Server Agent. Hardware Upgrades. What Is Important to Know.
6. Troubleshooting.
Before You Begin. Diagnosing and Resolving Problems with Upgrading from SQL Server 6.x. Disk Space. Other Common Problems. Diagnosing Backup and Restoration Problems. Diagnosing and Resolving Replication Problems. Diagnosing and Resolving Job or Alert Failures. Diagnosing and Resolving Distributed Query Problems. Diagnosing and Resolving Client Connectivity Problems. Diagnosing and Resolving Access Problems. What Is Important to Know.
7. Objective Review Notes.
Planning. Installation and Configuration. Configuring and Managing Security. Managing and Maintaining Data. Monitoring and Optimization. Troubleshooting.
II. INSIDE EXAM 70-028.
Fast Facts Review.
What to Study. Planning. Installing and Configuring SQL Server 7. Configuring and Managing Security. Managing and Maintaining Data. Monitoring and Optimization. Troubleshooting.
8. Insider's Spin on Exam 70-028.
Get into Microsoft's Mindset. Understand the Exam's Time Frame. Get Used to Answering Questions Quickly. Taking the Test. Where the Questions Come From. Different Flavors of Questions. In the Future.
9. Hotlist of Exam-Critical Concepts.
10. Sample Test Questions.
Questions. Answers and Explanations.
11. Did You Know?
Choosing a Database Server. Evaluating SQL Server. Web Database Publishing. Multitier Client/Server Architecture. Distributed Management. On-Line Analytical Processing (OLAP). Moving Forward.
Index.
1. Planning.
Product Overview. Client/Server Relationship. SQL Server Components and Integration. Tools and Online Help. Communications. Roles. Databases. Objects. System Tables. SQL Application Design. Security. NT or SQL Authentication. Using NT Groups to Control Rights. Defining Server Roles. Mapping Groups. Selecting NT Accounts for SQL Services. Planning an Application's Security Strategy. Security Requirements for Linked Databases. Capacity Planning. Physical File Placement. Using Filegroups. Growth. Hardware. Communications. Data Availability Solutions. Standby Server. SQL Server Failover Support. Migration Plan. Upgrading from a Previous Version. Migrating from Other Data Sources. Replication Strategy. Replication Models. Single Publisher/Multiple Subscriber. Multiple Publisher/Single Subscriber. Multiple Publisher/Multiple Subscriber. Remote Distributor Server. Replication Types. Snapshot. Transactional. Merge. What Is Important to Know.
2. Installing and Configuring SQL Server 7.
Installing SQL Server 7. Choosing the Character Set. Choosing the Appropriate Sort Order. Choosing the Unicode Collation Sequence. Installing Network Libraries and Protocols. Installing Services. Installing and Configuring the SQL Server Client. Performing an Unattended Setup. Upgrading from SQL Server 6.x. Configuring SQL Server 7. Configuring SQL Mail. Configuring Default ANSI Settings. Installing and Configuring the Full-Text Search Service. Installing the Full-Text Search Service. Customizing Full-Text Search. Creating and Managing the Full-Text Search Indexes. Notes. What Is Important to Know.
3. Configuring and Managing Security.
An Overview of SQL Server Security. Managing SQL Server Logins. Creating SQL Server Logins. Mapping Windows NT Accounts. Adding Users to Databases. Managing Roles. Server Roles. Application Roles. Database Roles. Creating User-Defined Database Roles. Adding Users to Roles. Managing SQL Server Permissions. Assigning Object Permissions. Auditing Database Activity. SQL Server Profiler. What Is Important to Know.
4. Managing and Maintaining Data.
Creating and Managing Data. Creating Files, Logs, and Filegroups. Growing Your Database. Loading Data. The INSERT Statement. The SELECT Statement. BCP. DTS. The BULK INSERT Statement. Backups and Restorations. Planning a Backup Strategy. Full Backups. Transaction Log Backups. Differential Backups. Filegroup Backups. Backup Strategy. Managing Replication. Configuring Servers. Creating Publications. Subscriptions. Automating Administrative Tasks. Defining Jobs. Defining Alerts. Defining Operators. Remote Data Access. Linked Server Configuration. Linked Database Security. What Is Important to Know.
5. Monitoring and Optimization.
Performance Monitoring Basics. Monitoring SQL Server Performance. Using Performance Monitor. Using SQL Profiler. Using SQL Query Analyzer. Summary of Performance Monitoring Tools. Tuning and Optimizing SQL Server. Processor and Memory Settings. Setting SQL Server Configuration Settings. Tuning Windows NT Memory Settings. Improving Query Performance. Using Stored Procedures. Setting the Query Governor Cost Limit. Other Ways to Optimize Performance. Scheduling Jobs. Setting Alerts with SQL Server Agent. Hardware Upgrades. What Is Important to Know.
6. Troubleshooting.
Before You Begin. Diagnosing and Resolving Problems with Upgrading from SQL Server 6.x. Disk Space. Other Common Problems. Diagnosing Backup and Restoration Problems. Diagnosing and Resolving Replication Problems. Diagnosing and Resolving Job or Alert Failures. Diagnosing and Resolving Distributed Query Problems. Diagnosing and Resolving Client Connectivity Problems. Diagnosing and Resolving Access Problems. What Is Important to Know.
7. Objective Review Notes.
Planning. Installation and Configuration. Configuring and Managing Security. Managing and Maintaining Data. Monitoring and Optimization. Troubleshooting.
II. INSIDE EXAM 70-028.
Fast Facts Review.
What to Study. Planning. Installing and Configuring SQL Server 7. Configuring and Managing Security. Managing and Maintaining Data. Monitoring and Optimization. Troubleshooting.
8. Insider's Spin on Exam 70-028.
Get into Microsoft's Mindset. Understand the Exam's Time Frame. Get Used to Answering Questions Quickly. Taking the Test. Where the Questions Come From. Different Flavors of Questions. In the Future.
9. Hotlist of Exam-Critical Concepts.
10. Sample Test Questions.
Questions. Answers and Explanations.
11. Did You Know?
Choosing a Database Server. Evaluating SQL Server. Web Database Publishing. Multitier Client/Server Architecture. Distributed Management. On-Line Analytical Processing (OLAP). Moving Forward.
Index.