
Enjoy fast, FREE delivery, exclusive deals and award-winning movies & TV shows with Prime
Try Prime
and start saving today with Fast, FREE Delivery
Amazon Prime includes:
Fast, FREE Delivery is available to Prime members. To join, select "Try Amazon Prime and start saving today with Fast, FREE Delivery" below the Add to Cart button.
Amazon Prime members enjoy:- Cardmembers earn 5% Back at Amazon.com with a Prime Credit Card.
- Unlimited Free Two-Day Delivery
- Instant streaming of thousands of movies and TV episodes with Prime Video
- A Kindle book to borrow for free each month - with no due dates
- Listen to over 2 million songs and hundreds of playlists
- Unlimited photo storage with anywhere access
Important: Your credit card will NOT be charged when you start your free trial or if you cancel during the trial period. If you're happy with Amazon Prime, do nothing. At the end of the free trial, your membership will automatically upgrade to a monthly membership.
Buy new:
$53.34$53.34
FREE delivery:
Monday, June 5
Ships from: Amazon.com Sold by: Amazon.com
Buy used: $12.21

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required. Learn more
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.


Professional Microsoft SQL Server 2014 Administration 1st Edition
Price | New from | Used from |
- Kindle
$33.00 Read with Our Free App - Paperback
$12.21 - $53.34
Purchase options and add-ons
Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes.
- Improve oversight with better management and monitoring
- Protect your work with enhanced security features
- Upgrade performance tuning, scaling, replication, and clustering
- Learn new options for backup and recovery
Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work.
- ISBN-101118859138
- ISBN-13978-1118859131
- Edition1st
- PublisherWrox
- Publication dateSeptember 9, 2014
- LanguageEnglish
- Dimensions7.4 x 1.8 x 9.2 inches
- Print length936 pages
Frequently bought together

