Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShareBuy Print Version
    Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

    • Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

    • By:

    • Publisher: Microsoft Press

    • Pub. Date:

    • Print ISBN-13: 978-0-7356-2738-3

    • Pages in Print Edition: 738

    • Subscriber Rating: 0 out of 5 rating0 [0 Ratings]

    2ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    The fast-answers, daily administration guide to SQL Server® 2008 (updated for R2). This pocket-sized guide from award-winning author William Stanek features concise tables, listings, and step-by-step instructions for fast, accurate answers on the spot.

    Subscriber Reviews

    Average Rating: 0 out of 5 rating Based on 0 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     

    View Sample

    Microsoft(R) SQL Server(R) 2008 Administrator's Pocket Consultant

    View Sample

    Acknowledgments

    View Sample
    Introduction
    View Sample

    Who Is This Book For?

    View Sample

    How Is This Book Organized?

    View Sample

    Conventions Used in This Book

    View Sample

    Other Resources

    View Sample

    Support for This Book

    View Sample

    We Want to Hear from You

    View Sample
    1. SQL Server 2008 Administration Overview
    View Sample

    SQL Server 2008 and Your Hardware

    View Sample

    SQL Server 2008 Editions

    View Sample

    SQL Server and Windows

    View Sample

    Using the Graphical Administration Tools

    View Sample

    Using the Command-Line Tools

    View Sample

    Using SQL Server PowerShell

    View Sample
    2. Deploying SQL Server 2008
    View Sample

    SQL Server Integration Roles

    View Sample

    Planning for Your SQL Server 2008 Deployment

    View Sample

    Running and Modifying SQL Server Setup

    View Sample
    3. Managing the Surface Security, Access, and Network Configuration
    View Sample

    Managing SQL Server Component Feature Access

    View Sample

    Configuring SQL Server Services

    View Sample

    Managing the Network and SQL Server Native Client Configuration

    View Sample
    4. Configuring and Tuning SQL Server 2008
    View Sample

    Accessing SQL Server Configuration Data

    View Sample

    Techniques for Managing SQL Server Configuration Options

    View Sample

    Configuring SQL Server with Stored Procedures

    View Sample
    5. Managing the Enterprise
    View Sample

    Using SQL Server Management Studio

    View Sample

    Managing SQL Server Groups

    View Sample

    Managing Servers

    View Sample

    Using Windows PowerShell for SQL Server Management

    View Sample

    Starting, Stopping, and Configuring SQL Server Agent

    View Sample

    Starting, Stopping, and Configuring Microsoft Distributed Transaction Coordinator

    View Sample

    Managing SQL Server Startup

    View Sample

    Managing Server Activity

    View Sample
    6. Implementing Policy-Based Management
    View Sample

    Introducing Policy-Based Management

    View Sample

    Working with Policy-Based Management

    View Sample

    Managing Policies Throughout the Enterprise

    View Sample
    7. Configuring SQL Server with SQL Server Management Studio
    View Sample

    SQL Server Management Studio Essentials

    View Sample

    Configuring Authentication and Auditing

    View Sample

    Tuning Memory Usage

    View Sample

    Configuring Processors and Parallel Processing

    View Sample

    Configuring Threading, Priority, and Fibers

    View Sample

    Configuring User and Remote Connections

    View Sample

    Managing Server Settings

    View Sample

    Managing Database Settings

    View Sample

    Adding and Removing Active Directory Information

    View Sample

    Troubleshooting Configuration Problems

    View Sample
    8. Core Database Administration
    View Sample

    Database Files and Logs

    View Sample

    Database Administration Basics

    View Sample

    Creating Databases

    View Sample

    Altering Databases and Their Options

    View Sample

    Managing Database and Log Size

    View Sample

    Manipulating Databases

    View Sample

    Tips and Techniques

    View Sample
    9. Managing SQL Server 2008 Security
    View Sample

    Overview of SQL Server 2008 Security

    View Sample

    SQL Server 2008 Authentication Modes

    View Sample

    Special-Purpose Logins and Users

    View Sample

    Permissions

    View Sample

    Statement Permissions

    View Sample

    Roles

    View Sample

    Managing Server Logins

    View Sample

    Configuring Server Roles

    View Sample

    Controlling Database Access and Administration

    View Sample

    Managing Database Permissions

    View Sample
    10. Manipulating Schemas, Tables, Indexes, and Views
    View Sample

    Working with Schemas

    View Sample

    Getting Started with Tables

    View Sample

    Table Essentials

    View Sample

    Working with Tables

    View Sample

    Managing Table Values

    View Sample

    Using Views

    View Sample

    Creating and Managing Indexes

    View Sample

    Column Constraints and Rules

    View Sample

    Creating Partitioned Tables and Indexes

    View Sample

    Compressing Tables, Indexes, and Partitions

    View Sample
    11. Importing, Exporting, and Transforming Data
    View Sample

    Working with Integration Services

    View Sample

    Creating Packages with the SQL Server Import And Export Wizard

    View Sample

    Understanding BCP

    View Sample

    BCP Scripts

    View Sample

    Using the BULK INSERT Command

    View Sample
    12. Linked Servers and Distributed Transactions
    View Sample

    Working with Linked Servers and Distributed Data

    View Sample

    Managing Linked Servers

    View Sample
    13. Implementing Snapshot, Merge, and Transactional Replication
    View Sample

    An Overview of Replication

    View Sample

    Planning for Replication

    View Sample

    Distributor Administration

    View Sample

    Creating and Managing Publications

    View Sample

    Subscribing to a Publication

    View Sample
    14. Profiling and Monitoring SQL Server 2008
    View Sample

    Monitoring Server Performance and Activity

    View Sample

    Working with Replication Monitor

    View Sample

    Working with the Event Logs

    View Sample

    Monitoring SQL Server Performance

    View Sample

    Configuring a Management Data Warehouse

    View Sample

    Solving Performance Problems with Profiler

    View Sample
    15. Backing Up and Recovering SQL Server 2008
    View Sample

    Creating a Backup and Recovery Plan

    View Sample

    Selecting Backup Devices and Media

    View Sample

    Using Backup Strategies

    View Sample

    Creating a Backup Device

    View Sample

    Performing Backups

    View Sample

    Restoring a Database

    View Sample

    Restoring the master Database

    View Sample
    16. Database Automation and Maintenance
    View Sample

    Overview of Database Automation and Maintenance

    View Sample

    Using Database Mail

    View Sample

    Using SQL Server Agent

    View Sample

    Managing Alerts

    View Sample

    Managing Operators

    View Sample

    Scheduling Jobs

    View Sample

    Automating Routine Server-to-Server Administration Tasks

    View Sample

    Multiserver Administration

    View Sample

    Database Maintenance

    View Sample
    17. Managing Log Shipping and Database Mirroring
    View Sample

    Log Shipping

    View Sample

    Database Mirroring

    View Sample

    Using Mirroring and Log Shipping

    View Sample

    Index

    View Sample

    About the Author

    View Sample

    Copyright

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Visit the catalog page for Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

    • Catalog Page

    Visit the errata page for Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

    • Errata