Ben HoustonThe flight of NASA's Artemis (purple) uses two very close encounters with the moon's gravity (green) to changes its trajectory to get back to the earth (blue.) Amazing.
More details: https://www.nasa.gov/artemis-1
Martin Höglund
- 52 Followers
- 159 Following
- 8 Posts
Train travelling SQL Server developer, DBA, Data Analyst with great interest in environmental topics and climate change.
@fb @GeekingTheThing Totally agree. We used SSIS for fetching data from db and file sources to landing database. Moving data is SSIS strength. The TL parts of ETL in (mostly) generated stored procedures for performance and much simpler debugging. Carefully think through the different load patterns you need and create templates for as many procs as possible. Keep hand coded business logic in separate procs. The orchestration of the execution was also done by metadata and SSIS.
@GeekingTheThing Or use BIML together with metadata model to build your SSIS packages? Source controlled templates and graphical GUI for those who wants that. Used it in a project with a lot of sources, moving functionality targets and a (more or less) fixed cut over date. Together with homegrown SQL templates for stored procedures in the ETL process we could faster adapt to changing requirements.
@dhmacher Not part of that row level funktion I hope?
Jan Wildeboer 😷
GrantschermWenn du in der Sekunde weißt, was das ist, hast du dein Hochschul-Studium bereits abgeschlossen.
