Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro SQL Server Administration

  • Book
  • © 2015

Overview

Authors:
  1. Peter A Carter
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, in-memory support, and Server Core installs suitable for virtualization.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (27 chapters)

  1. Front Matter

    Pages i-xxv
    Download chapter PDF

  2. Installing and Configuring SQL Server

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Planning the Deployment

      • Peter A Carter
      Pages 3-28

    3. GUI Installation

      • Peter A Carter
      Pages 29-63

    4. Server Core Installation

      • Peter A Carter
      Pages 65-88

    5. Configuring the Instance

      • Peter A Carter
      Pages 89-127

  3. Database Administration

    1. Front Matter

      Pages 129-129
      Download chapter PDF

    2. Files and Filegroups

      • Peter A Carter
      Pages 131-161

    3. Configuring Tables

      • Peter A Carter
      Pages 163-198

    4. Indexes and Statistics

      • Peter A Carter
      Pages 199-247

    5. Database Consistency

      • Peter A Carter
      Pages 249-275

  4. Security, Resilience, and Scaling

    1. Front Matter

      Pages 277-277
      Download chapter PDF

    2. SQL Server Security Model

      • Peter A Carter
      Pages 279-315

    3. Encryption

      • Peter A Carter
      Pages 317-339

    4. High Availability and Disaster Recovery Concepts

      • Peter A Carter
      Pages 341-364

    5. Implementing Clustering

      • Peter A Carter
      Pages 365-416

    6. Implementing AlwaysOn Availability Groups

      • Peter A Carter
      Pages 417-487

    7. Implementing Log Shipping

      • Peter A Carter
      Pages 489-517

    8. Backups and Restores

      • Peter A Carter
      Pages 519-554

    9. Scaling Workloads

      • Peter A Carter
      Pages 555-627
Back to top

About this book

Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.

You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available. Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that you'll want and need to further your career as a SQL Server database administrator.

  • Extensive coverage of hybrid cloud environments involving Azure SQL Database 

  • Detailed discussions on all new, key features, including AlwaysOn and in-memory support

  • Comprehensive coverage of key skills, such as monitoring, maintenance and indexing

About the author

Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, to sit alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005, onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation