How Effective Is Your Data Load Monitoring in SQL and Python?
Learn how you can use monitor your data warehouse load process with Python code and a structured process.
2023-09-20
1,127 reads
ETL
Upserts in Amazon Redshift
This article discusses different approaches of Upserts (update+inserts) in Amazon Redshift
2023-08-09
3,710 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,258 reads
ETL Performance Auditing - Part 1: Introduction to ETL Auditing
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2018-07-17 (first published: 2012-06-05)
18,325 reads
Blogs
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Common Mistakes in SQL Server – Part 2
The Identity property creates an incremental value for the specified column automatically, which is...
Forums
Identifying the process that is backing the databases to virtual device
We have about 20 SQL Servers. We use Net backup or Native backup for...
SQL Migration - Identifying Connections - Best approach
I have one SQL Database server which is old version and planning to migrate...
Restore With Standby; A Review and A Lesson Learned
Comments posted to this topic are about the item Restore With Standby; A Review...
Ask SSC