Beginning Microsoft SQL server 2008 administration Includes index

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation and configuration/architecting, implementing and monitoring security controls, configuring and managing network communications, automating administration tasks, disaster prevention and recovery, performance monitoring, optimizing and ensuring high availability, as well as major SQL Server 2008 components including Integration Services, Reporting Services, Analysis Services, and Service Broker. Beginning Microsoft® SQL Server® 2008 Administration -1 Cover Page 1 About the Authors 11 Credits 13 Acknowledgments 15 Contents 17 Introduction 29 Who This Book Is For 31 What This Book Covers 32 How This Book Is Structured 32 What You Need to Use This Book 32 Conventions 33 Source Code 33 Errata 34 p2p.wrox.com 34 Chapter 1: Introducing SQL Server 2008 37 A Condensed History of SQL Server 37 What Is SQL Server 2008? 39 SQL Server 2008 Editions 43 SQL Server 2008 Architecture 47 SQL Server 2008 Database Objects 51 SQL Server 2008 Databases 54 SQL Server 2008 Database Storage 56 SQL Server Security 58 Summary 59 Chapter 2: Installing SQL Server 2008 61 SQL Server Installation Planning 61 SQL Server Installation Center 70 Installation Review 86 Summary 86 Chapter 3: SQL Server 2008 Tools 87 SQL Server Management Studio 88 Log File Viewer 126 SQL Server Business Intelligence Development Studio 127 SQL Server Profiler 129 Database Engine Tuning Advisor 133 SQL Server Configuration Manager 136 Reporting Services Configuration Manager 136 Command-Line Tools 138 Summary 145 Chapter 4: SQL Server 2008 Storage Architecture 147 The Resource Database 148 SQL Server Database Physical Structure 149 Summary 163 Chapter 5: SQL Server 2008 Databases 165 System Databases 165 User Databases 165 Database Planning 165 Creating Databases 167 Database Diagrams 226 Views 227 Synonyms 228 Programming Objects 229 Summary 236 Chapter 6: SQL Server 2008 Security 237 SQL Server Authentication Modes 237 Principals 240 Permissions 261 SQL Server Encryption 279 Best Practices 293 Summary 295 Chapter 7: Configuring SQL Server Network Communication 297 SQL Server 2008 Network Protocols 297 SQL Native Client Configuration 300 SQL Server Endpoints 301 Summary 320 Chapter 8: Automating Administrative Tasks 321 Policy-Based Management 322 Central Management Servers 328 Database Mail 330 Event Notifications 351 SQL Server Agent 352 Maintenance Plans 394 Best Practices 396 Summary 397 Chapter 9: Disaster Prevention and Recovery 399 Chapter Preparation 399 Database Recovery Models 401 SQL Server 2008 Database Backup 403 SQL Server 2008 Backup Types 405 Backup Options 408 Backup Strategies 411 Restoring Databases 415 Command 416 Database Snapshots 432 Summary 436 Chapter 10: Monitoring SQL Server 437 Performance Monitoring 437 Tools and Techniques for Monitoring 445 Auditing 466 Tracking Changes 480 Data Collection 491 Monitoring Database Modifications 504 Summary 508 Chapter 11 Optimizing SQL Server 509 Hardware Optimization 510 Design Considerations 514 Query Optimization 535 T-SQL Optimization Tips 562 Resource Governor 576 Summary 587 Chapter 12: SQL Server High Availability 589 Introduction to High Availability 589 Failover Clustering 590 Log Shipping 594 Database Mirroring 609 Summary 624 Chapter 13: Introduction to Replication 625 Replication Overview 625 SQL Server Replication Agents 626 SQL Server Replication Types 627 SQL Server Replication Models 631 Replication Tools 632 Summary 641 Chapter 14: Introduction to the Common Language Runtime 643 Databases and Programming 643 Is Transact-SQL Going Away? 644 .NET and the CLR 645 SQL Server CLR Objects 646 Deployment with Visual Studio 665 Programming Support 668 Security Options 669 Summary 673 Chapter 15: An Administrator’s Guide to Business Intelligence 675 Understanding BI 675 Performance Management 676 Business Intelligence Components 676 Beyond SQL 678 So Many Tools, So Little Time 680 Summary 680 Chapter 16: Introduction to SQL Server Integration Services 681 About SSIS 681 Importing and Exporting Data 685 Transforming Data with SSIS 694 Summary 711 Chapter 17: Introduction to SQL Server Analysis Services 713 Understanding OLAP 713 Working with SSAS 715 Managing SSAS 732 Advanced SSAS Concepts 738 Summary 741 Chapter 18: Introduction to SQL Server Reporting Services 743 SQL Server Reporting Services Overview 743 Installation and Configuration 753 Creating Reports 756 Report Delivery 765 Summary 767 Chapter 19: Introduction to Service Broker 769 Service-Oriented Architecture 769 Service Broker Overview 770 Service Broker Elements 770 Security Considerations for Service Broker 774 Creating a Sample Application 775 Managing Service Broker with SSMS 789 Summary 789 Index 791