SQL server 2008 administration [[electronic resource] ] : real world skills for MCITP certification and beyond / / Tom Carpenter

• Record Nr.: UNINA9910456316903321
• Autore: Carpenter Tom <1972->
• Pubbl/distr/stampa: Indianapolis, Ind., : Wiley Pub., 2010
• ISBN: 1-282-69034-5; 9786612690341; 0-470-64940-2
• Edizione: [1st ed.]
• Descrizione fisica: 1 online resource (819 p.)
• Collana: Sybex serious skills
• Disciplina: 005.4/476
• Soggetti: Electronic data processing personnel - Certification; Microsoft software - Examinations; Electronic books.
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Description based upon print version of record.
• Nota di bibliografia: Includes bibliographical references and index.
• Nota di contenuto: 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
• Sommario/riassunto: 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 DBA faces regularly and shows you step by step how to handle them. Topics include installation and configuration, creating databases and tables, optimizing the database server, planning for high availability, and more. And, if you're preparing for MCTS or MCITP certification in SQL Server