www.sqlpass.org    Professional Association for SQL Server





Office 365 


Please REGISTER or LOGIN to the site to become a MADPASS member!



The Madison SQL Server Users Group (MADPASS) is an official chapter of the Professional Association for SQL Server.  We are here to support the SQL Server users in the Madison, WI area.  We plan to meet on the fourth Wednesday of every month. 

Meetings are always FREE and food is provided.  Details about the next meeting can be found below.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

5:30 - 5:45 - General Q&A session & Announcements
5:45 - 6:15 - Short Presentation
6:15 - 6:45 - Food & Networking
6:45 - 7:45 - Main Presentation
7:45 - 8:00 - Door Prizes & Q&A Session

Meeting Location:  2310 Crossroads Drive Madison, WI 53718. 
It's the building with the Cisco sign facing the interstate near East Towne Mall.


Next Event

Next Meeting: Wed, Dec 17 2014

Building Metadata Driven ETL Solutions with BIML

Speaker: Joint Presenters Dave DuVarney and Rob Long

Summary: ETL development can consume a significant portion of time in Data Warehousing initiatives. It can also be very cumbersome to change ETL patterns across a large number of objects. This session will look at how BIML + metadata can be leverage to significantly reduce ETL development time.

About Joint Presenters: Dave DuVarney is an independent BI consultant and trainer. He has delivered numerous business intelligence projects in both a technical and functional leadership role. Dave's latest technical focus has been on the Microsoft Business Intelligence tools including Analysis Services 2012, Integration Services 2012, Reporting Services and PowerPivot. Along with technical delivery, Dave has assisted clients in establishing Data Warehousing and Business Intelligence initiatives. This includes working with executive stakeholders to define objectives, assisting in the identification of team roles and implementing development best practices using Agile Scrum. Rob Long is the EIM Supervisor at Sub-Zero Group. Rob is passionate about data warehousing and business intelligence. He has been working within the Microsoft stack for the last 8 years. He is a proud father of four, a Certified Business Intelligence Professional, and enjoys spending time with family and keeping up with the ever changing data management industry.


5:30 PM - 5:45 PM: General Announcements

5:45 PM - 6:30 PM: Food & Networking

6:30 PM - 7:45 PM: Main Presentation

7:45 PM - 8:00 PM: Wrap-up


Event Time : Wed, Dec 17 2014 17:30 - 20:00 (GMT-06:00) Central Time (US & Canada)
Add the meeting to your calendar: iCal


Meeting Location: 2310 Crossroads Dr Madison, Wisconsin

Directions: It's the building with the Cisco sign facing the interstate near East Towne Mall. Park behind the building and walk in main entrance. Our room will be straight ahead on the first floor. Get a Bing map to the meeting location.

Online Meeting


If you are having trouble joining the meeting, try adding ?sl=1 to the URL to use the Lync web client.

Need Lync? (64-bit) (32-bit)Other Downloads