Beginning Microsoft SQL server 2008 administration / Chris Leiter ... [et al.].

Format:

Book

Author/Creator:

Leiter, Chris, author.

Contributor:

Leiter, Chris, 1975-

Series:

Wrox beginning guides.

Wrox programmer to programmer

Language:

English

Subjects (All):

SQL server.

Database management.

Relational databases.

Genre:

Electronic books.

Physical Description:

1 online resource (820 p.)

Edition:

1st edition

Other Title:

Microsoft SQL server 2008 administration

Beginning Microsoft Structured Query Language server 2008 administration

Place of Publication:

Indianapolis, IN : Wiley Pub., 2009.

Language Note:

English

System Details:

text file

Summary:

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation and configuration/architecting, implementing and monitoring security controls, configuring and managing network communications, automating administration tasks, disaster prevention and recovery, performance monitoring, optimizing and ensuring high availability,

Contents:

Beginning Microsoft® SQL Server® 2008 Administration; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Introducing SQL Server 2008; A Condensed History of SQL Server; What Is SQL Server 2008?; SQL Server 2008 Editions; SQL Server 2008 Architecture; SQL Server 2008 Database Objects; SQL Server 2008 Databases; SQL Server 2008 Database Storage; SQL Server Security; Summary; Chapter 2: Installing SQL Server 2008

SQL Server Installation PlanningSQL Server Installation Center; Installation Review; Summary; Chapter 3: SQL Server 2008 Tools; SQL Server Management Studio; Log File Viewer; SQL Server Business Intelligence Development Studio; SQL Server Profiler; Database Engine Tuning Advisor; SQL Server Configuration Manager; Reporting Services Configuration Manager; Command-Line Tools; Summary; Chapter 4: SQL Server 2008 Storage Architecture; The Resource Database; SQL Server Database Physical Structure; Summary; Chapter 5: SQL Server 2008 Databases; System Databases; User Databases; Database Planning

Creating DatabasesDatabase Diagrams; Views; Synonyms; Programming Objects; Summary; Chapter 6: SQL Server 2008 Security; SQL Server Authentication Modes; Principals; Permissions; SQL Server Encryption; Best Practices; Summary; Chapter 7: Configuring SQL Server Network Communication; SQL Server 2008 Network Protocols; SQL Native Client Configuration; SQL Server Endpoints; Summary; Chapter 8: Automating Administrative Tasks; Policy-Based Management; Central Management Servers; Database Mail; Event Notifications; SQL Server Agent; Maintenance Plans; Best Practices; Summary

Chapter 9: Disaster Prevention and RecoveryChapter Preparation; Database Recovery Models; SQL Server 2008 Database Backup; SQL Server 2008 Backup Types; Backup Options; Backup Strategies; Restoring Databases; Command; Database Snapshots; Summary; Chapter 10: Monitoring SQL Server; Performance Monitoring; Tools and Techniques for Monitoring; Auditing; Tracking Changes; Data Collection; Monitoring Database Modifications; Summary; Chapter 11 Optimizing SQL Server; Hardware Optimization; Design Considerations; Query Optimization; T-SQL Optimization Tips; Resource Governor; Summary

Chapter 12: SQL Server High AvailabilityIntroduction to High Availability; Failover Clustering; Log Shipping; Database Mirroring; Summary; Chapter 13: Introduction to Replication; Replication Overview; SQL Server Replication Agents; SQL Server Replication Types; SQL Server Replication Models; Replication Tools; Summary; Chapter 14: Introduction to the Common Language Runtime; Databases and Programming; Is Transact-SQL Going Away?; .NET and the CLR; SQL Server CLR Objects; Deployment with Visual Studio; Programming Support; Security Options; Summary

Chapter 15: An Administrator's Guide to Business Intelligence

Notes:

Includes index.

ISBN:

9786612122095

9781282122093

1282122096

9780470501252

0470501251

OCLC:

428113339