vnegi10 / ms_sql_analysis

Pluto notebook for interacting with a MS SQL Server

MS_SQL_analysis

In this pluto notebook, an example is shown on how to connect to a MS SQL server on Linux using Julia.

Prerequisites

• SQL Server 2022

You need to have a SQL server running. Easiest way to set it up is via Docker. Instructions for SQL Server 2022 are given here.

• Microsoft ODBC driver 17 for Linux

Instructions are given here. I was unable to connect to the database using the newer driver 18, hence cannot recommend to use that one.

• sqlcmd utility (optional)

The sqlcmd utility lets you enter Transact-SQL statements, and is great to test if everything is working as expected. Follow instructions here.

How to use?

Install Pluto.jl (if not done already) by executing the following commands in your Julia REPL:

using Pkg
Pkg.add("Pluto")
using Pluto
Pluto.run() 

Clone this repository and open MS_SQL_notebook.jl in your Pluto browser window. That's it! You are good to go.