Skip to content

Instantly share code, notes, and snippets.

View phillipsj's full-sized avatar

Jamie Phillips phillipsj

127 followers · 21 following
View GitHub Profile
@phillipsj
phillipsj / app.py
Created October 13, 2020 15:52
Dash Tutorial Imports
import dash
import dash_core_components as dcc
import dash_html_components as html
import plotly.express as px
import pandas as pd
from sqlalchemy import create_engine
@phillipsj
phillipsj / dashtutorial.sh
Created October 13, 2020 15:50
pip install --user pandas pyodbc dash sqlalchemy
$ pip install --user pandas pyodbc dash sqlalchemy
Successfully installed Flask-1.1.2 .......
@phillipsj
phillipsj / docker-list.sh
Last active September 22, 2020 00:29
Docker command to list Adventure Works container
$ docker container list
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
e07d0406ca31 adventureworks:2019 "/opt/mssql/bin/perm…" 46 seconds ago Up 44 seconds 0.0.0.0:1633->1433/tcp adventureworks2019
@phillipsj
phillipsj / docker-run.sh
Created September 22, 2020 00:27
Docker run command for Adventure Works database
$ docker run -p 1633:1433 --name adventureworks2019 -h adventureworks2019 -d adventureworks:2019
e07d0406ca31eda958c9ed2a830bf83fea3c9d15ba2c43870410766a40a112d6
@phillipsj
phillipsj / build-docker.sh
Created September 22, 2020 00:25
Bash build command
$ docker build -t adventureworks:2019
Sending build context to Docker daemon 334.3MB
Step 1/9 : FROM mcr.microsoft.com/mssql/server:2019-CU5-ubuntu-18.04
---Removed---
Processed 26344 pages for database 'AdventureWorks2019', file 'AdventureWorks2017' on file 1.
Processed 2 pages for database 'AdventureWorks2019', file 'AdventureWorks2017_log' on file 1.
RESTORE DATABASE successfully processed 26346 pages in 0.891 seconds (231.003 MB/sec).
Removing intermediate container 3cf414b336c4
---> 7420ec09d77c
Step 9/9 : CMD ["/opt/mssql/bin/sqlservr"]
@phillipsj
phillipsj / Dockerfile
Created September 22, 2020 00:25
FROM line for SQL Server
# Adventure Works Database on SQL Server 2019
FROM mcr.microsoft.com/mssql/server:2019-CU5-ubuntu-18.04
@phillipsj
phillipsj / Dockerfile
Created September 22, 2020 00:24
Setting environment variables for SQL Server
# Note: This isn't a secure password, and please don't use this for production.
ENV SA_PASSWORD=ThisIsAReallyCoolPassword123
ENV ACCEPT_EULA=Y
@phillipsj
phillipsj / Dockerfile
Created September 22, 2020 00:23
Setting mssql user
# Setting the user
USER mssql
@phillipsj
phillipsj / Dockerfile
Created September 22, 2020 00:22
Copy backup to restore command.
COPY AdventureWorks2019.bak /var/opt/mssql/backup/
@phillipsj
phillipsj / Dockerfile
Last active October 17, 2020 01:20
Run command for SQL Server restore.
# Launch SQL Server, confirm startup is complete, restore the database, then terminate SQL Server.
RUN ( /opt/mssql/bin/sqlservr & ) | grep -q "Service Broker manager has started" \
&& /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P ${SA_PASSWORD} -Q 'RESTORE DATABASE AdventureWorks2019 FROM DISK = "/var/opt/mssql/backup/AdventureWorks2019.bak" WITH MOVE "AdventureWorks2017" to "/var/opt/mssql/data/AdventureWorks2019.mdf", MOVE "AdventureWorks2017_Log" to "/var/opt/mssql/data/AdventureWorks2019_log.ldf", NOUNLOAD, STATS = 5' \
&& pkill sqlservr