Dynamic ELT with Azure Data Factory - Part 3 of 3
In part 3 of this series, see how you can use the principles from the series to build an Azure Data Factory pipeline.
2023-01-25
5,535 reads
Sarah Dugan
Technical Considerations for Data Ingestion - Part 2
In part 2, we discuss the concepts of structure, tooling, and indexing for your data ingestion pipelines.
2023-01-18
2,705 reads
The Art of Data Ingestion - Part 1
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,972 reads
Dynamic ETL with SSIS
Learn how to dynamically load data from ETL load files using SSIS as a shell. The code downloads files from FTP, parses them and loads them into the database.
2013-05-03 (first published: 2010-10-19)
27,534 reads
Blogs
SQL Saturday NYC Recap 2025
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
Why Data Silos Hurt Your Business Performance
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Forums
SSPI handshake failed error code 0x80090311
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Need query help - MAX record
Hello - I have attached a Word document here with details about my issue....
Need query help - MAX record
I am having trouble writing linking the MAX query that I created back to...
Question of the Day
Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers