July 2012 SQL Lunches

#67-Using Change Data Capture (CDC) in SSIS 2012

Report Builder
Speaker: Thomas LeBlanc

View Recording: Watch Now!

Download:  Not Available

BIO: Thomas is a Senior SQL Server DBA at Turner Industries in Baton Rouge, LA. and has worked in the IT field since 1989 starting with COBOL dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and .Net(C#). Designing and developing Normalized & Dimensional databases has become his passion. Full-time DBA work started in 2002 at a paper mill. He has been blessed with speaking at SQLRally and SQLPass in 2011 as well as SQLSaturdays and the local Baton Rouge User Group since 2009. Thomas’ free time is spent helping other & improving his relationship with his family & God. He blogs at TheSmilingDBA.Blogspot.com and tweets under @TheSmilingDBA.

Topic: #67-Using Change Data Capture (CDC) in SSIS 2012
This session will go through using the Change Data Capture (CDC) features in SQL Server 2012. The CDC was implemented at the database and table levels in 2008, but Microsoft has added the Control Task and Source CDC components into the 2012 release of SQL Server Integration Services. These components can help with incremental loading of data. The demonstration will give some insight into using CDC for Slowly changing Dimensions and Fact updates. Along the way, you will be able to see some enhancements to SSIS in 2012.

#68-Designing Your First Power View Report

Report Builder
Speaker: Devin Knight

View Recording: Watch Now!

Download:  Not Available

BIO: Devin is a Senior BI consultant and Trainer at Pragmatic Works Consulting. Previously, he was an author in the books Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services, Knight's Microsoft Business Intelligence 24-Hour Trainer and SharePoint 2010 Business Intelligence 24-Hour Trainer. Devin has spoken at past conferences like PASS, SQL Saturdays and Code Camps. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).

Topic: #68-Designing Your First Power View Report
Power View has the capability of creating eye-popping visualizations within SharePoint 2010. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions. In this session you will learn how to design your own dazzling reports using Power View.