The goal of the DBA Virtual Chapter is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.
Next Meeting

Wed, Apr 23 2014 12:00 Eastern Daylight Time

Demystifying Data Warehouses: Detecting DW Patterns and implementing them with SQL Server


Topic: Demystifying Data Warehouses: Detecting DW Patterns and implementing them with SQL Server – sponsored by Dell Software

You’ve read some of the content of well-known Data Warehousing books – now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more

Kevin S. Goff ( is a Microsoft SQL Server MVP Database architect/developer/speaker/author Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics Frequent speaker at community events in the Mid-Atlantic region. Host of BDBI Radio (, a weekly webcast on SQL/BI topics

The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line.

Interested in Presenting to the DBA VC?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley,

Future Meetings

November 11: Noon Mountain

No meeting November 25 because of US Thanksgiving

December 9: Noon Mountain

No meeting December 23 because of holidays

About the recording for September 23: You may want to advance 

the video about 5 minutes into the file.