SQL Server^TM 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills

by Joseph L. Jorden

• ISBN13: 9780470113745
• ISBN10: 047011374X
• Format: eBook
• Copyright: 2007-02-01
• Publisher: Sybex

Summary

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.

Table of Contents

Introduction

Installing and Configuring Microsoft SQL Server 2005

Verifying Prerequisites and Installing the Default Instance

Installing a Second Instance

Designing and Creating a Database

Designing and Creating a Table

Designing and Creating a Constraint

Designing and Creating a View

Designing and Creating a Stored Procedure

Designing and Creating an INSERT Trigger

Designing and Creating a DELETE Trigger

Designing and Creating an UPDATE Trigger

Designing and Creating an INSTEAD OF Trigger

Designing and Creating a User-Defined Function

Designing and Creating a Clustered Index

Designing and Creating a Nonclustered Index

Designing and Creating a Full-Text Index

Creating a Windows Login

Creating a Standard Login

Assigning Logins to Fixed Server Roles

Creating a Database User Mapping

Assigning User Mappings to Fixed Database Roles

Creating a Custom Database Role

Creating an Application Role

Assigning Permissions

Configuring Encrypted Connections

Implementing High Availability and Disaster Recovery

Selecting and Setting a Recovery Model

Creating a Backup Device

Performing a Full Backup

Performing a Differential Backup

Performing a Transaction Log Backup

Performing a Filegroup Backup

Restoring a Database

Performing a Point-in-Time Restore

Implementing Database Mirroring

Implementing Log Shipping

Creating a Database Snapshot

Reverting from a Database Snapshot

Choosing a Replication Type

Designing a Replication Topology

Configuring Replication

Creating a Transactional Publication

Subscribing to a Transactional Publication

Creating a Snapshot Publication

Subscribing to a Snapshot Publication

Creating a Merge Publication

Subscribing to a Merge Publication

Resolving Merge Conflicts

Monitoring Replication

Maintaining and Automating SQL Server

Configuring Database Mail

Creating an Operator

Creating a Job

Creating an Alert

Creating a Database Maintenance Plan

Using the Copy Database Wizard

Monitoring and Troubleshooting SQL Server

Using Windows System Monitor

Creating an Alert in Windows System Monitor

Creating a SQL Server Performance Alert

Creating a WMI Alert

Running a Trace in Profiler

Creating a Workload in Profiler

Using the Database Engine Tuning Advisor

Identifying and Rectifying the Cause of a Block

Using the Dedicated Administrator Connection

Index

Table of Contents provided by Publisher. All Rights Reserved.