Connecting to an MS SQL database using pyodbc

pySQL.py

import pyodbc
import pandas as pd

#DDefine our connection parameters

con = pyodbc.connect(    
  r'DRIVER={SQL Server};'    
  r'server=server_address;'    
  r'database=database_name;'    
  r'uid=user_name;'    
  r'pwd=password'
)

#Establish the connection

cursor = con.cursor()


#Define an SQL query, The keyword TOP reads only the first ten items in the table 
#(Handy for not knocking over the server when testing

sql = """SELECT TOP 10 DoctorId, FirstName, LastName 

FROM Doctor 
"""

# Read the data from our query into a pandas dataframe
df = pd.read_sql_query(sql, con)