Professional SQL server 2005 administration
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 na...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wrox/Wiley TechnologyTechnology
c2007.
|
| Colección: | Wrox professional guides.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009644317106719 |
Tabla de Contenidos:
- 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
