Peter A. Carter

Pro SQL Server 2022 Administration

A Guide for the Modern DBA

3rd ed.
Peter A. Carter
SOUTHAMPTON, UK
ISBN 978-1-4842-8863-4e-ISBN 978-1-4842-8864-1
© Peter A. Carter 2015, 2019, 2023
This work is subject to copyright. All rights are solely and exclusively licensed by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed.
The use of general descriptive names, registered names, trademarks, service marks, etc. in this publication does not imply, even in the absence of a specific statement, that such names are exempt from the relevant protective laws and regulations and therefore free for general use.
The publisher, the authors, and the editors are safe to assume that the advice and information in this book are believed to be true and accurate at the date of publication. Neither the publisher nor the authors or the editors give a warranty, expressed or implied, with respect to the material contained herein or for any errors or omissions that may have been made. The publisher remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

This Apress imprint is published by the registered company APress Media, LLC, part of Springer Nature.

The registered company address is: 1 New York Plaza, New York, NY 10004, U.S.A.

For Terri. My inspiration, my rock.

Acknowledgments

I want to say a big thank you to Ian Stirk for a great tech review. As always, the quality of this book is better because of his contribution to the project.

I would also like to thank Jonathan Gennick for the continued support and partnerial attitude that he has shown through this, and all of the projects that we have worked on together.

Credit goes to Chris Dent, who has helped me improve some of the PowerShell scripts within this book.

Finally, I need to thank Terri, without whom this edition of the book would probably never have been written. She has provided constant motivation and support through what has been a rather grueling schedule this year.

Table of Contents
Part I: Installation and Configuration1
Part II: Database Administration173
Part III: Security, Resilience, and Scaling Workloads351
Part IV: Performance and Maintenance677
About the Author
Peter Carter
is a SQL Server expert with over 15 years of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. He was awarded an MCC by Microsoft in 2011 to sit alongside his array of MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onward. Peter has written a number of books across a variety of SQL Server topics, including security, high availability, and automation.
 
About the Technical Reviewer
Ian Stirk
is a freelance SQL Server consultant based in London. In addition to his day job, he is an author, creator of software utilities, and technical reviewer who regularly writes book reviews for www.i-programmer.info.

He covers every aspect of SQL Server/Azure SQL and has special interest in performance and scalability. If you require help with your SQL Server systems, feel free to contact him at [email protected] or www.linkedin.com/in/ian-stirk-bb9a31.

 
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.142.135.4