Monthly Archives: July 2014

SQL Server Agent job steps vs SSIS

When doing ETL, you have the choice of using T-SQL or SSIS (see When to use T-SQL or SSIS for ETL).  If you decide T-SQL is the way to go and you just want to execute a bunch of T-SQL statements (individually … Continue reading

Posted in SQLServerPedia Syndication, SSIS | 2 Comments

IT books that should be on your shelf

I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting.  Below are my favorites: Data Warehouse Books: Ralph Kimball Books Building the Data Warehouse Corporate Information Factory DW 2.0 Mastering … Continue reading

Posted in Career, SQLServerPedia Syndication | 1 Comment