Cargando…
Professional Microsoft SQL server 2008 administration /
This book is a how-to guide for experienced DBAs. The book is loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, including: managing and monitoring SQL Server, automating administration, security, change management, performance tuning, scaling an...
| Clasificación: | Libro Electrónico |
|---|---|
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub.,
©2009.
|
| Colección: | Wrox professional guides.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Professional Microsoft SQL Server 2008 Administration; About the Authors; Credits; Acknowledgments; Contents; 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 2008 Architecture; The Expanding Role of a DBA; SQL Server Architecture; Editions of SQL Server; Summary; Chapter 2: SQL Server 2008 Installation Best Practices; Planning the System; Installing SQL Server; Installing Analysis Services; Burning in the System; Post-Install Configuration; Uninstalling SQL Server
- Common Installation IssuesTroubleshooting a Failed Install; Summary; Chapter 3: Upgrading SQL Server 2008 Best Practices; Why Upgrade to SQL Server 2008?; Upgrading to SQL Server 2008; Pre-Upgrade Checks; Backward Compatibility; SQL Server Component Considerations; Post-Upgrade Checks; Summary; Chapter 4: Managing and Troubleshooting the Database Engine; Configuration Tools; Management Studio; Trace Flags; Getting Help from Support; Summary; Chapter 5: Automating SQL Server; Maintenance Plans; SQL Server Agent; Summary; Chapter 6: Integration Services Administration and Performance Tuning
- A Tour of Integration ServicesAdministration 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 Server; Administering 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; Service Broker
- Security Considerations for Service BrokerConversation Priorities; Administering Service Broker; Introduction to CLR Integration; Summary; Chapter 9: Securing the Database Engine; Security Principles; Creating a Secure Configuration; Surface Area Configuration; Endpoints; Identity and Access Control; Schemas; Securables and Object Permissions; Encryption; SQL Server Audit; Summary; Chapter 10: Change Management; Creating Projects; Policy-Based Management; Trigger Views; sqlcmd; Creating Change Scripts; Summary; Chapter 11: Configuring the Server for Optimal Performance
- What Every DBA Needs to Know about PerformanceWhat 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 2008; Application Optimization; The Silent Killer: I/O Problems; Table and Index Par titioning; Data Compression; Memory Considerations and Enhancements; CPU Considerations; Summary; Chapter 13: Monitoring Your SQL Server; The Goal of Monitoring; What's New in Monitoring for SQL Server 2008