Professional SQL server 2005 administration [electronic resource] / Brian Knight ... [et al.].

Format:

Book

Contributor:

Knight, Brian, 1976-

Series:

Wrox professional guides.

Wrox professional guides

Language:

English

Subjects (All):

SQL server.

Database management.

Client/server computing.

Physical Description:

1 online resource (768 p.)

Place of Publication:

Indianapolis, IN : Wrox/Wiley TechnologyTechnology, c2007.

Language Note:

English

Summary:

SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration. Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocki

Contents:

Professional SQL Server 2005 Administration; About the Authors; Credits; Contents; Acknowledgments; Introduction; Who This Book Is For; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: SQL Server 2005 Architecture; Growing Role of a DBA; SQL Server Architecture; Editions of SQL Server; Summary; Chapter 2: SQL Server 2005 Installation Best Practices; Planning the System; Installing SQL Server; Installing Analysis Services; Installing Reporting Services; Burning in the System; Post-Install Configuration

Uninstalling SQL ServerHelp from Microsoft Product Support Services; Troubleshooting a Failed Install; Summary; Chapter 3: Upgrading SQL Server 2005 Best Practices; Why Upgrade to SQL Server 2005; Upgrading to SQL Server 2005; Pre-Upgrade Checks; SQL Server Upgrade Assistant; Backward Compatibility; SQL Server Component Considerations; Post Upgrade Checks; Poor Query Performance After Upgrade; Surface Area Configuration Tool; Update Usage Counters; Summary; Chapter 4: Managing and Troubleshooting the Database Engine; Configuration Tools; Management Studio; Trace Flags

Getting Help from SupportSummary; Chapter 5: Automating SQL Server; Automation Components; SQL Agent Security; Configuring SQL Server Agent; Database Mail; Multiserver Administration; Problem Resolution; Summary; Chapter 6: Integration Services Administration and Performance Tuning; Tour of Integration Services; Administration of the Integration Services Service; Administration of Integration Services Packages; Applying Security to Integration Services; Summary; Chapter 7: Analysis Services Administration and Performance Tuning; Tour of Analysis Services

Administering Analysis Services ServerAdministering Analysis Services Databases; Analysis Services Performance Monitoring and Tuning; Management of Analysis Services Storage; Applying Security to Analysis Services; Summary; Chapter 8: Administering the Development Features; The Service Broker; Security Considerations for the Service Broker; Administering the Service Broker; Introduction to CLR Integration; Summary; Chapter 9: Securing the Database Engine; Logins; Credentials; Users; Schemas; Permission Context; Encryption; Column-Level Permissions; Summary; Chapter 10: Change Management

Creating ProjectsDDL Triggers; SQLCMD; Creating Change Scripts; Version Tables; Summary; Chapter 11: Configuring the Server for Optimal Performance; What Every DBA Needs to Know about Performance; What the Developer DBA Needs to Know about Performance; What the Production DBA Needs to Know about Performance; Optimizing the Server; Configuring Server Hardware; CPU; Memory; I/O; Summary; Chapter 12: Optimizing SQL Server 2005; Application Optimization; The Silent Killer: I/O Problems; Table and Index Par titioning; Memory Considerations AND Enhancements; CPU Considerations; Summary

Chapter 13: Monitoring Your SQL Server

Notes:

Includes index.

ISBN:

1-280-90016-4

9786610900169

0-470-12109-2

OCLC:

476071265