Skip to main content
  • Book
  • © 2015

Pro SQL Server Administration

Apress

Authors:

  • 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.

Buy it now

Buying options

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

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

Table of contents (27 chapters)

  1. Front Matter

    Pages i-xxv
  2. Installing and Configuring SQL Server

    1. Front Matter

      Pages 1-1
    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
    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
    2. SQL Server Security Model

      • Peter A Carter
      Pages 279-315
    3. Encryption

      • Peter A Carter
      Pages 317-339
    4. Implementing Clustering

      • Peter A Carter
      Pages 365-416
    5. Implementing AlwaysOn Availability Groups

      • Peter A Carter
      Pages 417-487
    6. Implementing Log Shipping

      • Peter A Carter
      Pages 489-517
    7. Backups and Restores

      • Peter A Carter
      Pages 519-554
    8. Scaling Workloads

      • Peter A Carter
      Pages 555-627

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

Buy it now

Buying options

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