Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Pro SQL Server 2012 Administration (Professional 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. 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 resolve query 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?
(HTML tags aren't allowed.)

PowerPoint 2010 Bible
PowerPoint 2010 Bible

Master PowerPoint and improve your presentation skills-with one book!

It's no longer enough to have slide after slide of text, bullets, and charts. It's not even enough to have good speaking skills if your PowerPoint slides bore your audience. Get the very most out of all that PowerPoint 2010 has to offer while also...

JavaFX: Developing Rich Internet Applications (Java Series)
JavaFX: Developing Rich Internet Applications (Java Series)
It is not often that you get the chance to witness (let alone participate in!) the birth of a truly disruptive technology. We are now at a juncture where information is pervasive—there is a convergence that will allow us to seamlessly move from one information source to another as we conduct our daily lives. Whether we are operating our smart...
Proceedings of the 22nd International Meshing Roundtable
Proceedings of the 22nd International Meshing Roundtable

This volume contains the articles presented at the 22nd International Meshing Roundtable (IMR) organized, in part, by Sandia National Laboratories and was held on Oct 13-16, 2013 in Orlando, Florida, USA. The first IMR was held in 1992, and the conference series has been held annually since. Each year the IMR brings together researchers,...

Expert Oracle Application Express
Expert Oracle Application Express

Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle’s enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database....

Adobe Photoshop Elements 9: Maximum Performance: Unleash the hidden performance of Elements
Adobe Photoshop Elements 9: Maximum Performance: Unleash the hidden performance of Elements

Let Mark Galer guide you through the most powerful photo editing tools and techniques that Elements has to offer! A unique cominbtion of step-by-step projects, movie tutorials and sample images will have you creating stunning images in no time at all. Whether you want to enhance your images for maximum...

Spring Enterprise Recipes: A Problem-Solution Approach
Spring Enterprise Recipes: A Problem-Solution Approach

The Spring Framework is a widely adopted enterprise and general Java framework. The release of Spring Framework 3.0 has added many improvements and new features for Spring development. Written by Gary Mak of the best-selling Spring Recipes and Josh Long, an expert Spring user and developer, Spring...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy