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,019 reads
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,674 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,922 reads
2022-11-07
376 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,921 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,809 reads
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
2022-06-03
4,269 reads
Learn about using the Script activity in Azure Data Factory to run DDL or DML statements.
2022-05-13
17,647 reads
2022-05-13
402 reads
By Kevin3NF
Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...
By Steve Jones
I grabbed this book over the 2024 holiday season as it was on sale...
By Steve Jones
Investing small amounts of money over a long time works miracles, but no one...
Comments posted to this topic are about the item What is time?
Hello experts, The following SQL update is failing to install on some of our...
where to find information about xE sqlserver.databases_bulk_copy_throughput ? I'm searching for de description of...
Consider the following script for a Sql Server database with Compatibility Level at least 130 (Sql Server 2016):
create table tjson ( id int primary key, j1 varchar(max), j2 varchar(max), j3 varchar(max)); insert into tjson (id, j1, j2, j3) values (1, '[{"c11":"value11A", "c12":"value12A"},{"c11":"value11B", "c12":"value12B"}]', '[{"c21":"value21A", "c22":"value22A"},{"c21":"value21B", "c22":"value22B"}]', '[{"c31":"value31A", "c32":"value32A"},{"c31":"value31B", "c32":"value32B"}]');How many rows does the Query Optimizer estimate for the following query?
select id, c1.c11, c2.c21, c2.c22, c3.c31, c3.c32 from tjson cross apply openjson(j1) with( c11 varchar(50) '$.c11', c12 varchar(50) '$.c12') c1 cross apply openjson(j2) with( c21 varchar(50) '$.c21', c22 varchar(50) '$.c22') c2 cross apply openjson(j3) with( c31 varchar(50) '$.c31', c32 varchar(50) '$.c32') c3;See possible answers