North Texas SQL Servers Users Group

Next Meeting




NTSSUG Meeting

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 20:30 (UTC-06:00) Central Time (US & Canada)
  • Language: English

RSVP Here: None

6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - Monthly Presentation (Details below)
7:30 - 8:30 - Series Presentation by David Stein
8:30 - 8:45 - Raffle and closing.

Featured Presentation:

When ETL Goes Bad: Handling Errors and Anomalies in SSIS

Tim Mitchell, Business Intelligence Consultant Artis Consulting

Even in the most reliable ETL system, it's eventually going to happen: A package will fail, an output row count won't match what is expected, a data anomaly will force a forensic search of the package infrastructure... In this session, we'll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we'll cover various ways to keep your ETL flowing when problems arise.

About Tim:
Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer. He has been working with SQL Server for a decade, working primarily in business intelligence, ETL/SSIS, database development, and reporting. He has earned a number of industry certifications and holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010. Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area. As an active member of the community, Tim has spoken at national, regional, and local venues including the SQL PASS summit, SQL Connections, SQL Saturday events, and various user groups and PASS virtual chapters. He is a board member and speaker at the North Texas SQL Server User Group in Dallas, serves as the co-chair of the PASS BI Virtual Chapter, and is an active volunteer for PASS. Tim is an author and forum contributor on and has published dozens of SQL Server training videos on Tim is a contributing author on the charity book project MVP Deep Dives 2, and is coauthor of the book SSIS Design Patterns. You can visit his website and blog at or follow him on Twitter at

Data Warehouse Series - Basics and Beyond

David Stein, Data Warehouse Architect RealPage Inc.

In a series of 1 hour sessions, I'll cover both the basics and gotchas of Data Warehouse Development using the SQL Server 2012 toolset. Some of the things we'll cover are:

•             Basic methodology for evaluating business requirements/needs, obtaining user cooperation, and identifying source data quality issues.
•             Data Warehouse basic concepts including Facts, Dimensions, Star and Snowflake Schemas.
•             Deep dive into slowly changing Dimension types and how to handle them using T-SQL and SSIS.
•             T-SQL Merge Fundamentals and how it can be used to load Dimension and Fact Tables. Yes, I swear the Merge Generation Code will be ready for the presentation. :)
•             Understanding the three basic Fact Table types, how they are used, and loaded with SSIS.
•             Date Dimension creation and configuration.
•             Taking advantage of SSIS 2012 functionality improvements including Environments, Project Parameters  etc.
•             Strategies for SSIS and database optimization, insuring data integrity, etc.
•             And much, much more. 
Each session will progressively build upon the previous sessions and session material will be posted on my blog.

Come watch this exciting and progressive series as I take you from padawan to Jedi Master.

About David:
David Stein is a Data Warehouse Architect with RealPage Inc. in Carrollton, TX. He’s worked in SQL Server Business Intelligence for almost a decade in many roles as both a consultant as well as a corporate employee. He’s designed Data Warehouses from scratch as well as saved projects in serious jeopardy. He is also very active in the community, having spoken at PASS events at all levels, including the PASS Summit, SQL Rally, and at numerous SQL Saturday events and user groups. You can learn more about Data Warehousing, Business Intelligence, and other technical topics on his blog at or follow him on Twitter @Made2Mentor.

Supplementary Materials

The following event attachments are available to you:

Thank You to the 



of our May 2018 

SQL Saturday!

Back to Top