Non-obvious APS/PDW benefits

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has a lot of obvious...

IaaS, PaaS, and SaaS explained

You might be reading a lot about Cloud computing and see three acronyms frequently: IaaS, PaaS, Saas.  Cloud providers offer...

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...

Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...

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...

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). ...

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....

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...

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...

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...