Category Archives: SQLServerPedia Syndication

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 | 1 Comment

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

PASS BA Conference 2014: Sessions Recordings Now Available

All PASS Business Analytics Conference 2014 recordings are now available.  If you purchased the online sessions, to view, log on to your myPASS account, enter your activation code, and watch the sessions from myRecordings.  You can also purchase all recordings on a USB … Continue reading

Posted in PASS, SQLServerPedia Syndication, Videos | Leave a comment

Presentation slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” for Pragmatic Works last Thursday.  The abstract for my session is below and the recording is available here.  I hope you enjoyed it. Here is the PowerPoint presentation: Modern Data Warehousing Modern Data Warehousing The … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Presentation slides for Houston SQLSaturday

Thanks to everyone who attended my two sessions at SQLSaturday in Houston (more info).  Here are the abstracts and PowerPoint links: Best Practices to Deliver BI Solutions If your company is planning to build a data warehouse or BI solution, you … Continue reading

Posted in Business Intelligence, Career, Presentation, Session, SQLServerPedia Syndication | 1 Comment

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics conference.  The abstract is below.  I hope you enjoyed it! Here is the PowerPoint presentation: Building an Effective Data Warehouse Architecture Building an Effective Data Warehouse Architecture … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

SQLSaturday in Houston

This upcoming Saturday I will be presenting two sessions at SQLSaturday in Houston (more info).  I hope to see you there.  Here are the abstracts: Best Practices to Deliver BI Solutions If your company is planning to build a data … Continue reading

Posted in Presentation, Session, SQLServerPedia Syndication | Leave a comment

Hadoop and Data Warehouses

I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution.  Hadoop should not be a replacement for a data warehouse, but rather should augment/complement a data warehouse.  Hadoop and a data warehouse … Continue reading

Posted in Data warehouse, Hadoop, PDW, SQLServerPedia Syndication | 2 Comments

Presentation Slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas.  The abstract is below.  Great turnout for the last session of the day! Here is the PowerPoint presentation: Modern Data Warehousing Modern Data Warehousing The traditional … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” on Saturday at the PASS SQLSaturday Business Analytics edition in Dallas at 4:30pm CST (info).  The abstract for my session is below.  I hope you can make it! Modern Data Warehousing The traditional … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment