Skip to main content
  • Book
  • © 2012

Pro SQL Server 2012 Administration

Apress
  • Pro SQL Server 2012

  • Administration is a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012.

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

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 (18 chapters)

  1. Front Matter

    Pages i-xxiii
  2. Introducing Microsoft SQL Server 2012

    1. Front Matter

      Pages 1-1
    2. New Features Overview

      • Ken Simmons, Sylvester Carstarphen
      Pages 3-14
    3. Pre-Installation Considerations

      • Ken Simmons, Sylvester Carstarphen
      Pages 15-32
    4. Choosing a High-Availability Solution

      • Ken Simmons, Sylvester Carstarphen
      Pages 33-57
  3. Getting Started

    1. Front Matter

      Pages 59-59
    2. Installing and Upgrading

      • Ken Simmons, Sylvester Carstarphen
      Pages 61-98
    3. Post-Installation

      • Ken Simmons, Sylvester Carstarphen
      Pages 99-124
  4. Administering Microsoft SQL Server 2012

    1. Front Matter

      Pages 125-125
    2. Multi-Server Administration

      • Ken Simmons, Sylvester Carstarphen
      Pages 127-157
    3. Managing Security Within the Database Engine

      • Ken Simmons, Sylvester Carstarphen
      Pages 159-182
    4. Working with Database Objects

      • Ken Simmons, Sylvester Carstarphen
      Pages 183-222
    5. Indexing for Performance

      • Ken Simmons, Sylvester Carstarphen
      Pages 223-256
    6. Managing Backups

      • Ken Simmons, Sylvester Carstarphen
      Pages 257-281
    7. Restore and Recovery Strategies

      • Ken Simmons, Sylvester Carstarphen
      Pages 283-318
    8. Automating Routine Maintenance

      • Ken Simmons, Sylvester Carstarphen
      Pages 319-352
  5. Troubleshooting and Tuning

    1. Front Matter

      Pages 353-353
    2. Monitoring Your Server

      • Ken Simmons, Sylvester Carstarphen
      Pages 355-387
    3. Auditing SQL Server

      • Ken Simmons, Sylvester Carstarphen
      Pages 389-401
    4. Extended Events Interface

      • Ken Simmons, Sylvester Carstarphen
      Pages 403-420

About this book

Pro SQL Server 2012 Administration is a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012. SQL Server administration is a complex field requiring an unusually broad and well-rounded skill set. A good database administrator must be part system administrator, part database design expert, and part SQL tuning optimization guru. Above all, he or she must be capable of restoring a damaged database at any time. Database administration requires excellent people skills for dealing with management and clients, and solid technical skills for dealing with the hardware and the software.

Pro SQL Server 2012 Administration addresses all aspects of database administration, regardless of the size of the implementation. Install SQL Server 2012 and create new database environments. Develop a sound backup strategy for your database. Perform recovery as needed, which many consider to be job #1. Authors Ken Simmons and Sylvester Carstarphen also help you automate your work through the use of policy-based management. Performance optimization gets good coverage, so that you can render assistance when developers need help with problem queries.

Rare among database and other technical books is solid guidance on the people side of the equation. Success as a database administrator comes from working well with others, becoming involved in the community, and building the right combination of technical knowledge and people skills to solve problems and get things done professionally and amicably. Simmons and Carstarphen pay special attention to these aspects of the job in this new edition of their comprehensive book on SQL Server administration.

  • Helps you manage a SQL Server 2012 database at professional level
  • Covers the gamut of database administration skills
  • Provides guidance on performance optimization

About the authors

Ken Simmons is a database administrator and developer specializing in Microsoft SQL Server and .NET. He is currently working with a global electronic payment service provider in Columbus, Georgia. He has been working in the IT industry since 2000 and holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005. Ken is highly active in the online community and often participates in the SQL forums on MSDN and SQLServerCentral. He enjoys sharing tips that he discovers by writing articles for SQLServerCentral and MSSQLTips.com. He has also formed an SQL Server Users Group in Columbus, Georgia, for SQL Server professionals to come together to share knowledge and resources. When he is not working, Ken enjoys traveling with his wife, Susan, and son, Nathan, and can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, Florida.

Bibliographic Information

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access