MADPASS

Welcome

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 third 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 - Food &Networking
6:15 - 7:30 - Main Presentation
7:30 -7:45 - Q&A Session / Door Prizes / Wrap-up

 

Meeting Location Provided By:
Talavant

Next Meeting

Wednesday,

May

16

May MadPASS Monthly Meeting

 

5:30 - 5:45 - Food & Networking

5:45 - 6:15 - General Q&A session & Announcements

6:15 - 7:30 - Main Presentation

7:30 - 7:45 - Q&A Session & Wrap-up


Third Wednesday of month

Time: 5:30 to 8:00 PM

Featured Presentation:

Data Vault 2.0 An Introduction To A Better Data Warehouse Database Designing Method

Thomas Lane, DW/BI Consultant Talavant

As Dan Linstedt, the creator of Data Vault 2.0, describes it as follows: The Data Vault Model is a detail oriented, historical tracking and uniquely linked set of normalized tables that support one or more functional areas of business. It is a hybrid approach encompassing the best of breed between 3rd normal form (3NF) and star schema. The design is flexible, scalable, consistent and adaptable to the needs of the enterprise. Data Vault 2.0 is not an app but a database modeling methodology that overcomes many of the shortcoming of DW warehouse modeling. Data vault attempts to solve the problem of dealing with change in the environment by separating the business keys from the descriptive attributes of those keys. This class will go over the basic parts of the Data Vault 2.0 model along with examples of each.

About Thomas:
Thomas has been living and breathing Microsoft databases for over twenty years and is now relishing his position as a DW Consultant at Talavant (www.Talavant.com). After receiving his Ph.D. in Chemistry and following three years as a post-doc at Marquette University, Thomas left the world of science for a career in IT. He has worked as a programming and database instructor, a VB and C# developer, and for the past fourteen years worked with SQL server as a DBA, ETL specialist, and Data Architect at various Midwestern companies. Thomas recently received his MSCE in Data Management and Analytics.

Connect with us!

 

PASSChapterLogo100.jpg 

 sql_micro_sm.gif 

Office 365 

 

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