Marek Chmel - SQL Server 2019 Administrators Guide: A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions, 2nd Edition

A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions

Marek Chmel

Vladimir Muzny

BIRMINGHAMMUMBAI

Copyright 2020 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 or its dealers and distributors, will be held liable for any damages caused or alleged to have been 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.

Commissioning Editor: Sunith Shetty

Acquisition Editor: Devika Battike

Senior Editor: Roshan Kumar

Content Development Editor: Tazeen Shaikh

Technical Editor: Sonam Pandey

Copy Editor: Safis Editing

Project Coordinator: Aishwarya Mohan

Proofreader: Safis Editing

Indexer: Pratik Shirodkar

Production Designer: Jyoti Chauhan

First published: December 2017

Second edition: September 2020

Production reference: 1110920

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham

B3 2PB, UK.

ISBN 978-1-78995-432-6

www.packt.com

To my family, friends, colleagues, students, and readers.

Vladimir Muzny

Thanks to my family for continuous support, and to my friends and colleagues for their inspiring ideas and insights.

Marek Chmel

Packt.com

Subscribe to our online digital library for full access to over 7,000 books and videos, as well as industry leading tools to help you plan your personal development and advance your career. For more information, please visit our website.

• Spend less time learning and more time coding with practical eBooks and Videos from over 4,000 industry professionals
• Improve your learning with Skill Plans built especially for you
• Get a free eBook or video every month
• Fully searchable for easy access to vital information
• Copy and paste, print, and bookmark content

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 packt.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at customercare@packtpub.com for more details.

At www.packt.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.

Marek Chmel is a senior cloud solutions architect at Microsoft for data and artificial intelligence, a speaker, and a trainer with more than 15 years' experience. He's a frequent conference speaker, focusing on SQL Server, Azure, and security topics. He has been a Data Platform MVP since 2012. He has earned numerous certifications, including MCSE: Data Management and Analytics, Azure Architect, Data Engineer and Data Scientist Associate, EC Council Certified Ethical Hacker, and several eLearnSecurity certifications. Marek earned his MSc degree in Business and Informatics from Nottingham Trent University. He started his career as a trainer for Microsoft courses and later worked as principal sharepoint administrator and principal database administrator.

Vladimir Muzny has been a freelance developer and consultant since 1997. He has been a Data Platform MVP since 2017, and he has earned certifications such as MCSE: Data Management and Analytics and MCT. His first steps with SQL Server were done on version 6.5, and from that time on, he has worked with all following versions of SQL Server. Now Vladimir teaches Microsoft database courses, participates in SQL Server adoption at various companies, and collaborates on projects for production tracking and migrations.

I would like to thank my loving and patient family for their continued support, patience, and encouragement throughout the long process of writing this book.

Toma Katrun is an SQL Server developer and data scientist with more than 15 years of experience in the fields of business warehousing, development, ETL, database administration, and query tuning. He also holds 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. Tomaz is a blogger, an author of many articles, a frequent speaker at community and Microsoft events, an avid coffee drinker, and is passionate about fixed gear bikes.

Arjun Sivadasan has over 12 years of experience working in various data-focused roles, developing and maintaining mission-critical applications in transactional and analytical environments. After completing his bachelor's in computer science engineering at Kerala University, he started his career as a full-stack developer in Bangalore and soon switched focus to databases. He has since tried to gain expertise in all aspects of data management. He presently works as a data architect for a global product company based in Sydney, Australia. Arjun is passionate about Microsoft data products. He is also an avid blogger and speaks at local user groups. In his spare time, he likes to cook meals for his wife or explore the world on two wheels.

If you're interested in becoming an author for Packt, please visit authors.packtpub.com and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea.