Posts Tagged Data Engineering

Moving Data from Snowflake to SQL Server

Posted December 22, 2021 Data Engineering

Moving data out of a warehouse is a less-conventional approach, but sometimes it's necessary. Here's how I pulled a large amount of data out of Snowflake to use in SQL Server.

Comparing Data Engineering Processes

Posted December 20, 2021 Data Engineering

ETL, ELT and more: What options are there and when do they work best?

Searching Across Tables In SQL Server

Posted October 12, 2021 (Revised October 24, 2021) SQL ServerData Engineering

I recently had to search many tables for a list of values in SQL Server. Here's how I used dynamic SQL to achieve the result I needed.