Next Meeting: Thu, Jan 17 2013
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.
Event Time : Thu, Jan 17 2013 18:00 - 20:30 (GMT-06:00) Central Time (US & Canada)
Your Local Time: Fri, Jan 18 2013 00:00 - 02:30
Microsoft Building LC-1
7000 North Highway 161
Direction: Microsoft is between Highway 114 and MacArthur Boulevard in Irving (Las Colinas), on Highway 161. The easiest way to get to there is to take the outer access road for Highway 161 North and exit into the Microsoft parking lot. It is the first building you will see once you exit. We'll be in the first building, LC-1.
Please park in the front of the building that faces Highway 161. Enter the front of the building and sign-in at the front desk.
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.
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 SQLServerCentral.com and has published dozens of SQL Server training videos on SQLShare.com.
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 TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.
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.
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 Made2Mentor.com or follow him on Twitter @Made2Mentor.