SQL Server 2008 Administration Instant Reference

by Lee, Michael; Mansfield, Mike

• ISBN13: 9781118257401
• ISBN10: 1118257405
• Edition: 1st
• Format: eBook
• Copyright: 2011-11-04
• Publisher: Sybex

Summary

Perfect companion to any SQL Server 2008 book, providing fast, accurate answers on the spot for millions of IT professionals

System and database administrators, IT consultants, and database application developers often need quick answers and practical solutions for SQL Server issues. This convenient guide offers you quick referencing for the product and database topics you need most.

If you're an IT administrator looking for the essentials in the day-to-day tasks of administering SQL Server 2008, you'll appreciate this book's design for providing quick and easy look up of solutions and tables, lists, and step-by-step instructions for answers on the spot. SQL Server 2008 Instant Administration Reference is a guide that you want to keep within reach.

• SQL Server is Microsoft's bestselling database manager; the 2008 version offers enhanced security and high availability, encouraging users to upgrade
• Features thumb tabs, secondary and tertiary tables of contents, and special heading treatments to provide quick and easy lookup, as well as quick-reference tables and lists to provide answers on the spot
• Covers installing, configuring, managing, and maintaining SQL Server; optimizing server performance; and troubleshooting

SQL Server 2008 Administration Instant Reference answers the questions you encounter most often in your daily work.

Author Biography

Michael Lee, MCT, MCITP, MCPD, SCJP, has been teaching SQL Server since 1995, providing training and consulting services in SQL Server and Enterprise Data Architecture to companies across the U.S. and Europe. Mike Mansfield is a Senior Technical Trainer for signal learning in Indianapolis, Indiana, and holds many 2008 products certifications. Mike began teaching at Missouri State University in 2003. Prior to 2003, he worked in production environments and as a consultant for nearly two decades. Mike has authored or designed many courses and specialized training.

Table of Contents

Part I: SQL Server Basics.

Chapter 1: Installing SQL Server 2008.

Chapter 2: Configuring SQL Server 2008.

Chapter 3: Creating Databases, Files, and Tables.

Chapter 4: Executing Basic Queries.

Part II: Data Integrity and Security.

Chapter 5: Managing Data Integrity.

Chapter 6: Managing Transactions and Locking.

Chapter 7: Managing Security.

Part III: Data Administration.

Chapter 8: Implementing Availability and Replication.

Chapter 9: Extracting, Transforming, and Loading Data.

Chapter 10: Managing Data Recovery.

Part IV: Performance and Advanced Features.

Chapter 11: Monitoring and Tuning SQL Server.

Chapter 12: Planning and Creating Indexes.

Chapter 13: Implementing Policy-Based Administration.

Chapter 14: Automating with the SQL Agent Service.