Optimizing SQL Server Backup Performance

Description

This repository contains demos for the Apress video entitled Optimizing SQL Server Backup Performance: Using Data Science Techniques to Solve a Classic DBA Dilemma.

Running the Demos

There are two ways of running the demos for this presentation: running them directly or as part of a Docker container.

Running Directly

To run the demos directly, you will need Jupyter Notebooks installed and the R kernel configured. I have some instructions on installing Jupyter + R on Windows and Jupyter + R on Linux which might be helpful.

Building a Docker Container

If you would prefer a Docker container which has Jupyter + R pre-installed, grab this repo and run the following commands inside the repository's root folder:

docker build -t optimizing-backups-apress .

After the image finishes building, run it with the following:

docker run -p 8888:8888 -e JUPYTER_ENABLE_LAB=YES optimizing-backups-apress

This will prompt you to connect to http://127.0.0.1:8888 (assuming you leave the port the same) and will pre-stage the notebooks and data.