Beginning Microsoft SQL Server 2008 Administration.
Title:
Beginning Microsoft SQL Server 2008 Administration.
Author:
Leiter, Chris.
ISBN:
9780470501252
Personal Author:
Edition:
1st ed.
Physical Description:
1 online resource (820 pages)
Series:
Wrox beginning guides.
Contents:
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 -- SQL Server Installation Planning -- SQL 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 -- Creating Databases -- Database 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 -- Chapter 9: Disaster Prevention and Recovery -- Chapter 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 -- Chapter 12: SQL Server High Availability -- Introduction 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 -- Understanding BI -- Performance Management -- Business Intelligence Components -- Beyond SQL -- So Many Tools, So Little Time -- Summary -- Chapter 16: Introduction to SQL Server Integration Services -- About SSIS -- Importing and Exporting Data -- Transforming Data with SSIS -- Summary -- Chapter 17: Introduction to SQL Server Analysis Services -- Understanding OLAP -- Working with SSAS -- Managing SSAS -- Advanced SSAS Concepts -- Summary -- Chapter 18: Introduction to SQL Server Reporting Services.
SQL Server Reporting Services Overview -- Installation and Configuration -- Creating Reports -- Report Delivery -- Summary -- Chapter 19: Introduction to Service Broker -- Service-Oriented Architecture -- Service Broker Overview -- Service Broker Elements -- Security Considerations for Service Broker -- Creating a Sample Application -- Managing Service Broker with SSMS -- Summary -- Index.
Abstract:
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.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Genre:
Electronic Access:
Click to View