Suitable for IT professionals, System and database administrators, IT consultants, and database application developers, this book features day-to-day tasks of administering SQL Server 2008. It covers installing, configuring, managing, and maintaining SQL Server; optimizing server performance; and troubleshooting.
Perfect companion to any SQL Server 2008 book, providing fast, accurate answers on the spot for millions of IT professionals, System and database administrators, IT consultants, and database application developers often need quick answers and practical solutions for SQL Server issues. This convenient guide offers you quick referencing for the product and database topics you need most. If you're an IT administrator looking for the essentials in the day-to-day tasks of administering SQL Server 2008, you'll appreciate this book's design for providing quick and easy look up of solutions and tables, lists, and step-by-step instructions for answers on the spot. "SQL Server 2008 Instant Administration Reference" is a guide that you want to keep within reach. SQL Server is Microsoft's bestselling database manager; the 2008 version offers enhanced security and high availability, encouraging users to upgrade. This book features thumb tabs, secondary and tertiary tables of contents, and special heading treatments to provide quick and easy lookup, as well as quick-reference tables and lists to provide answers on the spot.; It covers installing, configuring, managing, and maintaining SQL Server; optimizing server performance; and troubleshooting. "SQL Server 2008 Administration Instant Reference" answers the questions you encounter most often in your daily work.
Part I: SQL Server Basics. Chapter 1: Installing SQL Server 2008. Chapter 2: Configuring SQL Server 2008. Chapter 3: Creating Databases, Files, and Tables. Chapter 4: Executing Basic Queries. Part II: Data Integrity and Security. Chapter 5: Managing Data Integrity. Chapter 6: Managing Transactions and Locking. Chapter 7: Managing Security. Part III: Data Administration. Chapter 8: Implementing Availability and Replication. Chapter 9: Extracting, Transforming, and Loading Data. Chapter 10: Managing Data Recovery. Part IV: Performance and Advanced Features. Chapter 11: Monitoring and Tuning SQL Server. Chapter 12: Planning and Creating Indexes. Chapter 13: Implementing Policy-Based Administration. Chapter 14: Automating with the SQL Agent Service.