Customers who bought this item also bought
Editorial Reviews
From the Inside Flap
Best practices for administering SQL Server 2014, from Microsoft MVPs
This comprehensive guide teaches the skills needed to successfully administer SQL Server, including change management, security, performance tuning, monitoring, and backups. Written by the leading authorities on Microsoft SQL Server, this book will help you master the latest features of the 2014 release, including greater integration of cloud and on-premises management using SQL Server Management Studio, enhanced performance optimization, new cardinality estimator, and new features for AlwaysOn availability groups. This comprehensive guide will help you improve the efficiency, scalability, and performance of the SQL Server environment so more can be done in less time.
Professional Microsoft SQL Server 2014 Administration:
- Provides an overview of SQL Azure and new features for AlwaysOn availability groups
- Explains In-Memory OLTP and buffer pool extensions for SSDs and performance optimizations for 2014
- Details the new cardinality estimator (Query Optimizer) in SQL 2014
- Discusses the separation of duties and important regulatory requirements for security roles
- Provides real-world case examples and solutions
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, e-books, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
From the Back Cover
Best practices for administering SQL Server 2014, from Microsoft MVPs
This comprehensive guide teaches the skills needed to successfully administer SQL Server, including change management, security, performance tuning, monitoring, and backups. Written by the leading authorities on Microsoft SQL Server, this book will help you master the latest features of the 2014 release, including greater integration of cloud and on-premises management using SQL Server Management Studio, enhanced performance optimization, new cardinality estimator, and new features for AlwaysOn availability groups. This comprehensive guide will help you improve the efficiency, scalability, and performance of the SQL Server environment so more can be done in less time.
Professional Microsoft SQL Server 2014 Administration:
- Provides an overview of SQL Azure and new features for AlwaysOn availability groups
- Explains In-Memory OLTP and buffer pool extensions for SSDs and performance optimizations for 2014
- Details the new cardinality estimator (Query Optimizer) in SQL 2014
- Discusses the separation of duties and important regulatory requirements for security roles
- Provides real-world case examples and solutions
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, e-books, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
About the Author
Adam Jorgensen is the President of Pragmatic Works and the Executive Vice President of PASS with more than 15 years experience.
Bradley Ball is a MCITP 2005, 2008, and 2012 MCSE DBA with more than a decade of experience who is currently the Data Platform Management Lead with Pragmatic Works specializing in Data Platform solutions.
Steven Wort has been working with SQL Server since 1993, who joined Microsoft in 2000, and now works as an Architect in the CRM Service Engineering team.
Ross LoForte is a Technology Architect at the Microsoft Technology Center Chicago focused on Microsoft SQL Server solutions, with more than 20 years of business development, project management, and SQL experience.
Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpStartTV.com
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Product details
- Publisher : Wrox; 1st edition (September 9, 2014)
- Language : English
- Paperback : 936 pages
- ISBN-10 : 1118859138
- ISBN-13 : 978-1118859131
- Item Weight : 3.34 pounds
- Dimensions : 7.4 x 1.8 x 9.2 inches
- Best Sellers Rank: #1,808,098 in Books (See Top 100 in Books)
- #155 in Microsoft SQL Server
- #504 in Database Storage & Design
- #1,164 in Cloud Computing (Books)
- Customer Reviews:
About the authors
Adam Jorgensen is the President of Pragmatic Works and a Director at large for the Professional Association of SQL Server. As a Microsoft SQL Server MVP he has extensive experience with SQL Server, SharePoint and analytics over the past 13 years. His focus is primarily on helping organizations and executives drive value through new technology solutions, management techniques and financial optimization. He is especially focused in the areas of OLAP, Cloud and Big Data and working on solutions to make those technologies real for the enterprise.
He regularly speaks in person and virtually at industry group events, major conferences, Code Camps, and SQL Saturday events on strategic and technical topics. He has co-authored white papers and books on business intelligence, among other topics.
Prior to his work with Pragmatic Works, Adam garnered extensive technical and managerial experience in industries including automotive, manufacturing, software, education, security, and retail. He has delivered high performance, highly available systems as well as niche specialty systems for a variety of clients around the world. These systems deliver critical operations and analytics for firms like Toyota Motor Company, Dealer Track, American Auto eXchange, NASDAQ, Goldman Sachs, Deutsche Bank, Clipper Wind Power, Rayonier, and Microsoft.
Discover more of the author’s books, see similar authors, read author blogs and more
Discover more of the author’s books, see similar authors, read author blogs and more
Discover more of the author’s books, see similar authors, read author blogs and more
Bradley Ball is a MCITP SQL 2005 & MCTS 2008 DBA with over 10 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States. He is currently a Sr. Consultant with Pragmatic Works specializing in DBA and BI solutions. He has presented at many SQL Saturdays, for the MAGICPASS & OPASS SSUG’s, SQL Rally 2011 & 2012, DevConnections 2012 and at the PASS Summit in 2012 & 2011. Bradley can be found blogging on http://www.sqlballs.com
Customer reviews
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on Amazon
Reviewed in the United States on May 16, 2016
-
Top reviews
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
Top reviews from other countries

I came across quite a few errors in the topics I know well.
I estimate that I could easily submit 100 or more errata items of varying degrees of importance.
That doesn't inspire confidence that the topics I don't know are covered accurately.
It is surprising that it is possible for a book with 5 authors and 3 technical editors to contain so many issues




Kaufgrund war: eines der wenigen Büchern, wo auf In-Memory-OLTP angegangen wird. Zwar fehlt, wie anscheinend überall, die Beschreibung, wie das alles auf die Platte gespeichert wird, ABER die Grundlagen werden gut erklärt, ebenso die Hash- und Range-Indexes.
Das Buch ist nicht schlecht! Besteht meistens aus Copy-Paste von MS-Doku, ABER hier hat man das Ganze in eine Struktur gebracht und in die Kapiteln aufgeteilt; plus kommt an mehreren Stellen ein oder anderer wertvolle Tipp aus der Praxis dazu.
Aber Vorsicht: es wurde hier mit Copy-Paste nicht ganz sorgfältig gearbeitet, daher - wenn etwas unschlüssig erscheint, gleich in der Online-Doku das Thema nachschlagen, da kommt der eine oder andere entscheidende Satz dazu! Betrifft bspw. auch In-Memory-OLTP, wo MS-Tipp, beim Resource Governor-Pool auch "MIN_MEMORY_PERCENT" zu setzen, im Buch nicht mehr auffindbar ist.
Fazit: sehr nützlich als Überblick und Gedankenstütze für einen erfahrenen Admin! Skripte meist trivial von Funktion, aber referenzieren oft nützliche DMVs, manchmal auf eine unerwartete Weise, und bringen einen auf neue Gedanken. Als umfassende Referenz für einen Laien eher ungeeignet.
44 Euro sind m. M. hier gut angelegt.