stevemayne/jupyter-sqlserver repository overview

docker run  -p 8888:8888 -v ~/notebooks/:/home/jovyan/work stevemayne/jupyter-sqlserver

import pandas as pd
import pyodbc
import numpy as np
import matplotlib as plt
import getpass
%matplotlib inline
%load_ext sql

server = "x.x.x.x"
db = "my_db"
username = "my_username"
password = getpass.getpass("Database password? ")

conn = pyodbc.connect("Driver={sqlsrv};Server={%s};Database={%s};uid={%s};pwd={%s}" % (server, db, username, password))
sql = "Select * from TABLE"
data = pd.read_sql(sql, conn)

connection_string = "mssql+pyodbc://{username}:{password}@{server}/{db}?driver=sqlsrv".format(username=username, password=password, db=db, server=server)
%sql $connection_string
result = %sql SELECT * FROM TABLE
data = result.DataFrame()