Chmel Marek - SQL Server 2017 administrators guide: one stop solution for DBAs to monitor, manage, and maintain enterprise databases

Marek Chmel

Vladimr Mun

BIRMINGHAM - MUMBAI

Copyright 2017 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: December 2017

Production reference: 1081217

ISBN 978-1-78646-254-1

www.packtpub.com

Marek Chmel is an IT consultant and trainer with more than 10 years of experience. He's a frequent speaker who specializes on Microsoft SQL Server, Azure, and security topics. Marek writes for Microsoft's TechnetCZSK blog, and since 2012 he's been an MVP: Data Platform. Marek is also recognized as a Microsoft Certified Trainer: Regional Lead for Czech Republic for few years in a row, he holds many MCSE certifications, and on the top of that he's a ECCouncil Certified Ethical Hacker and holder of several eLearnSecurity certifications.

He earned his MSc (business and informatics) degree from Nottingham Trent University. He started his career as a trainer for Microsoft server courses. Later, he joined AT&T as a senior database administrator with a specialization in MSSQL Server, data platforms, and machine learning.

Vladimr Mun has been a freelance developer and consultant since 1997. His first steps with SQL Server were done on version 6.5 and from that times the working with all next versions of SQL Server has been never stopped.

Now Vladimir teaches Microsoft database courses and also participates on SQL Server adoption in companies and also on projects for production tracking and migrations.

SQL Server 2017 Administrator's Guide is his first attempt to share his knowledge and experience with people around the world, but writing is a strong drug and if possible, Vladimir is interested to share other namely his development experiences with others.

Toma Katrun is an SQL Server developer and data analyst with more than 15 years of experience in the field of business warehousing, development, ETL, database administration, and query tuning. He also has more than 15 years of experience in data analysis, data mining, statistical research, and machine learning. He is a Microsoft SQL Server MVP for data platform and has been working with Microsoft SQL Server since version 2000. Toma is a blogger, the author of many articles, the co-author of a statistical analysis book, a speaker at communities and Microsoft events, and an avid coffee drinker.

For support files and downloads related to your book, please visit www.PacktPub.com . Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at service@packtpub.com for more details. At www.PacktPub.com , you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.

https://www.packtpub.com/mapt

Get the most in-demand software skills with Mapt. Mapt gives you full access to all Packt books and video courses, as well as industry-leading tools to help you plan your personal development and advance your career.

• Fully searchable across every book published by Packt
• Copy and paste, print, and bookmark content
• On demand and accessible via a web browser

Thanks for purchasing this Packt book. At Packt, quality is at the heart of our editorial process. To help us improve, please leave us an honest review on this book's Amazon page at https://www.amazon.com/dp/1786462540 .

If you'd like to join our team of regular reviewers, you can email us at customerreviews@packtpub.com. We award our regular reviewers with free eBooks and videos in exchange for their valuable feedback. Help us be relentless in improving our products!

SQL Server is a very complicated set of end-to-end data processing technologies, and its correct functioning is crucial for every business. This book leads the reader through all the substantial topics a good administrator has to know in a professional job of provisioning, securing, maintaining, and monitoring SQL Server.

, Setting Up SQL Server 2017, is a reader's guide through the SQL Server installation process. This chapter also covers all the prerequisites needed for a successful installation of SQL Server. Overview of the SQL Server technology set is also provided in order to show the reader which services and features are used for particular tasks.