Next Meeting

Thursday,

April

10

PASSDC Monthly Meeting

  • In-Person @ The Motley Fool - 2000 Duke Street Alexandria, Virginia, United States (map)
  • 18:30 - 21:00 Eastern Daylight Time
  • 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:

Automating Your SSIS Design Patterns For Faster Development

Samuel Vanga, SQL Server and BI Developer Fidelity & Guaranty Life

Once you finish designing the SSIS packages needed for your project, the process of creating those packages is mostly redundant and time-consuming. As the source or target systems go through changes (even as small as a column rename), you’re forced to modify the packages. BI Markup Language (BIML), which is a free plugin, removes the pain-points involved in manual development by programmatically generating packages. In this session, you’ll learn the basics of BIML and see how you can use it along with metadata to create packages automatically. You'll also see how easy it is to regenerate the packages when the system changes. You’ll leave the session with knowledge of BIML’s building blocks and a principle I call “D[ee]MOB” that helps you automate SSIS development in your environment.

About Samuel:
Sam Vanga is a data professional, blogger, and presenter with experience in Microsoft SQL Server and BI stack. He specializes in data integration, dimensional design, database development, and BI modeling. He loves process automation because he is lazy, but doesn't like to admit it.

Regular Meeting Details

PASSDC meets the second Thursday of each month at the Motley Fool in Alexandria, Virginia.

Meetings begin at 6:30pm, and typically last around two hours.

Location

The Motley Fool
2000 Duke street
Alexandria, VA
22314

Travel

Metro is your friend; the Motley fool is just a short walk from the King street metro (use the tunnel!).

Note: The building is a secured building and the doors will most likely be locked when you arrive.
We will have someone at the front door to let you in. If you arrive early you will need to wait until 6:30 for us to let you into the building. a phone number you can text for entry between 6:30 pm and 7:30 will be posted on the door.

 

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