Data warehousing is being used more and more everyday and longtime data warehouse DBA Janet Wong brings us a short look at
her first project and some thoughts about warehousing in general.

oPASS User Group

by Press Release

SQLServerCentral.com

User Groups

The Orlando Area User Group is reforming. Read about the new site.

Introduction to Data Warehousing Part 1

by Additional Articles

JumpStartTV

Design and Theory

In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.

SQLServerCentral.com Site Migration

by Steve Jones

SQLServerCentral.com

SQLServerCentral

A short look and some notes from the SQLServerCentral.com site migration.

Mastering Enterprise BI: Time Intelligence Pt. II

by Additional Articles

Database Journal

Design and Theory

BI Architect Bill Pearson continues his introduction to enhanced features in Analysis Services 2005 for Time Intelligence support. In this session, we examine new, wizard-driven features that support the easy addition of Time Intelligence within our cube.

Designing A Data Warehouse: Part 1 Dimension Types

by Additional Articles

JumpStartTV

Design and Theory

In this first part of a multiple part series, Brian Knight shows the different types of slowly changing dimensions you'll use and the business reason for using each type.

Different forms of CrossJoin

by Additional Articles

MSDN Communities

This article is about different syntactical ways to write CrossJoin in MDX, all of which are completely equivalent from the functional and performance standpoint. Therefore, the article doesn't convey any practical information, and can be ignored. Readers curious about history of MDX can keep reading, however.