SQL Server 2005 DBA Street Smarts
A Real World Guide to SQL Server 2005 Certification Skills
Published on 7. November 2006
Book
Paperback/Softback
334 pages
978-0-470-08349-9 (ISBN)
Description
Develop the skill you need in the real world.
Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including:
* Installing and configuring SQL Server
* High availability and disaster recovery
* Maintenance and automation
* Monitoring and troubleshooting
An Invaluable study tool
This no-nonsense book also maps to the common tasks and objectives for Microsoft's MCTS SQL Server (TM) 2005 Implementation and Maintenance exam (70-431). So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, including:
* Upgrading from a previous version of SQL Server
* Configuring an operating mode
* Restoring a database
* Creating a Transact-SQL user-defined type
* Using Windows(r) System Monitor to Monitor performance
THE STREET SMARTS SERIES is designed to help current or sparing IT professionals put their certification to work for them. Full of practical, real world scenarios, each book features actual tasks from the field and then offers step-by-step exercises that teach the skills necessary to complete those tasks. And because the exercises are based upon exam objectives from leading technology certifications, each Street Smarts book can be used as a lab manual for certification prep.
Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including:
* Installing and configuring SQL Server
* High availability and disaster recovery
* Maintenance and automation
* Monitoring and troubleshooting
An Invaluable study tool
This no-nonsense book also maps to the common tasks and objectives for Microsoft's MCTS SQL Server (TM) 2005 Implementation and Maintenance exam (70-431). So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, including:
* Upgrading from a previous version of SQL Server
* Configuring an operating mode
* Restoring a database
* Creating a Transact-SQL user-defined type
* Using Windows(r) System Monitor to Monitor performance
THE STREET SMARTS SERIES is designed to help current or sparing IT professionals put their certification to work for them. Full of practical, real world scenarios, each book features actual tasks from the field and then offers step-by-step exercises that teach the skills necessary to complete those tasks. And because the exercises are based upon exam objectives from leading technology certifications, each Street Smarts book can be used as a lab manual for certification prep.
More details
Edition
1. Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
College/higher education
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.3 cm
Width: 18.7 cm
Thickness: 2 cm
Weight
517 gr
ISBN-13
978-0-470-08349-9 (9780470083499)
Schweitzer Classification
Person
Joseph L. Jorden (MCP, MCSE, MCTS) is the Lead Developer for Jelly Belly Candy Company where he spends a great deal of his time developing database applications and assisting the DBA with SQL Server administration tasks. Joseph was one of the first 100 people to achieve the MCSE+I certification from Microsoft, one of the first 2,000 people to earn the MCSE certification on Windows 2000 and he is a charter member of the MCTS certification program. Joseph also spent a few years as an MCT during which time he taught Microsoft Official Curriculum courses about SQL Server 6.5, 7.0, and 2000. He has spoken at PASS conferences and Comdex about SQL Server and other computing subjects. Joseph has also written a number of articles for various publications, and he has written and tech edited several books for Sybex, most of them on the subject of SQL Server.
Content
Introduction.
Phase 1 Installing and Configuring Microsoft SQL Server 2005.
Task 1.1: Verifying Prerequisites and Installing the Default Instance.
Task 1.2: Installing a Second Instance.
Task 1.3: Designing and Creating a Database.
Task 1.4: Designing and Creating a Table.
Task 1.5: Designing and Creating a Constraint.
Task 1.6: Designing and Creating a View.
Task 1.7: Designing and Creating a Stored Procedure.
Task 1.8: Designing and Creating an INSERT Trigger.
Task 1.9: Designing and Creating a DELETE Trigger.
Task 1.10: Designing and Creating an UPDATE Trigger.
Task 1.11: Designing and Creating an INSTEAD OF Trigger.
Task 1.12: Designing and Creating a User-Defined Function.
Task 1.13: Designing and Creating a Clustered Index.
Task 1.14: Designing and Creating a Nonclustered Index.
Task 1.15: Designing and Creating a Full-Text Index.
Task 1.16: Creating a Windows Login.
Task 1.17: Creating a Standard Login.
Task 1.18: Assigning Logins to Fixed Server Roles.
Task 1.19: Creating a Database User Mapping.
Task 1.20: Assigning User Mappings to Fixed Database Roles.
Task 1.21: Creating a Custom Database Role.
Task 1.22: Creating an Application Role.
Task 1.23: Assigning Permissions.
Task 1.24: Configuring Encrypted Connections.
Phase 2 Implementing High Availability and Disaster Recovery.
Task 2.1: Selecting and Setting a Recovery Model.
Task 2.2: Creating a Backup Device.
Task 2.3: Performing a Full Backup.
Task 2.4: Performing a Differential Backup.
Task 2.5: Performing a Transaction Log Backup.
Task 2.6: Performing a Filegroup Backup.
Task 2.7: Restoring a Database.
Task 2.8: Performing a Point-in-Time Restore.
Task 2.9: Implementing Database Mirroring.
Task 2.10: Implementing Log Shipping.
Task 2.11: Creating a Database Snapshot.
Task 2.12: Reverting from a Database Snapshot.
Task 2.13: Choosing a Replication Type.
Task 2.14: Designing a Replication Topology.
Task 2.15: Configuring Replication.
Task 2.16: Creating a Transactional Publication.
Task 2.17: Subscribing to a Transactional Publication.
Task 2.18: Creating a Snapshot Publication.
Task 2.19: Subscribing to a Snapshot Publication.
Task 2.20: Creating a Merge Publication.
Task 2.21: Subscribing to a Merge Publication.
Task 2.22: Resolving Merge Conflicts.
Task 2.23: Monitoring Replication.
Phase 3 Maintaining and Automating SQL Server.
Task 3.1: Configuring Database Mail.
Task 3.2: Creating an Operator.
Task 3.3: Creating a Job.
Task 3.4: Creating an Alert.
Task 3.5: Creating a Database Maintenance Plan.
Task 3.6: Using the Copy Database Wizard.
Phase 4 Monitoring and Troubleshooting SQL Server.
Task 4.1: Using Windows System Monitor.
Task 4.2: Creating an Alert in Windows System Monitor.
Task 4.3: Creating a SQL Server Performance Alert.
Task 4.4: Creating a WMI Alert.
Task 4.5: Running a Trace in Profiler.
Task 4.6: Creating a Workload in Profiler.
Task 4.7: Using the Database Engine Tuning Advisor.
Task 4.8: Identifying and Rectifying the Cause of a Block.
Task 4.9: Using the Dedicated Administrator Connection.
Index.
Phase 1 Installing and Configuring Microsoft SQL Server 2005.
Task 1.1: Verifying Prerequisites and Installing the Default Instance.
Task 1.2: Installing a Second Instance.
Task 1.3: Designing and Creating a Database.
Task 1.4: Designing and Creating a Table.
Task 1.5: Designing and Creating a Constraint.
Task 1.6: Designing and Creating a View.
Task 1.7: Designing and Creating a Stored Procedure.
Task 1.8: Designing and Creating an INSERT Trigger.
Task 1.9: Designing and Creating a DELETE Trigger.
Task 1.10: Designing and Creating an UPDATE Trigger.
Task 1.11: Designing and Creating an INSTEAD OF Trigger.
Task 1.12: Designing and Creating a User-Defined Function.
Task 1.13: Designing and Creating a Clustered Index.
Task 1.14: Designing and Creating a Nonclustered Index.
Task 1.15: Designing and Creating a Full-Text Index.
Task 1.16: Creating a Windows Login.
Task 1.17: Creating a Standard Login.
Task 1.18: Assigning Logins to Fixed Server Roles.
Task 1.19: Creating a Database User Mapping.
Task 1.20: Assigning User Mappings to Fixed Database Roles.
Task 1.21: Creating a Custom Database Role.
Task 1.22: Creating an Application Role.
Task 1.23: Assigning Permissions.
Task 1.24: Configuring Encrypted Connections.
Phase 2 Implementing High Availability and Disaster Recovery.
Task 2.1: Selecting and Setting a Recovery Model.
Task 2.2: Creating a Backup Device.
Task 2.3: Performing a Full Backup.
Task 2.4: Performing a Differential Backup.
Task 2.5: Performing a Transaction Log Backup.
Task 2.6: Performing a Filegroup Backup.
Task 2.7: Restoring a Database.
Task 2.8: Performing a Point-in-Time Restore.
Task 2.9: Implementing Database Mirroring.
Task 2.10: Implementing Log Shipping.
Task 2.11: Creating a Database Snapshot.
Task 2.12: Reverting from a Database Snapshot.
Task 2.13: Choosing a Replication Type.
Task 2.14: Designing a Replication Topology.
Task 2.15: Configuring Replication.
Task 2.16: Creating a Transactional Publication.
Task 2.17: Subscribing to a Transactional Publication.
Task 2.18: Creating a Snapshot Publication.
Task 2.19: Subscribing to a Snapshot Publication.
Task 2.20: Creating a Merge Publication.
Task 2.21: Subscribing to a Merge Publication.
Task 2.22: Resolving Merge Conflicts.
Task 2.23: Monitoring Replication.
Phase 3 Maintaining and Automating SQL Server.
Task 3.1: Configuring Database Mail.
Task 3.2: Creating an Operator.
Task 3.3: Creating a Job.
Task 3.4: Creating an Alert.
Task 3.5: Creating a Database Maintenance Plan.
Task 3.6: Using the Copy Database Wizard.
Phase 4 Monitoring and Troubleshooting SQL Server.
Task 4.1: Using Windows System Monitor.
Task 4.2: Creating an Alert in Windows System Monitor.
Task 4.3: Creating a SQL Server Performance Alert.
Task 4.4: Creating a WMI Alert.
Task 4.5: Running a Trace in Profiler.
Task 4.6: Creating a Workload in Profiler.
Task 4.7: Using the Database Engine Tuning Advisor.
Task 4.8: Identifying and Rectifying the Cause of a Block.
Task 4.9: Using the Dedicated Administrator Connection.
Index.