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.
2023-05-08 (first published: 2023-05-05)
5,104 reads
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,781 reads
Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.
2023-02-01
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, […]
2022-11-11
5,935 reads
2022-11-07
377 reads
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
2022-10-27 (first published: 2021-08-17)
15,952 reads
This article will show how you can use Azure Data Factory to check your data quality with an assertion.
2022-11-02 (first published: 2022-10-24)
3,844 reads
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
2022-06-03
4,299 reads
Learn about using the Script activity in Azure Data Factory to run DDL or DML statements.
2022-05-13
17,808 reads
2022-05-13
402 reads
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers