Next Meeting

Thursday,

January

09

PASSDC Monthly Meeting

  • In-Person @ The Motley Fool - 2000 Duke Street Alexandria, Virginia, United States (map)
  • 18:30 - 21:00 (UTC-05:00) Eastern Time (US & Canada)
  • Language: English

 Our regular meeting! In addition to our featured speaker, we're looking forward to hearing from you about how best this user group can support professionals in the DC area. We'll also have food and raffle of a few things at the end!

**Announcing Office Hours **

Come buy a drink and participate in a SQL discussion group with Chris Bell and others.

We will head over to the Capital Grille after the meeting for about an hour of a casual open SQL discussion. The topic is not set, but feel free to bring any questions you have, or topics of interest.

Featured Presentation:

Adding CLR and ADO MD to your BI Toolbox

Viktor Radu, Lead BI Developer M.C. Dean, Inc.

Just in case it's fallen off your radar - SQL CLR Integration is still there and can be a useful tool when building applications that rely on SQL Server. We'll start by looking at some basics of SQL CLR Integration. It's also no secret that the MDX learning curve is pretty steep and getting beyond basics requires significant study. In the second part of this presentation, we'll learn how to use ADO MD wrapped in CLR stored procedures to bring multidimensional data back into the two-dimensional world of SQL, thus greatly simplifying cube design and MDX queries. Finally, we'll examine some Dos and Don'ts of this approach and look at some examples of its utilization by getting rid of rugged hierarchies and by simplifying some complex MDX queries.

About Viktor:
A Ukraine native, Viktor abandoned PHP and C++ for the shiny new world of .NET and SQL Server in 2006. Since then he has worked on multiple web and desktop applications, and now leads a team of developers building an enterprise Business Intelligence solution at M.C. Dean, Inc., an electrical construction company headquartered in Dulles, VA.

Regular Meeting Details

PASSDC meets the second Thursday of each month at the Microsoft office in Chevy Chase. Meetings begin at 6:30pm, and typically last around two hours.

Location

Microsoft Technology Center
5404 Wisconsin Ave. Ste. 700
Chevy Chase, MD 20815
 

Travel

Metro is your friend; the Microsoft office is located above the Friendship Heights Station on the Red Line.

 

RSVP

 

 

PASSChapterLogo.jpg


Major Sponsors



Capital Personal Computer User Group ( C P C U G )


WaterOx Consulting


sql_micro_sm.gif


GEICO


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids