Pro SQL Server 2012 Administration

Pro SQL Server 2012 Administration

by Ken Simmons, Sylvester Carstarphen
     
 

View All Available Formats & Editions

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

…  See more details below

Overview

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

What you’ll learn

  • Install SQL Server 2012 and create new databases
  • Implement backup & recovery strategies to protect your database, and your job
  • Diagnose and resolvequery performance problems
  • Apply policy-based management for consistency across all databases in an organization
  • Turn every interaction with a client, manager or executive into a stepping-stone towards career success


Who this book is for

Pro SQL Server 2012 Administration is aimed at junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2012. Readers should already have some exposure to databases in general, or to SQL Server in specific.

Table of Contents

  1. What's New?
  2. Pre-Install Considerations
  3. Choosing a High-Availability Solution
  4. Installing and Upgrading
  5. Post Installation
  6. Multi-Server Administration
  7. Security
  8. Administering Database Objects
  9. Indexing for Performance
  10. Managing Backups
  11. Restore and Recovery Strategies
  12. Automating Routine Maintenance
  13. Monitoring Your Server
  14. Auditing
  15. Extended Events Interface
  16. Managing Query Performance
  17. Secrets to Excelling as a Professional DBA
  18. What's Next?


Read More

Product Details

ISBN-13:
9781430239154
Publisher:
Apress
Publication date:
05/15/2012
Edition description:
2nd ed. 2012
Pages:
508
Product dimensions:
7.40(w) x 9.20(h) x 1.10(d)

Related Subjects

Meet the Author

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.

Sylvester Carstarphen is a senior database administrator for a customer relationship management company, where he is heavily involved in the performance monitoring and tuning of the company's very large databases. Sylvester started his database administration career almost six years ago at a Fortune 500 financial corporation, where he rapidly progressed from DBA I, to DBA II, senior DBA, and finally, working manager of database support in four years. His role consisted of managing six SQL Server administrators and an environment of more than 100 SQL Servers with more than 150 application databases. In search of opportunities to increase his performance tuning skills, Sylvester took on a new role with the company to help solve their major performance issues. Sylvester has a bachelor's degree in computer science from Wofford College in South Carolina, and a master's degree in applied computer science with a concentration in software development from Columbus State University. Sylvester enjoys playing video games and spending time with his wife and two American Staffordshire Terriers.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >