Introduces a %sql (or %%sql) magic. Connect to a database, using SQLAlchemy URL connect strings, then issue SQL commands within IPython or IPython Notebook. If no connect string is supplied, %sql will ...

You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.

The SQL Procedure Pass-Through Facility is an extension to the SQL procedure that enables you to send DBMS-specific statements to a database management system and to retrieve DBMS data directly.