Jump to ratings and reviews
Rate this book

Pro SQL Server Administration

Rate this book
This book 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 all-new book taking up-to-date and modern approach that you'll want and need to further your career as a SQL Server database administrator.

In this book, you'll

Extensive coverage of hybrid cloud environments involving Azure SQL DatabaseDetailed discussions on all new, key features, including AlwaysOn and in-memory supportComprehensive coverage of key skills, such as monitoring, maintenance and indexing





What you'll learnCreate minimal installs on Windows Server Core in support of virtualization and corporate cloudsImprove performance through deployment of in-memory tables and columnstore indexesManage hybrid cloud environmentsMonitor SQL Server with Extended EventsAdminister indexes, including non-relational and columnstore indexesEmploy AlwaysOn to make your data highly-available, and to scale out reporting workloads

Who this book is forPro SQL Server Administration is for serious database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server. The book is especially useful to those managing hybrid cloud- and on-premise environments, especially involving Microsoft Azure.

450 pages, Kindle Edition

Published October 28, 2015

3 people are currently reading
2 people want to read

About the author

Peter Carter

78 books8 followers

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
0 (0%)
4 stars
0 (0%)
3 stars
2 (100%)
2 stars
0 (0%)
1 star
0 (0%)
No one has reviewed this book yet.

Can't find what you're looking for?

Get help and learn more about the design.