North East Texas (NETPASS)

Welcome to NETPASS

Next Meeting

Wednesday,

February

17

February Meeting

  • In-Person @ 315 North Broadway Ave Tyler, Texas, United States (map)
  • 18:00 - 20:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English

Location:

Tyler Area Chamber of Commerce (315 North Broadway Ave., Tyler, TX) in their Genecov conference room. 

Agenda:

6:00 PM Doors open

6:00 PM - 6:15 PM Refreshments/Networking

6:15 PM - 6:30 PM Introduction

6:30 PM - 6:45 PM Sponsor Presentation

6:45 PM - 8:00 PM Featured Presentation (Tim Mitchell)

8:00 PM - 8:15 PM Raffle 

Two 30-day memberships to Pluralsight

Book from O'Reilly 

8:30 PM Informal networking, etc. at SportsZone 

 

 

Featured Presentation:

Testing SSIS Packages

Tim Mitchell, Principal Data Architect Tyleris Data Solutions

Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.” As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system. This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these: * Performance testing * Patterns for validating execution results at runtime * Validating package metadata before execution * Design time versus runtime testing * Making a graceful exit: testing for error handling About the presenter Tim Mitchell is a business intelligence consultant, author, and trainer. He has worked with SQL Server for over a decade, specializing in business intelligence, ETL/SSIS, data quality, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is an independent business intelligence consultant and a partner with Linchpin People, and is the principal at Tyleris Data Solutions. As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2. He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area. You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

About Tim:
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

PASSChapterLogo.jpg







PASSChapterLogo.jpg










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