Category Archives: Data warehouse

PASS SQL Saturday in Chicago Presentation Slides

Posted on April 15, 2013 by

Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL Saturday in Chicago. Here are the PowerPoint presentation: What exactly is Business Intelligence? and Building an Effective Data Warehouse Architecture. What … Continue reading →

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

PASS Business Analytics Conference Presentation Slides

Posted on April 15, 2013 by

Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics Conference. Here are the PowerPoint presentations:  Overview of Microsoft Appliances and Building an Effective Data Warehouse Architecture. Overview of Microsoft Appliances … Continue reading →

Posted in Appliance, Data warehouse, PASS, Presentation, Session, SQLServerPedia Syndication | 2 Comments

Data Warehouse Architecture Presentation Slides

Posted on February 27, 2013 by

Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter.  There were over 200 attendees!  The recording of the session is available here. Here is the PowerPoint presentation: Building an Effective Data Warehouse Architecture Data Warehouse Architecture You’re a … Continue reading →

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

Data Warehouse Architecture Presentation

Posted on February 25, 2013 by

I will be presenting the session “Data Warehouse Architecture” this Wednesday, Feb 27th at 11:00am CST to the PASS DBA virtual chapter.  Below is the abstract.  It will be a remote presentation that you can join online.  Details are here.  This … Continue reading →

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

I’m presenting at the PASS SQL Saturday in Chicago

Posted on February 21, 2013 by

I have been selected to present at the SQL Saturday in Chicago on April 13th.  This works out nicely as the previous day I will be presenting the same session at the PASS Business Analytics Conference, so if you can’t make that … Continue reading →

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

PASS Business Analytics Conference Presentation

Posted on January 23, 2013 by

I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in Chicago on April 10-12.  Below is my presentation abstract along with more info about the conference.  My session will be on … Continue reading →

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

Data Warehouse Architecture Presentation Slides

Posted on November 14, 2012 by

Thanks to everyone who attended my “Data Warehouse Architecture” presentation to the South Florida PASS chapter. Here is the PowerPoint presentation: Data Warehouse Architecture Data Warehouse Architecture – comparing Kimball and Inmon methodologies You’re a DBA and your boss asks you to … Continue reading →

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

Data Warehouse Architecture Presentation

Posted on November 12, 2012 by

I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at 5:30PM CST.  Below is the abstract.  It will be a remote presentation that you can join online.  Details at South … Continue reading →

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

Data Warehouse vs Data Mart

Posted on May 14, 2012 by

I see a lot of confusion on what exactly is the difference between a data warehouse and a data mart.  The best definition that I have heard of a data warehouse is: “A relational database schema which stores historical data … Continue reading →

Posted in Data warehouse, SQLServerPedia Syndication | Leave a comment

Fast Track Data Warehouse Reference Guide for SQL Server 2012

Posted on May 2, 2012 by

I have previously blogged about Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances).  That was version 3.0 of the reference configuration that was for SQL Server 2008 R2.  Just released … Continue reading →

Posted in Data warehouse, Fast Track, SQLServerPedia Syndication | Leave a comment