SQL server 2008 administration instant reference
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 convenie...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | Inglés |
| Published: |
Indianapolis :
Wiley Technology Pub
c2009.
|
| Edition: | 1st ed |
| Series: | Serious skills
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627561906719 |
Table of 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
