Docker Part 2: SQL Server Development And Testing

Explore SQL Server development and testing by spinning containers in seconds to deploy databases across Linux, Windows, and Mac environments, using Docker Compose for multi-server setups.

Discover how to install SQL Server 2017 and 2019 on premise, in cloud, and in Docker containers, using virtualization to test Eskil servers quickly with minimal resources.

Learn how to download the materials for this entire course from the downloadable materials zip file, including Word and PowerPoint documents. Extract the zip to access documentation for each video.

Demonstrate installing SQL Server 2019 developer edition on a desktop across Windows, Linux, and Docker, including downloading the ISO image, selecting the developer edition, and configuring multiple instances with SSMS.

Learn to install sql server 2017 on linux by setting up a linux vm with virtualbox, ubuntu, and cli steps, then compare resources and time and preview docker deployment.

Install sql server 2017 on a DigitalOcean cloud using an Ubuntu 16.04 droplet, connect via SSH with MobaXterm, and configure a test database accessible via SSMS.

Install sql server on mac with docker by installing docker desktop, pulling the sql server image, and running a container with accept eula and sa password.

Install docker on ubuntu and verify with docker version, testing with hello world. Learn to run Eskew server in docker for fast, resource-efficient testing on docker environments.

Install an eskew server on azure, create a resource group and a new server, configure a database, set up networking, manage costs, and connect via ssl-enabled sql tools.

Install sql server 2017 using Docker; compare speed and resource usage across environments; configure Docker run with end-user license agreement and sa password, and map port 14 33.

Demonstrate deploying multiple SQL Server 2017 containers from a single Docker image on a DigitalOcean droplet, with memory planning and unique ports, accessible via ssms and Eskew command line.

Explore migrating data from a Windows on-premise SQL Server to a Linux Docker container, and learn why containers are disposable and how to persist data for testing.

Demonstrate backing up and restoring a SQL Server database inside a docker container by pulling a world wide importers backup from GitHub and preparing it for restoration.

Restore sql server databases in docker by moving a world wide importers backup from host to container, verify restoration, run queries, update data, and practice replace backups.

Back up a SQL Server database on premise, migrate from Windows to Linux, then restore into a Docker container for testing.

Learn how to persist data in docker by using volumes that decouple storage from containers, enabling sql server databases to survive container deletion during testing.

Explore how docker volumes provide persistent SQL Server data across container restarts and deletions by mounting a volume to the container.

Use docker to test patching and upgrading SQL Server 2017 databases by upgrading from CU13 to CU17 in a disposable container, preserving data with volumes and avoiding prod backups.

demonstrates customizing a SQL Server base image to enable the SQL Agent by default, using a container, commit, and tag for repeatable deployments.

Push a customized Docker image to the hub repository and verify it by deleting containers and pulling the image back. Recreate environments quickly and share production ready images with colleagues.

Learn to create a custom sql server image from a production environment, migrate a backup to a linux container, restore it, and commit a reusable image for testing.

Learn to customize a sql server base image with a dockerfile, including a database script, building a multi-layer image, and running a container with multiple databases for testing.

Learn to customize a base SQL Server image using Docker Compose to run multiple containers with distinct ports, creating a two-container setup via a YAML file and ensuring proper indentation.

Build and run a sql server container from a predefined dockerfile with docker-compose, creating a develop database and a names table filled with sample data.

Learn how to use docker logs, tail the last lines, filter by status, and identify exited containers using docker ps and container IDs.

Learn to enable the SQL Server agent in a Docker container using the environment variable, then create and test a backup job with scheduling and restore verification.

Configure snapshot replication in Docker to support high availability by setting up a publisher, distributor, and subscriber to synchronize sales data, using Docker Compose for two SQL Server instances.

Learn to grant and revoke login permissions inside dockerized SQL Server containers, create and manage user Tom, test access, and securely control container-level security for testing environments.

Engage with the first quiz featuring multiple-choice questions and a hands-on mini project to practice docker commands. Review the provided answers at the bottom and reinforce learning through active execution.

Review docker commands for sql server containers: run in detached mode, set EULA and sa password, map ports, and stop, start, or restart containers; minimum 2 gb per instance.

Create two docker containers, list containers and images, and connect to them via IP and port to verify setup; if memory limits require, start with one container then add another.

learn to create two docker containers for sql server development, rename containers and adjust port numbers, then display, connect to images, and delete all containers as quiz 2 answer practice.

Create a docker container, build a sales database with an id and first name table, insert data, back up, and migrate the backup from Windows to Linux.

Execute docker-based SQL Server tasks by creating a container, connecting with SSMS, building a sales database with a names table, then back up and migrate the backup to Linux.

Explore seven color-coded commands in quiz 4 to create a container and back up the worldwide importers database, order the steps correctly, and execute to view the resulting results.

Walks through the correct docker workflow to set up a container, create a backup directory, copy a backup into the container, and verify the backup inside the container in sequence.

Explore docker based sql server development and testing by creating a persistent volume, launching a container with env variables, and setting up a database, table, sample row, and verify access.

Demonstrates creating a docker volume and running a container on port 1480, then creating a database and table, deleting and reattaching to verify volume persistence.

Learn to build and test a dockerized sql server setup by creating a docker file, a create dot ascii file, and a docker-compose.yaml to deploy accounts and finances.

Build a custom image from a dockerfile and initialize three databases with a script. Use docker compose to run a container and map ports for testing the sql server.

Finish up this Docker for DBAs course by learning how to create, test, backup and restore databases in Docker containers, and safely destroy droplets to avoid charges.