Industrial-Sized Deals Shop all Back to School Shop Women's Handbags Learn more nav_sap_SWP_6M_fly_beacon Disturbed $5 Off Fire TV Stick Off to College Essentials Shop Popular Services pivdl pivdl pivdl  Amazon Echo Starting at $99 Kindle Voyage Big Savings in the Amazon Fall Sportsman Event Baby Sale
Professional Microsoft SQL Server 2012 Administration and over one million other books are available for Amazon Kindle. Learn more

Professional Microsoft SQL Server 2012 Administration 1st Edition

18 customer reviews
ISBN-13: 978-1118106884
ISBN-10: 1118106881
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $10.48
Learn More
Trade in now
Have one to sell? Sell on Amazon
Rent
$11.90 - $18.51
Buy used
$21.65
Buy new
$29.76
More Buying Choices
33 New from $23.14 20 Used from $20.90
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Rent Textbooks
$29.76 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Professional Microsoft SQL Server 2012 Administration + Professional SQL Server 2012 Internals and Troubleshooting + Professional Microsoft SQL Server 2012 Integration Services
Price for all three: $104.11

Buy the selected items together

Editorial Reviews

Review

If you want a good, wide ranging, general SQL Server 2012 administration book, I can certainly recommend this book. (I Programmer, December 2013)

From the Back Cover

Tips, tricks, and workarounds for effectively administering SQL Server

This comprehensive guide teaches you the skills needed to successfully administer SQL Server 2012. You'll learn how to handle the most difficult admin issues including change management, security, performance tuning, monitoring, and backups. And you'll also discover how to master the latest features of the 2012 release, including client connectivity enhancements, cloud computing, data replication, and business intelligence. This detailed instruction by leading experts will help you improve the efficiency, scalability, and performance of your SQL Server environment so you can do more in much less time.

Professional Microsoft SQL Server 2012 Administration:

  • Examines settings and configuration items that improve SQL Server performance

  • Shows how to implement strategies for effective indexing for your database

  • Takes you through the setup, configuration, and testing of a cluster

  • Outlines the options in SQL Server for backups and recoveries, and provides recommendations to make the most of these features

  • Covers what you need to know about how SharePoint® 2010 integrates with SQL Server

  • Introduces SQL Server Azure and gets you up and running on this exciting new cloud platform

Wrox Professional guides are written by working developers to address everyday needs. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Programmer Forums
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More
Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

wrox.com

See all Editorial Reviews
NO_CONTENT_IN_FEATURE


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 960 pages
  • Publisher: Wrox; 1 edition (April 24, 2012)
  • Language: English
  • ISBN-10: 1118106881
  • ISBN-13: 978-1118106884
  • Product Dimensions: 7.4 x 1.7 x 9.2 inches
  • Shipping Weight: 3.5 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (18 customer reviews)
  • Amazon Best Sellers Rank: #267,494 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

10 of 11 people found the following review helpful By Dizzy Badger on September 2, 2012
Format: Paperback Verified Purchase
This book gives a great understanding of SQL Server core concepts and best practices. The most important tasks like installation and basic configuration are explained in great detail, and it is mostly clear and concise. Sadly though, it is riddled with typos and bears the markings of a book rushed by a deadline. Hopefully this will be fixed in later editions, for it is otherwise a great book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By Neeraj Agrawal on September 10, 2012
Format: Paperback
This book is definitely a must read. From anyone just starting with SQL Server or a seasoned database professional, this book has something for all.
The book starts with an overview of the new features in SQL Server 2012 and then talks about SQL installation/upgradation best practices. It then covers topics related to configuration, service broker, CLR integration, security & change management. These topics are so vast in themselves that one should not expect a very detailed coverage, although, the authors have made sure the reader gets enough knowledge to be able to go off their own. What I liked most about this book is its coverage of topics related to performance tuning & optimization. There are at least 3-4 chapters which are very detailed and informative. I'm sure beginner & intermediate DBAs will hugely benefit from this. The authors have also covered the regular topics related to replication, clustering, backup/restore, log shipping, database mirroring etc.
There is also a small chapter on SQL Azure administration & configuration. The much hyped SQL Server 2012 feature of AlwaysOn also gets its own chapter in the book too.
Finally, the book does not miss out on covering the reporting services, analysis service, integration services & sharepoint integration.
To summarize, I think the book does justice to its size(around 900 pages). It provides crisp and concise information related to basics & specialized topics. However, it does leave a lot to be explored by a DBA on his own. For a huge product like SQL Server, even several volumes might not be able to cover all.
I recommend this book to my fellow DBAs. Go for it.....
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Clay Blakely on December 16, 2012
Format: Paperback Verified Purchase
I bought this book to prepare for the 70-462 exam. This was to be the book to give me a strong base knowledge and I bought another one that was to be more exam centric. This book did exactly what I wanted and more. It should be on every DBAs shelf. I have read it once all the way through and would like to find time to take another pass sitting in front of a computer to test the examples to get the most out of it. I will definitely keep it as a reference.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Carlos O. Cuevas P. on April 17, 2013
Format: Kindle Edition Verified Purchase
This book has all the relevant information I needed, wanted and dreamed for. I'm not a (formal) DBA. I bought this book with the idea of learning how to setup high availability on my servers. It gave me not only how to setup my server and explain every scenario, but also tips to prepare my apps for the high availability, examples of how to prepare the jobs, and many more.

"All the scripts I tried worked!!!!". I used one chapters examples for setting up my servers, I just needed to change what I obviously had to change (paths, and stuff), and it worked seamless. (I have to say, I got the Kindle Edition). This is the first book I got without errors in its examples.

(Spanish speaker, sorry for the errors)
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Ian Stirk on December 16, 2013
Format: Paperback
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

This is a big book, with a very broad coverage of topics discussed over its 25 chapters. This fact itself tells you there is much more to SQL Server 2012 than simply T-SQL. As you might expect given the `professional' moniker of the title, this is not a book for beginners. Instead it is aimed at experienced DBAs and SQL developers.

Below is a chapter-by-chapter exploration of the topics covered.

Chapter 1 SQL Server 2012 Architecture
The chapter begins with an overview of the different types of admin users (production, development, business intelligent DBAs, and SQL developers) and the new features each may want to investigate. The underlying physical architecture is described in terms of database files, logs, filegroups and pages.

The various system databases are briefly described:
*resource database: contains critical internal system tables, metadata, and routines
*master database: contains metadata about the application databases
*tempdb: contains temporary objects and row versioning information
*model database: used as template when creating new application databases
*msdb database: contains a miscellany of information including SQL Agent job details, backup/restore data, and log shipping information

A miscellany of topics follows. The concept of schemas is discussed, as is synonyms. A long list of the various groups of Dynamic Management Views (DMVs) is given and briefly discussed. Various data types and their ranges/values are detailed.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Amazon Customer on September 4, 2013
Format: Paperback Verified Purchase
Author has done a nice job describing topics. It is good beginner as well as intermediate book. There are a lot of scripts present in the book. Book does not assume any prior knowledge of the subject. For more advanced users: you can always pick up a trick or two. My feeling is that this book is geared to entry level people as well as early juniors. There are also some nice senior level examples. There is a lot of descriptive content like backup strategies and other topics. These descriptive parts are geared toward someone who never had any exposure to the subject. For me it was just a refresher reading. It was nice to work through scripts and see the logic behind them. Overall, this is good book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Professional Microsoft SQL Server 2012 Administration
This item: Professional Microsoft SQL Server 2012 Administration
Price: $29.76
Ships from and sold by Amazon.com

Want to discover more products? Check out this page to see more: sql server