Book description
- This comprehensive book guides readers through Microsoft's brand-new SQL 2005 administrator exam: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (Exam 70443)
- Addresses the database tasks that the MCITP exam focuses on such as design, development, deployment, optimization, maintenance, and support
- Reviews key topics, including defining high availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and much more
- The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Table of contents
- Cover Image
- Title page
- Copyright
- To Our Valued Readers:
- Dedication
- Acknowledgements
- About the Authors
- Contents at a Glance
- Contents
- Table of Exercises
-
Introduction
- Introducing the Microsoft Certified IT Professional
- How to Become Certified as a MCITP: Database Administrator
- Registering for the Exam
- Taking the Designing a Database Server Infrastructure by Using SQL Server 2005 Exam
- Types of Exam Questions
- Tips for Taking the Exam
- What's in the Book?
- What's on the Book's CD?
- How Do You Use This Book?
- Hardware and Software Requirements
- Assessment Test
- Chapter 1: Designing the Hardware and Software Infrastructure
-
Chapter 2: Designing Physical Storage
- Understanding SQL Server Storage Concepts
- Estimating Database Size
- Designing Transaction Log Storage
- Designing Backup-File Storage
- Deciding Where to Install the Operating System
- Deciding Where to Place SQL Server Service Executables
- Specifying the Number and Placement of Files for Each Database
- Designing Instances
- Deciding on the Number of Instances
- Deciding How to Name Instances
- Deciding How Many Physical Servers You Need for Instances and How Many Databases to Create
- Deciding Where to Place System Databases for Each Instance
- Deciding on the Physical Storage for the tempdb Database for Each Instance
- Establishing Service Requirements
- Specifying Instance Configurations
- Summary
- Exam Essentials
- Case Study: Mullen Enterprises
- Review Questions
- Answers to Review Questions
- Chapter 3: Designing a Consolidation Strategy
-
Chapter 4: Designing Database-Level Security
- Gathering Your Security Requirements
- Integrating with the Enterprise
- Assessing the Impact of Network Policies
- Achieving High Availability in a Secure Way
- Mitigating Server Attacks
- Auditing Access
- Making Security Recommendations
- Performing Ongoing Reviews
- Summary
- Exam Essentials
- Case Study: Delaney's Simulations
- Review Questions
- Answers to Review Questions
-
Chapter 5: Designing Windows Server-Level Security Processes
- Understanding Password Rules
- Setting Up the Encryption Policy
- Introducing SQL Server Service Accounts
- Setting Up Antivirus Software
- Working with Services
- Configuring Server Firewalls
- Physically Securing Your Servers
- Summary
- Exam Essentials
- Case Study: The Ever-Growing Wealth Company
- Review Questions
- Answers to Review Questions
-
Chapter 6: Designing SQL Server Service-Level Security
- Creating Logins
- Granting Server Roles
- Mapping Database Users to Roles
- Securing Schemas
- Granting Database Roles
- Introducing DDL Triggers
- Defining a Database-Level Encryption Policy
- Securing Endpoints
- Granting SQL Server Agent Job Roles
- Designing .NET Assembly Security
- Summary
- Exam Essentials
- Case Study: Herd of Two
- Review Questions
- Answers to Review Questions
- Chapter 7: Designing SQL Server Object-Level Security
- Chapter 8: Designing a Physical Database
- Chapter 9: Creating Database Conventions and Standards
-
Chapter 10: Designing a SQL Server 2005 Solution for High Availability
- Examining High-Availability Technologies
- Understanding Failover Clustering
- Understanding Database Mirroring
- Understanding Log Shipping
- Understanding Replication
- Designing Highly Available Storage
- Designing a High-Availability Solution
- Developing a Migration Strategy
- Summary
- Exam Essentials
- Case Study: Ed's Heavy Equipment
- Review Questions
- Answers to Review Questions
- Chapter 11: Designing a Data Recovery Solution for a Database
-
Chapter 12: Designing a Data-Archiving Solution
- Why Archive Data?
- Determining Business and Regulatory Requirements
- Determining What Data Will Be Archived
- Selecting a Storage Format
- Developing a Data-Movement Strategy
- Designing a Replication Topology
- Summary
- Exam Essentials
- Case Study: Developing an Archive Plan
- Review Questions
- Answers to Review Questions
- Glossary
- Index
- Backcover Page
Product information
- Title: MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide
- Author(s):
- Release date: September 2006
- Publisher(s): Sybex
- ISBN: 9780470047446
You might also like
book
MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide
This ebook does not provide access to the CD-ROM files. Covering Microsoft's brand-new SQL 2005 administrator …
book
Microsoft® SQL Server™ 2005 Administrator's Companion
Get comprehensive information to plan, deploy, administer, and support Microsoft SQL Server 2005 in organizations of …
book
Microsoft® SQL Server 2005 Unleashed
Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the …
book
Mastering SQL Server® 2008
As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the …