This is the ideal book for anybody who uses SQL Server on a daily basis. The author covers the popular database software a DBA's perspective. Topics covered will include:
• Designing a database design
• Planning a database server planning
• Installing and configuring SQL Server
• Creating databases and tables
• Creating stored procedures and triggers
• Optimizing databases and the database server
• Securing the SQL Server
• Backing up and restoring and high availability
In addition, this will be the ideal study tool for anybody looking to get their MCITP: SQL Server 2008 Administration certification, as this book explores in-depth the skill set of an MCITP as defined by Microsoft.
Each chapter will include:
• Opening list of chapter topics
• Hands-on Exercises
• Real World Scenarios

About the Author

Tom Carpenter, MCTS: SQL Server 2005, MCITP: SQL Server 2005, is the founder and Senior Consultant for The Systems Education Company, a training and consulting firm located in central Ohio. He is the author of several books on technical topics including networking infrastructure, database management and VoIP. Having worked as a systems analyst in a large corporation with more than 20,000 network nodes, Tom brings a wealth of real-world experience to his books and presentations.

Table of Contents:
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 Solutions. • Chapter 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 Distribution. • Chapter 20 SQL Server Failover Clustering. • Chapter 21 Database Mirroring and Snapshots. • Chapter 22 Implementing Replication. Appendix A Microsoft's Certification Program. Appendix B About the Companion CD. Glossary. Index.