Category Archives: SQLServerPedia Syndication

Presentation slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” at the Central New Jersey SQL User Group yesterday.  The abstract for my session is below.  I hope you enjoyed it! Here is the PowerPoint presentation: Modern Data Warehousing Modern Data Warehousing … 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” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User Group at 6:30pm.  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

24 Hours of PASS videos online

All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free.  Check the session schedule for a complete list.  Also, many of the PASS virtual chapters have recordings of their meetings online.  Enjoy!

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

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

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