ETL (Extract Transform and Load)

Technical Article

Python 3 Script for Generating SQL Insert Statements from CSV Data

  • Script

This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.

You rated this post out of 5. Change rating

2023-05-08 (first published: )

5,194 reads

SQLServerCentral Article

The Art of Data Ingestion - Part 1

  • Article

Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? There is of course data exporting as well, and in that case, […]

5 (8)

You rated this post out of 5. Change rating

2022-11-11

5,966 reads

Blogs

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

By

I have recently had the privilege of working with multiple clients who have been...

KDA: Echoes of Deception - Onboarding

By

I’ll walk through the KDA UI and tackle the first challenge before diving into...

Kusto Detective Agency - Intro

By

While I mostly write about SQL Server, I have a soft spot for Kusto....

Read the latest Blogs

Forums

2022 SSIS PackageFormatVersion?

By TG

Recently I upgraded my ssis package from 2016 to 2022, but package format version...

Meta AI by Facebook: A New Contender in the AI Battle

By Daniel Calbimonte

Comments posted to this topic are about the item Meta AI by Facebook: A...

Is SQL Server Feature Complete?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is SQL Server Feature Complete?

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers