Author: Jim Egan

Consolidating multiple repositories

Jim Egan focuses on the situation where a projects production environment uses multiple repositories. Read more

Should I have multiple production data services repositories?

Jim Egan explains why having multiple ETL Repositories can present problems. Read more

Monitoring disk space using an ETL job

To be proactive, I wrote a disk space monitoring job for my Data Services clients. This is specific to windows but could be...Read more. Read more

ETL performance tuning: Low hanging fruit

This setting tells Data Services how frequently to write to the monitor log. If you are actively watching the execution of a job the monitor log...Read more. Read more

The devil is in the (design) details

The issue that prompted this blog entry is that some years back when the system I’m working on was designed someone decided to declare columns...Read more. Read more

Number of Loaders in a Dataflow

If we can’t benchmark on data and hardware similar to production then we’ll need to have a better understanding of what the Dataflow is really doing and when certain... Read more