Skip to main content
SpringerLink
Log in
Apress

The SQL Server DBA’s Guide to Docker Containers

Agile Deployment without Infrastructure Lock-in

  • Book
  • © 2020

Overview

Authors:
  1. Edwin M Sarmiento

    1. Ottawa, Canada

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Provides guidance on Docker specifically tailored for SQL Server Administrators
  • Covers Docker-based deployments on both Windows Server and Linux platforms
  • Helps you build the right technical skills for modernizing database deployments

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (11 chapters)

  1. Front Matter

    Pages i-xxii
    Download chapter PDF

  2. Introduction to Containers

    • Edwin M Sarmiento
    Pages 1-8

  3. Install and Configure Docker on Windows Server

    • Edwin M Sarmiento
    Pages 9-18

  4. Install and Configure Docker on Linux

    • Edwin M Sarmiento
    Pages 19-38

  5. The Docker Ecosystem

    • Edwin M Sarmiento
    Pages 39-68

  6. Docker Images and Containers

    • Edwin M Sarmiento
    Pages 69-98

  7. Managing and Administering Containers

    • Edwin M Sarmiento
    Pages 99-131

  8. Persisting Data

    • Edwin M Sarmiento
    Pages 133-156

  9. Working with SQL Server on Linux

    • Edwin M Sarmiento
    Pages 157-198

  10. Creating Custom SQL Server on Windows Container Images

    • Edwin M Sarmiento
    Pages 199-227

  11. Creating Custom SQL Server on Linux Container Images

    • Edwin M Sarmiento
    Pages 229-268

  12. Guide to Docker Networking for SQL Server DBAs

    • Edwin M Sarmiento
    Pages 269-286

  13. Back Matter

    Pages 287-347
    Download chapter PDF
Back to top

Keywords

About this book

Get introduced to the world of Docker containers from a SQL Server DBA’s perspective. This book explains container technology and how it can improve the deployment of your SQL Server databases without infrastructure lock-in. You will be equipped with the right technical skills to guide stakeholders in your business as they adopt and adapt to new technologies to improve time-to-market and competitiveness. You will learn how to build a lab environment at home on which to build skills that transfer directly into your day job. 


This book teaches you how to install and configure Docker on both Windows Server and Linux operating systems. You will learn the most common Docker commands that you need to know as a DBA to deploy and manage SQL Server on containers. Support for SQL Server on Linux is new, and this book has your back with guidance on creating Docker images specifically for deployment to a Linux platform. Included is coverage of key Linux commands needed to manage SQL Server on that operating system. By the end of the book you will have learned how to create your own custom SQL Server container images with configuration settings that are specific to your organization, that are capable of being deployed to both Windows Server and Linux. 

What You Will Learn
  • Create Docker containers for agile deployment of SQL Server
  • Run multiple SQL Server instances on a single Linux machine
  • Deploy custom images specific to your organization’s needs
  • Know the benefits and architecture of container technology
  • Install and configure Docker on Windows Server and Linux 
  • Manage and persist SQL Server data in Docker containers



Who This Book Is For


Intermediate to senior SQL Server DBAs who are familiar with SQL Server on Windows and want to build their existing skills to deploy and manage SQL Server on Linux and through Docker containers. Readers should have a grasp of relational database concepts and be comfortable with the Transact-SQL language.


Authors and Affiliations

  • Ottawa, Canada

    Edwin M Sarmiento

About the author

Edwin M. Sarmiento is Managing Director of 15C, a consulting company that specializes in designing, implementing, and managing high-availability infrastructures. Proud of his heritage as a Filipino, Edwin now lives in Ottawa, Canada and specializes in high availability, disaster recovery, and system infrastructure. He is a former Microsoft Data Platform MVP of 12 years standing and is a Microsoft Certified Master for SQL Server. He is very passionate about technology, and has interests in music, neuroscience, social psychology, professional and organizational development, leadership, and management matters when not working with databases. Edwin strives continually to live up to his primary mission statement: To help people and organizations grow and develop their full potential.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation