SQL server 2008 administration real world skills for MCITP certification and beyond

The ideal on-the-job reference guide for SQL Server 2008 database administrators If you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planning to disaster recovery, this practical book explores tasks and scenarios that a working SQL Server D...

Descripción completa

Detalles Bibliográficos
Autor principal: Carpenter, Tom, 1972- (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Indianapolis, Ind. : Wiley Pub 2010.
Edición:1st ed
Colección:Sybex serious skills
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627565506719
Tabla de Contenidos:
  • Microsoft SQL Server 2008 Administration: Real World Skills for MCITP Certification and Beyond; About the Author; Contents at a Glance; Contents; Table of Exercises; Introduction; Part I: Introducing SQL Server 2008; Chapter 1: Understanding SQL Server's Role; Chapter 2: Installing SQL Server 2008; Chapter 3: Working with the Administration Tools; Chapter 4: SQL Server Command-Line Administration; Part II: Designing Database Solutions; Chapter 5: Database Concepts and Terminology; Chapter 6: ERD and Capacity Planning; Chapter 7: Normalization: Enough Is Enough
  • Part III: Implementing Database SolutionsChapter 8: Creating SQL Server Databases; Chapter 9: Creating Tables; Chapter 10: Indexes and Views; Chapter 11: Triggers and Stored Procedures; Chapter 12: Implementing Advanced Features; Part IV: Administration and Maintenance; Chapter 13: Creating Jobs, Operators, and Alerts; Chapter 14: Performance Monitoring and Tuning; Chapter 15: Policy-Based Management; Chapter 16: Backup and Restoration; Part V: SQL Server Security; Chapter 17: Security Threats and Principles; Chapter 18: Authentication and Encryption; Chapter 19: Security Best Practices
  • Part VI: High Availability and Data DistributionChapter 20: SQL Server Failover Clustering; Chapter 21: Database Mirroring and Snapshots; Chapter 22: Implementing Replication; Appendix A: Microsoft's Certification Program; How Do You Become Certified on SQL Server 2008?; Certification Objectives Map; Appendix B: About the Companion CD; What's on the CD; System Requirements; Using the CD; Troubleshooting; Glossary; Index