Resources

Blogs I Read

http://blogs.msdn.com/b/dbrowne/
http://sqlcat.com/
http://cwebbbi.wordpress.com/
http://www.sqlbi.com/
http://sqlblog.com/blogs/jamie_thomson/
http://www.mattmasson.com/
http://sqlblog.com/
http://jenunderwood.com/
http://www.sqljason.com/
http://www.powerpivotpro.com/
http://www.timmitchell.net/

Books on my Kindle

Coming Soon

Presentation Materials

Presentation Slide Share Slides Demo
Building an Enterprise ETL Framework with SSIS 2012 Link SSIS Project
DB Project
Master Data Services 2012 Link
Get on Point with PerformancePoint Link
MDS: An Integrated Approach Link Link
Into the Wild…Taming Unstructured Data with Semantic Search Link Link  T-SQL Demo
Data Visualization  Link  Link  Link
Introduction to Mahout on HDInsight  Link  Link
The BI Guy’s Little Guide to Big Data  Link  Link
 Running with Elephants: Predictive Analytics with Mahout and HDInsight Link Link

10 thoughts on “Resources

  1. Chris, I really enjoyed your video on building out ETL Frameworks. I myself have written several versions of ETL frameworks that include reporting and a fairly comprehensive metadata repository. I have downloaded your demo project and have built out the database using the DDL script found in the project. I was wondering if you could provide a demo DML script that populates the various tables, so I can get a sense of what is needed to construct the metadata, and so I can demo the data based upon the packages provided in the project. Again, thank you an awesome demo. Keep up the good work.

  2. Hi Chris,
    I have downloaded SKIS framework 2012 and validated its very use full for me thanks lot for your all help. I am oldest member of Pragmatic Works and used see all FREE Training 🙂 ,I have some doubts and need clarification for that could your pls answer this ASAP.
    (1) It is good to have data in table [config].[Framework Codes] so we can understand all code and uses , its blank in Script which you have given , could you provide data/code with explanation for each code uses.
    (2) Is this framework can support SSIS in built Checkpoint as in this you have FOR EACH/Loops and Parallel process and as per my experience we cant use in built check point.

    (3) How we can use kind of check point in this framework, I could not understand how to use your customise checkpoint , unable to test it could you pls elaborate mor eon this and expain the meaning of R and A code type in tables, could you pls let me know how to use checkpoint, For example I hv 4 package and 3 ran and completed successfully and one failed so when I restart application ony third package should run.
    (4) How we can configure package to use sequential process let say I have 10 package and need to run from 1-10 order. And If any package fail in this I want to run that package with failure point DFD like we have 10 DFD in a package out of 10 only failure DFD should run.

    Thanks in advance for your quick response.

  3. Ahh… Skydrive was not accessible from office network. Downloaded at home. Cant wait to deep dive into it….

    Thanks for sharing your work!!!

  4. I was looking through the ETLFrameworkDB code, and I noticed some flags that appear to be redundant. In the config.Task table, there is a flag called IsActive and another called IsDisabled. I looked through the stored procedures to see how these two flags are used, and it appears that they are always used together and always to ensure that they are in opposite states. I noticed the same thing in regards to the IsEnabled and IsDisabled flags in the config.ApplicationSchedule tables. Am I missing something about these flags, or are they redundant and if so, is it fine to remove one of the flags in each table (and they’re usages throughout the stored procedures) without affecting how the framework runs?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s