Microsoft SQL Server 2008 Management and Administration

Microsoft SQL Server 2008 Management and Administration
ISBN-10
067233044X
ISBN-13
9780672330445
Category
Database management
Pages
880
Language
English
Published
2009
Publisher
Sams Publishing
Author
Ross Mistry

Description

Realistic, independent, fast-paced, and complete: all the answers DBAs need to successfully manage the new SQL Server 2008 database engine. • • Reflects extensive testing in early-adopter enterprise environments, not isolated home labs. • Covers key SQL Server 2008 enhancements: Policy Based Management, Performance Studio, Change Management, Transparent Data Encryption, and more. • Includes best practices, tips, step-by-step configurations, and practical guidance for integrating SQL Server 2008 with other IT infrastructure. This is the most complete, fast-paced, task-based reference for database administrators who need to deploy, manage, and secure Microsoft SQL Server 2008. Authored by a world-class expert on SQL Server in the enterprise, it goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's flagship database. Ross Mistry draws on extensive testing in high-profile production environments to offer step-by-step solutions and never-before-published tips readers won't find anywhere else. Every chapter begins with a section identifying SQL Server 2008's most significant new improvements, and concludes with a convenient summary of best practices. Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, cataloging, and more. He shows DBAs how to harden any SQL Server environment; save time with SQL Server 2008's new policy-based management tools, and secure their data with Transparent Data Encryption (TDE). The book contains extensive coverage of high availability, including major improvements to failover clustering and database mirroring. Mistry concludes with an entire section on monitoring and troubleshooting -- including a full chapter on optimizing application performance with the new Resource Governor.

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Other editions

Similar books

  • Methods for Evaluating Interactive Information Retrieval Systems with Users
    Methods for Evaluating Interactive Information Retrieval Systems with Users
    By Diane Kelly

    10.1.1 Individual Differences Boyce et al. [39, p. 202] state, “the purpose of measuring user characteristics separately from the search process is to be able to use them to predict performance or to explain differences in performance.

  • Star Access 2.0 for Windows
    Star Access 2.0 for Windows
    By Pamela R. Toliver

    ... Midway Continuing Education ; Curt Griffin , Okefenokee Technical Institute ; Sandra Hagman , Forsythe Community College ; Edward Harms , Interactive Business Systems , Inc .; Carolyn Harris , Black Hawk College ; Billie J. Herrin ...

  • Independent Projects Using Microsoft Office and the Web, Grades 6-8
    Independent Projects Using Microsoft Office and the Web, Grades 6-8
    By Todd M. Toporski

    If you have purchased an e-book Site License, you may duplicate and use only within the school and/or district for which you purchased the License. Editor Sara Connolly Managing Editor Elizabeth Morris, Ph.D. Editor-in-Chief Sharon.

  • Exploring Microsoft Office Access 2019 Comprehensive
    Exploring Microsoft Office Access 2019 Comprehensive
    By Mary Anne Poatsy, Amy Rutledge, Jerri Williams

    A market leader for over 20 years, the collection helps students achieve high-level learning outcomes by engaging them in the way they learn best - through hands-on practice.

  • Exploring Microsoft Access, Version 2.0
    Exploring Microsoft Access, Version 2.0
    By Robert T. Grauer, Maryann M. Barber

    Business-oriented problems and cases are included and make the texts ideal for use in courses taught out of Schools of Business.

  • Database Management Using DBase IV and SQL
    By Robert T. Grauer, Maryann M. Barber

    Database Management Using DBase IV and SQL

  • Database Management Using DBASE IV and SQL
    By Robert T. Grauer

    Database Management Using DBASE IV and SQL

  • Database Management Through DBase
    Database Management Through DBase
    By Robert T. Grauer, Maryann M. Barber

    Robert T. Grauer, Maryann M. Barber. r DATABASE MANAGEMENT THROUGH dBASE Robert T. Grauer Maryann M. Barber.

  • Exploring Microsoft Office Access 2016 Comprehensive
    Exploring Microsoft Office Access 2016 Comprehensive
    By Mary Anne Poatsy, Jerri Williams, Robert Grauer

    This book offers full, comprehensive coverage of Microsoft Access. Beyond point-and-click The goal of the Exploring series is to move students beyond the point-and-click, to understanding the why and how behind each skill.

  • Sending and Receiving Your Domain Email with Gmail
    By Whil Hentzen

    This book will show you a variety of ways to use Gmail with your own domain in a variety of scenarios, from one address on one domain to multiple addresses on multiple domains, so that you can log into Gmail's interface and send and receive ...