Professional Microsoft SQL Server 2014 Administration und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
EUR 47,70
  • Alle Preisangaben inkl. MwSt.
Auf Lager.
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
Menge:1
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Dieses Bild anzeigen

Professional Microsoft SQL Server 2014 Administration (Englisch) Taschenbuch – 14. Oktober 2014


Alle 2 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
Taschenbuch
"Bitte wiederholen"
EUR 47,70
EUR 34,25 EUR 36,23
46 neu ab EUR 34,25 3 gebraucht ab EUR 36,23
Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Produktinformation


Mehr über die Autoren

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Pressestimmen

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

Buchrückseite

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.

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?

Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 3 Rezensionen
4 von 4 Kunden fanden die folgende Rezension hilfreich
A very good and wide-ranging SQL Server 2014 admin book 30. September 2014
Von Ian Stirk - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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.
1 von 1 Kunden fanden die folgende Rezension hilfreich
Five Stars 10. November 2014
Von Juan M. - Veröffentlicht auf Amazon.com
Format: Kindle Edition Verifizierter Kauf
Good!!!
1 von 3 Kunden fanden die folgende Rezension hilfreich
Great book 16. Oktober 2014
Von Josh Luedeman - Veröffentlicht auf 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.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.