December 2009 SQL Lunches

#5-Looping Logic in SSIS

Report Builder
Speaker: Tim Mitchell

View Recording: Not Available

Download:  Not Available

BIO: Tim is a Microsoft SQL Server consultant, developer, speaker, and trainer. He has been working with SQL Server for over 6 years, working primarily in database development, business administration, data integration, and automation. He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce. Tim is principal and senior data engineer for Tyleris Data Solutions, a business intelligence and data management consulting firm. As an active member of the community, Tim has spoken at venues including SQL Saturday and the PASS Business Intelligence SIG, and is an active volunteer and speaker at the North Texas SQL Server User Group in Dallas. Tim is an author and forum contributor on and has published dozens of SQL Server training videos on

Topic: #5-Looping Logic in SSIS
Software developers have long taken for granted the ability to run iterative processes by using loop structures in their code. For SSIS developers, these same structures are available through the For Loop and the For Each Loop controls. In this session, we'll review each of these containers and demonstrate how they can be used for repetitive processing of similar tasks.

#6-Nuggets Found by Mining the Default Trace

Report Builder
Speaker: Jack Corbett

View Recording: Watch Now!

Download: Download Now!

BIO: Jack is currently a DBA/Developer with New Tribes Mission and has been working with SQL Server for 10 years. He is co-President of the Orlando PASS Chapter and has spoken at several user groups and SQLSaturday's. Jack is a frequent contributor to SQLServerCentral as an author and forum poster. Jack has also authored several videos at He also blogs regularly at

Topic: #6-Nuggets Found by Mining the Default Trace
The default trace was added to SQL Server 2005 and is a gold mine of information about what is happening on your server. Jack will explain what it is, the data it collects, and share some queries he has developed to help monitor and manage his SQL Servers.