04103nam 2200637Ia 450 991045631690332120200520144314.01-282-69034-597866126903410-470-64940-2(CKB)2550000000012663(EBL)533943(OCoLC)642685764(SSID)ssj0000428721(PQKBManifestationID)11305693(PQKBTitleCode)TC0000428721(PQKBWorkID)10424868(PQKB)10166969(MiAaPQ)EBC533943(CaSebORM)9780470554203(Au-PeEL)EBL533943(CaPaEBR)ebr10388297(CaONFJC)MIL269034(EXLCZ)99255000000001266320100218d2010 uy 0engur|n|---|||||txtccrSQL server 2008 administration[electronic resource] real world skills for MCITP certification and beyond /Tom Carpenter1st ed.Indianapolis, Ind. Wiley Pub.20101 online resource (819 p.)Sybex serious skillsDescription based upon print version of record.0-470-55420-7 Includes bibliographical references and index.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 EnoughPart 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 PracticesPart 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; IndexThe 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 Electronic data processing personnelCertificationMicrosoft softwareExaminationsStudy guidesElectronic books.Electronic data processing personnelCertification.Microsoft softwareExaminations005.4/476Carpenter Tom1972-937505MiAaPQMiAaPQMiAaPQBOOK9910456316903321SQL server 2008 administration2111676UNINA