How to configure a MSSQL database as a datasource

This guide is a space to discuss using Microsoft SQL Server (T-SQL, Transact SQL, MSSQL) with Great Expectations.

Incase anyone else runs into this: on mac while connecting to a local mssql server running on docker, I ended up needing to have my driver in the x+x+x+x format. Otherwise it would break the string in half.
mssql+pyodbc://username:password@127.0.0.1/ge-demo?driver=ODBC+Driver+17+for+SQL+Server&charset=utf&autocommit=true