The SQL Server Dba's Guide to Docker Containers: Agile Deployment Without Infrastructure Lock-In

ISBN-13: 9781484258255 / Angielski / Miękka / 2020 / 347 str.

Edwin Sarmiento

Opis

Intermediate-Advanced user level

Spis treści

1. Introduction to Containers

2. Install and Configure Docker on Windows Server 2016

3. Install and Configure Docker on Linux

4. The Docker Ecosystem

5. Docker Images and Containers

6. Managing and Administering Containers

7. Persisting Data

8. Working with SQL Server on Linux

9. Creating Custom SQL Server on Windows Container Images

10. Creating Custom SQL Server on Linux Container Images

11. Guide to Docker Networking for SQL Server DBAs

12. Appendix A. Building a Personal Lab Environment

O autorze

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.

Blurb

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.

You will:

• 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