Fast Load Data To SQL Server Using Python

2020-06-092020-06-02 ~ jlmcdermott

Introduction There's plenty of good online material on how to insert data to SQL Server using python but most of it is aimed at OLTP type work loads. Essentially using the python modules pyodbc or sqlalchemy you can insert data from a CSV file to a table but you'll notice that each row is inserted … Continue reading Fast Load Data To SQL Server Using Python

Strategies for Staging Data to SQL

2020-06-032020-06-02 ~ jlmcdermott

Introduction Staging data is an important part of the ETL (or ELT) process. The general concept is this: before you bring your data into your database, data store, data mart or data warehouse, you need to pre-load it. This is the process of extracting and then loading before moving it on, otherwise known as “staging”. … Continue reading Strategies for Staging Data to SQL