Advertisement

Pro SQL Server Administration

  • Authors
  • Peter A Carter

Table of contents

  1. Front Matter
    Pages i-xxv
  2. Installing and Configuring SQL Server

    1. Front Matter
      Pages 1-1
    2. Peter A Carter
      Pages 3-28
    3. Peter A Carter
      Pages 29-63
    4. Peter A Carter
      Pages 65-88
    5. Peter A Carter
      Pages 89-127
  3. Database Administration

    1. Front Matter
      Pages 129-129
    2. Peter A Carter
      Pages 131-161
    3. Peter A Carter
      Pages 163-198
    4. Peter A Carter
      Pages 199-247
    5. Peter A Carter
      Pages 249-275
  4. Security, Resilience, and Scaling

    1. Front Matter
      Pages 277-277
    2. Peter A Carter
      Pages 279-315
    3. Peter A Carter
      Pages 317-339
    4. Peter A Carter
      Pages 365-416
    5. Peter A Carter
      Pages 417-487
    6. Peter A Carter
      Pages 489-517
    7. Peter A Carter
      Pages 519-554
    8. Peter A Carter
      Pages 555-627
  5. Monitoring and Maintenance

    1. Front Matter
      Pages 629-629
    2. Peter A Carter
      Pages 631-660
    3. Peter A Carter
      Pages 661-687
    4. Peter A Carter
      Pages 689-730
    5. Peter A Carter
      Pages 731-771
    6. Peter A Carter
      Pages 773-858
    7. Peter A Carter
      Pages 859-886
    8. Peter A Carter
      Pages 887-908
    9. Peter A Carter
      Pages 909-924
  6. Managing a Hybrid Cloud Environment

    1. Front Matter
      Pages 925-925
    2. Peter A Carter
      Pages 927-943
    3. Peter A Carter
      Pages 945-959
    4. Peter A Carter
      Pages 961-991
  7. Back Matter
    Pages 993-1004

About this book

Introduction

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

Bibliographic information

Industry Sectors
Pharma
Chemical Manufacturing
Biotechnology
Finance, Business & Banking
Electronics
IT & Software
Telecommunications
Consumer Packaged Goods
Energy, Utilities & Environment
Engineering