Professional Microsoft SQL server 2008 administration
SQL Server 2008 is how-to guide for experienced DBAs. Tutorial-based, this book will get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. The book...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub
c2009.
|
| Edición: | 1st edition |
| Colección: | Wrox professional guides Professional Microsoft SQL server 2008 administration
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627655106719 |
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
- Choosing the Appropriate Monitoring Tools
