Posts Tagged Data Engineering
Moving Data from Snowflake to SQL Server
Posted December 22, 2021 Data EngineeringMoving 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 EngineeringETL, 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 EngineeringI 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.