September 2010 SQL Lunches

#33-SSRS 2008 R2 - Indicators, Sparklines and Databars

Report Builder
Speaker: Patrick LeBlanc

View Recording: Watch Now!

Download: Download Now!

BIO: Patrick LeBlanc is a Microsoft SQL Server and Business Intelligence Technical Solution Professional. He has written several blogs and articles on his blog at http://patrickdleblanc.com, www.sqlservercentral.com and www.bidn.com. Along with his 10+ years experience he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of four SQL Server books. His past work experiences include Sr. Consultant at Pragmatic works and Database Architect at several companies. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community.

Topic: #33-SSRS 2008 R2 - Indicators, Sparklines and Databars
SQL Server Reporting Services R2 introduced several new features. In this lunch Patrick LeBlanc will provide three demonstrations that will show you how to create Indicators, Databars and Sparklines on your reports.

#34-Let’s get Dimensional – from Requirements to Dimensional Design

Report Builder
Speaker: Adam Jorgensen

View Recording: Watch Now!

Download:  Not Available

BIO: Adam Jorgensen , MBA, MCDBA, MCITP: BI has over a decade of experience leading organizations around the world in developing and implementing enterprise solutions. His passion is finding new and innovative avenues for clients and the community to embrace business intelligence and lower barriers to implementation. Adam is also very involved in the community as a featured author on SQLServerCentral, SQLShare, as well as a regular contributor to the SQLPASS Virtual User Groups for Business Intelligence and other organizations. He regularly speaks at industry group events, major conferences, Code Camps, and SQLSaturday events on strategic and technical topics.

Topic: #34-Let’s get Dimensional – from Requirements to Dimensional Design
from Requirements to Dimensional Design Let’s take a design together from the user requirements and turn it into a dimensional model. This will be a fun hands on version of the last presentation where we introduced dimensional modeling.

#31-SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns

Report Builder
Speaker: Andy Leonard

View Recording: Watch Now!

Download:  Not Available

BIO: Andy Leonard is an Architect with Molina Medicaid Solutions, SQL Server database and Integration Services developer, SQL Server MVP, PASS Regional Mentor, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. Andy blogs for SQLBlog.com. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008.

Topic: #31-SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns
This is part two of a three part series.
A brief introduction to the concept and usage of design patterns and a demonstration of the Counts Acquisition in ETL Instrumentation pattern.

#38-Restartability in SSIS

Report Builder
Speaker: Kyle Walker

View Recording: Watch Now!

Download:  Not Available

BIO: Kyle Walker is a Business Intelligence consultant for Pragmatic Works. He has past experience as a reporting analyst at one of the nation's leading default solutions companies. He is experienced in Integration Services, Reporting Services, and Database Administration.

Topic: #38-Restartability in SSIS
In this session Kyle will cover the implementation of checkpoints in your SSIS packages to restart on failures