High-level wrapper around BCP for high performance data transfers between pandas and SQL Server. No knowledge of BCP required!!
pip install bcpandas