Beginning Microsoft SQL server 2008 administration
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. T...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub
2009.
|
| Edición: | 1st edition |
| Colección: | Wrox beginning guides.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627761706719 |
Tabla de Contenidos:
- 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
