SQL server 2008 administration instant reference / Michael Lee, Mike Mansfield.

Format:

Book

Author/Creator:

Lee, Michael, 1966-

Contributor:

Mansfield, Mike.

Series:

Serious skills

Language:

English

Subjects (All):

SQL server.

Database management.

Relational databases.

Physical Description:

1 online resource (531 p.)

Edition:

1st ed.

Place of Publication:

Indianapolis : Wiley Technology Pub., c2009.

Language Note:

English

System Details:

text file

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

Contents:

SQL Server 2008 Administration Instant Reference; Acknowledgments; About the Authors; Contents; Introduction; Who Should Read This Book; How to Contact the Author; PART I: SQL Server Basics; Chapter 1: Installing SQL Server 2008; Prepare for Installation; Install SQL Server 2008; Chapter 2: Configuring SQL Server 2008; Configure the Server Platform; Configure SQL Server 2008; Chapter 3: Creating Databases, Files, and Tables; Perform Capacity Planning; Create and Alter Databases; Manage Database Files; Create and Alter Tables; Chapter 4: Executing Basic Queries; Use SQL Server Schemas

Select Data from a DatabaseModify Data; Use the SQL Server System Catalog; PART II: Data Integrity and Security; Chapter 5: Managing Data Integrity; Implement Entity Integrity; Implement Domain Integrity; Implement Referential Integrity; Understand Procedural Integrity; Chapter 6: Managing Transactions and Locks; Manage SQL Server Locks; Manage Transactions; Implement Distributed Transactions; Manage Special Transaction Situations; Chapter 7: Managing Security; Implement User Security; Implement Roles; Implement Permissions; Encrypt Data with Keys; PART III: Data Administration

Chapter 8: Implementing Availability and ReplicationImplement Availability Solutions; Implement Replication; Chapter 9: Extracting, Transforming, and Loading Data; Use the Bulk Copy Program Utility; Use the SQL Server Import and Export Wizard; Create Transformations Using SQL Server Integration Services (SSIS); Chapter 10: Managing Data Recovery; Understand Recovery Concepts; Perform Backup Operations; Perform Restore Operations; PART IV: Performance and Advanced Features; Chapter 11: Monitoring and Tuning SQL Server; Monitor SQL Server; Tune SQL Server

Chapter 12: Planning and Creating IndexesUnderstand Index Architecture; Create and Manage Indexes; Manage Special Index Operations; Chapter 13: Policy-Based Management; Understand Policy-Based Management; Manage Policies in the Enterprise; Chapter 14: Automating with the SQL Server Agent Service; Configure the SQL Server Agent Service; Create and Configure Automation Objects; Index

Notes:

Includes index.

ISBN:

9786612279492

9781282279490

1282279491

9781118257401

1118257405

9780470567210

047056721X

OCLC:

768230334