Professional Microsoft SQL Server 2014 Administration and over 2 million other books are available for Amazon Kindle . Learn more
£22.22
  • RRP: £36.99
  • You Save: £14.77 (40%)
FREE Delivery in the UK.
Only 3 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Professional Microsoft SQ... has been added to your Basket
Trade in your item
Get a £5.66
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Professional Microsoft SQL Server 2014 Administration Paperback – 14 Oct 2014

1 customer review

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£22.22
£18.87 £25.16
£22.22 FREE Delivery in the UK. Only 3 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Frequently Bought Together

Professional Microsoft SQL Server 2014 Administration + Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) + Microsoft SQL Server 2014 Query Tuning & Optimization
Price For All Three: £73.75

Buy the selected items together


Trade In this Item for up to £5.66
Trade in Professional Microsoft SQL Server 2014 Administration for an Amazon Gift Card of up to £5.66, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 936 pages
  • Publisher: John Wiley & Sons; 1 edition (14 Oct. 2014)
  • Language: English
  • ISBN-10: 1118859138
  • ISBN-13: 978-1118859131
  • Product Dimensions: 18.8 x 4.3 x 23.6 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 71,169 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

Review

If you want a good, wide ranging, general SQL Server 2014 administration book, I can certainly recommend this book (I Programmer, October 2014)

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.


Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5.0 out of 5 stars
5 star
1
4 star
0
3 star
0
2 star
0
1 star
0
See the customer review
Share your thoughts with other customers

Most Helpful Customer Reviews

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 book aims to give a professional understanding of a very broad range of administration topics, how does it fare?

This is a big book, with a very broad coverage of topics discussed over its twenty-five chapters. This fact itself tells you there is much more to SQL Server 2014 than simply T-SQL. The ‘professional’ moniker of the title purports 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 2014 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 and enhanced 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.
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

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 7 reviews
7 of 7 people found the following review helpful
A very good and wide-ranging SQL Server 2014 admin book 30 Sept. 2014
By Ian Stirk - Published on Amazon.com
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 book aims to give a professional understanding of a very broad range of administration topics, how does it fare?

This is a big book, with a very broad coverage of topics discussed over its twenty-five chapters. This fact itself tells you there is much more to SQL Server 2014 than simply T-SQL. The `professional' moniker of the title purports 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 2014 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 and enhanced 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. Creating your own data types and routines with the Common Language Runtime (CLR) is outlined. Feature lists for the various editions of SQL Server are given for comparison purposes. Lastly, licensing is featured, the big difference being previously it was socket-based but is now core-based, so potentially more expensive.

This chapter feels awkward, since it contains a wide range of topics, with sufficient depth for an introduction, but they are only loosely tied together. There are some good lists that could be useful for future reference. I was a little surprised the fashionable DevOps role wasn't mentioned.
.
.
.
Conclusion

This book has a very wide scope. It is generally easy to read, with a good balance between theory and step-by-step example walkthroughs, together with good use of screenshots. Most chapters have sufficient detail to take you from level 3 expertise to level 7 or 8 expertise (based on a 1 to 10 scale).

Although many topics are covered, it some ways the book felt lightweight - this is not really a fault of the book, rather that SQL Server 2014 is a big product (each chapter could probably be expanded to a whole book itself). I was a bit surprised any link between SQL Server and Big Data wasn't explored/advertised.

The physical grouping of chapters could have been better, with all related chapters being placed together (e.g. why is AlwaysOn not adjacent to the other High Availability chapters?). The various monitoring tools could have been explained in one chapter and referenced repeatedly. Additionally, an overview of the content of each group of chapters would have put the content into context, and prevented some repetition.

The links between the chapters could have been better, there are several areas where cross referencing of information would have been useful. This might have occurred because different authors were used to write the different chapters, but better editing should have compensated for this.

This book is very similar to the 2012 edition of the book, while the screenshots have been updated for 2014, the text is perhaps 85% the same or similar. It could be argued there's no need to change a winning approach.

Although written for 2014, much is applicable to 2012 and 2008. If you want a good, wide ranging, general SQL Server 2014 administration book, I can certainly recommend this book.
3 of 3 people found the following review helpful
Not bad; plenty of info; needs editing. 29 Mar. 2015
By Yet another music geek - Published on Amazon.com
Format: Paperback Verified Purchase
This book needs editing.. I've seen paragraphs that seemed to be missing a sentence, sentences I could not make heads or tails of (and I've been a DBA on MS SQL Server, Oracle, and Sybase for over a decade), and one example that read, "Following are the three most important pillars..." followed by five bullet points. Heh. That said, it's a reasonably useful overview of MS SQL Server 2014, so if you can look past a flaw now and again, go for it.
A must have for your reference collection. 12 May 2015
By Harold A Jackson Jr - Published on Amazon.com
Format: Paperback Verified Purchase
Book is clear and examples are understandable.
1 of 2 people found the following review helpful
Five Stars 10 Nov. 2014
By Juan M. - Published on Amazon.com
Format: Kindle Edition Verified Purchase
Good!!!
1 of 3 people found the following review helpful
Great book 16 Oct. 2014
By Josh Luedeman - Published on Amazon.com
Format: Kindle Edition
I have found this book very informative and helpful when I hae needed to plag the role of an accidental DBA. This book is also helpin me close my skills gap with performance tuning. The book is logically organized and well written.
Were these reviews helpful? Let us know


Feedback