Details
Event: February Meeting ( Add to calendar )
Date: Wednesday, February 18th, 2015
Time: 5:30 PM to 8:30 PM
Location: Hyatt Place - Garden of the Gods
Address:503 Garden Of The Gods Rd, Colorado Springs, CO 80907

Since we were snowed out last month, let's try this again. Come tell us what you want to learn about! Tired of sitting through boring performance tuning sessions? Or do you love that stuff and feel like you could never get enough? Dying to know when somebody is going to come talk about powershell? Let us know! This month, in lieu of our normal 101 session we would like to kick off the year by allowing the membership to suggest and vote on topics they would most like to hear about.


Summary: Testing is a critical part of the release process and vital to a high-quality data management lifecycle. Unfortunately, Integration Services (SSIS) does not have built-in support for testing and the tools for relational database testing are limited. As a result, most organizations forgo automated testing and focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues discovered.

In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This development pattern uses metadata authored by analysts to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic.

Bio: Reeves Smith is an independent consultant and trainer. He is a SQL Server MVP and Microsoft Certified Master with over 18 years of experience working with SQL Server. He has had the opportunity to work on various development and data warehouse projects within industries like banking, DoD, energy, entertainment, gaming, healthcare, insurance, manufacturing, oil and gas, travel, and telecommunication. He holds a BS in Applied Mathematics from University of Colorado at Colorado Springs.


Sponsors:
This meeting is sponsord by TEKsystems. If you are in the market for a job related to technology in Colorado Springs, please come to the meeting and meet our sponsor or reach out directly to Michael Kennedy, [email protected]