Beginning Microsoft SQL Server 2008 Administration
Chris. Leiter
Bok Engelsk 2009 · Electronic books.
Annen tittel | |
---|---|
Utgitt | Chichester : : Wiley, , 2009.
|
Omfang | 1 online resource (820 p.)
|
Opplysninger | Description based upon print version of record.. - Beginning Microsoft® SQL Server® 2008 Administration; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Introducing SQL Server 2008; A Condensed History of SQL Server; What Is SQL Server 2008?; SQL Server 2008 Editions; SQL Server 2008 Architecture; SQL Server 2008 Database Objects; SQL Server 2008 Databases; SQL Server 2008 Database Storage; SQL Server Security; Summary; Chapter 2: Installing SQL Server 2008. - Chapter 12: SQL Server High AvailabilityIntroduction to High Availability; Failover Clustering; Log Shipping; Database Mirroring; Summary; Chapter 13: Introduction to Replication; Replication Overview; SQL Server Replication Agents; SQL Server Replication Types; SQL Server Replication Models; Replication Tools; Summary; Chapter 14: Introduction to the Common Language Runtime; Databases and Programming; Is Transact-SQL Going Away?; .NET and the CLR; SQL Server CLR Objects; Deployment with Visual Studio; Programming Support; Security Options; Summary. - Chapter 15: An Administrator's Guide to Business Intelligence. - Chapter 9: Disaster Prevention and RecoveryChapter Preparation; Database Recovery Models; SQL Server 2008 Database Backup; SQL Server 2008 Backup Types; Backup Options; Backup Strategies; Restoring Databases; Command; Database Snapshots; Summary; Chapter 10: Monitoring SQL Server; Performance Monitoring; Tools and Techniques for Monitoring; Auditing; Tracking Changes; Data Collection; Monitoring Database Modifications; Summary; Chapter 11 Optimizing SQL Server; Hardware Optimization; Design Considerations; Query Optimization; T-SQL Optimization Tips; Resource Governor; Summary. - Creating DatabasesDatabase Diagrams; Views; Synonyms; Programming Objects; Summary; Chapter 6: SQL Server 2008 Security; SQL Server Authentication Modes; Principals; Permissions; SQL Server Encryption; Best Practices; Summary; Chapter 7: Configuring SQL Server Network Communication; SQL Server 2008 Network Protocols; SQL Native Client Configuration; SQL Server Endpoints; Summary; Chapter 8: Automating Administrative Tasks; Policy-Based Management; Central Management Servers; Database Mail; Event Notifications; SQL Server Agent; Maintenance Plans; Best Practices; Summary. - SQL Server Installation PlanningSQL Server Installation Center; Installation Review; Summary; Chapter 3: SQL Server 2008 Tools; SQL Server Management Studio; Log File Viewer; SQL Server Business Intelligence Development Studio; SQL Server Profiler; Database Engine Tuning Advisor; SQL Server Configuration Manager; Reporting Services Configuration Manager; Command-Line Tools; Summary; Chapter 4: SQL Server 2008 Storage Architecture; The Resource Database; SQL Server Database Physical Structure; Summary; Chapter 5: SQL Server 2008 Databases; System Databases; User Databases; Database Planning. - 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,
|
Emner | |
Sjanger | |
Dewey | |
ISBN | 9780470440919
|