SpringerLink (Online service) - Pro SQL Server on Linux Including Container-Based Deployment with Docker and Kubernetes

Pro SQL Serveron Linux Including Container-Based Deployment with Docker and Kubernetes Bob Ward Foreword by Slava OksPro SQL Server on LinuxIncluding Container-BasedDeployment with Dockerand KubernetesBob WardForeword by Slava OksPro SQL Server on Linux: Including Container-Based Deployment with Dockerand Kubernetes Bob Ward North Richland Hills, TX, USA ISBN-13 (pbk): 978-1-4842-4127-1 ISBN-13 (electronic): 978-1-4842-4128-8 https://doi.org/10.1007/978-1-4842-4128-8 Library of Congress Control Number: 2018962264 Copyright 2018 by Bob Ward This work is subject to copyright. All rights are reserved 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. Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights. While the advice and information in this book are believed to be true and accurate at the date of publication, neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or omissions that may be made.

The publisher makes no warranty, express or implied, with respect to the material contained herein. Managing Director, Apress Media LLC: Welmoed Spahr Acquisitions Editor: Jonathan Gennick Development Editor: Laura Berendson Coordinating Editor: Jill Balzano Cover image designed by Freepik (www.freepik.com) Distributed to the book trade worldwide by Springer Science+Business Media New York, 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail orders-ny@springer sbm.com, or visit www.springeronline.com. Apress Media, LLC is a California LLC and the sole member (owner) is Springer Science + Business Media Finance Inc (SSBM Finance Inc). SSBM Finance Inc is a Delaware corporation. For information on translations, please e-mail rights@apress.com, or visit www.apress.com/ rights-permissions.

Apress titles may be purchased in bulk for academic, corporate, or promotional use. eBook versions and licenses are also available for most titles. For more information, reference our Print and eBook Bulk Sales web page at www.apress.com/bulk-sales. Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the book's product page, located at www.apress.com/9781484241271. For more detailed information, please visit www.apress.com/source-code. Printed on acid-free paper This book is dedicated to all the people who have worked atMicrosoft over the last 25 years to build, ship, support,and market the SQL Server product.Table of Contents v Table of ConTenTs vi Table of ConTenTs vii Table of ConTenTs viii Table of ConTenTs ix Table of ConTenTs x Table of ConTenTs xi Table of ConTenTs xii Table of ConTenTs xiii About the AuthorBob Ward is a Principal Architect for the Microsoft SQL Server Data Services Group, which owns the development for all SQL Server versions.

Bob has worked for Microsoft for 25 years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2017 including Linux. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO), interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as SQL PASS Summit, SQLBits, SQLIntersection, Red Hat Summit, Microsoft Inspire, and Microsoft Ignite. You can find him on twitter at @bobwardms, read his blog posts at http://aka.ms/bobsql or http://aka.ms/sqlblog, or see his demos on http://aka.ms/ sqlchannel. xv About the Technical ReviewerAnthony Nocentino is the Founder and President of Centino Systems as well as a Pluralsight Author, a Microsoft Data Platform MVP, and SQL Server and Linux Expert. In his consulting practice, Anthony designs solutions, deploys the technology, and provides expertise on system performance, architecture, and security.

Anthony has a Bachelors and Masters in Computer Science, with research publications in machine virtualization, high performance/low latency data access algorithms, and spatial database systems. You can find Anthony on Twitter at @nocentino and his blog at www.centinosystems.com/blog/. xvii Acknowledgments There are so many I want to thank as part of my journey authoring this book. I would like to first give thanks and glory to my Lord and Savior Jesus Christ. My faith is the foundation of my life and I strongly believe God gives all of us our abilities. Next, I must call out my incredible wife, Ginger Ward, who has been so patient and encouraging throughout my authoring experience.

She has listened to all of my complaints, fears, joys, and put up with all of my late nights authoring this book. She made many long drives in the car on trips we made together, letting me work on pieces of the book in the passenger seat of her Land Rover. I also want to thank my two sons, Troy and Ryan Ward, who give me inspiration every day to be a husband, father, and man of conviction, responsibility, and integrity. There is no way I would have ever produced this book without Jonathan Gennick from Apress. Jonathan, thank you for taking a chance on this book and me when no other publisher would accept it. Speaking of people who made this book possible.

I have to call out the incredible job of Anthony Nocentino, my technical reviewer. Anthony brought to the table a vast knowledge of Linux and SQL Server, and without that Im not sure the book would be anything like the final version. Anthony also did an amazing job of turning around reviews quickly, even as we were meeting tight deadlines. What I loved the most about Anthonys style as a reviewer is that he was just as transparent calling out what he loved about the book as he did with pointed, truthful statements on what changes he thought needed to be made. Anthony, thanks for encouraging me throughout the entire journey. I also want to personally think Jill Balzano from Apress who kept me sane and organized during writing of the book, coordinating my writing with Anthony and Jonathans reviews.

Jill is not only nice but an amazing professional! I also want to thank several people at Microsoft who helped review parts of the book and were so kind and professional to answer my questions, including Slava Oks, Robert Dorr, Scott Konersmann, Pradeep M M, Jason Roth, Travis Wright, Prasad Tammana, Mihaela Blendea, Vin Yu, Rathijit Sen, Brian Gianforcaro, Jamie Reding, Patrick Kilfoyle, Mitchell Sternke, Dylan Gray, Suresh Kandoth, Parikshit Savjani, Pedro Lopes, Sourabh Agarwal, Sunil Agarwal, Brooks Remy, Arnav Singh, Denzil Ribero, Tejas Shah, Michal Primke, and Harini Gupta. xix aCknowledgmenTs I also want to thank my leaders at Microsoft, Rohan Kumar and Asad Khan, who have given me the blessed opportunity to evangelize and promote the technical aspects of SQL Server including Linux to the world. I also want to thank members of the Microsoft Marketing team who have worked with me along the way on building the right strategy to get the message out on SQL Server. Thank you John 'JG' Chirapurath, Ramnik Gulati, Debbi Lyons, Anshul Rampal, Marko Hotti, Matthew Burrows, Frederico Pravatta Rezende, Jane Gao, and Joe Malesich. I also want to thank some of the folks from Microsoft partner companies whom Ive worked with over the last year to talk about SQL Server on Linux, including Wendy Harms and Urs Renggli from HPE and Nicholas Gerasimatos from Red Hat. Finally, I want to thank the Project Helsinki team.