Pro SQL Server Administration
Pro SQL Server Administration
Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014. You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available.
Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an allnew book taking up-to-date and modern approach that you'll want and need to further your career as a SQL Server database administrator. Extensive coverage of hybrid cloud environments involving Azure SQL Database Detailed discussions on all new, key features, including AlwaysOn and in-memory support Comprehensive coverage of key skills, such as monitoring, maintenance and indexing .
Pro SQL Server Administration
Click here to readmore
Book Detail
Paperback: 1004 pages Publisher: Apress; 1st ed. edition (November 11, 2015) Language: English ISBN-10: 1484207114 ISBN-13: 978-1484207116 Product Dimensions: 7 x 2 x 10 inches
Read more
<disclaimer> I am a blogger, writing reviews about IT books, IT articles and anything I find interesting. I have received the book "Pro SQL Server Administration" from the publisher Apress.Com for a review, upon a request form my site. </disclaimer> I have always wanted to have a good, big Bible-like book for SQL Server (it's a weird dream), and finally I have obtained one for a review. The Pro SQL Server Administration has not disappointed me - it was one of the reasons I have obtained the MCP certificate in SQL Queries (461). Although I have mainly studied from other places, the book also deserves some credit for it. Let's start with the review - the book is 1004 pages, and it covers plenty of different well selected subjects. I have read part IV of the book - these are the chapters between 17 and 24, because I have considered those helpful for broader understanding of SQL Server and my MCP exam. Thus, these chapters would be reviewed. Chapter 18, Locking and Blocking has really helped me to understand these two terms (which are important part of the 461 exam). Extended Events (Chapter 19) and Triggers (Chapter 24) were helpful as well. What I liked from the book, was that in each chapter, there was a good mixture from SQL and picture material. The explanations were well written and understandable. The book would sit on my desk as a reference, hopefully for the next 2-3 years. Due to the fact, that I have obtained what I wanted from the book, and I have achieved my targets, I am giving it 5 stars!
thanks for reading