July 2010 SQL Lunches

#24-Looping in SSIS

Report Builder
Speaker: Brad Schacht

View Recording: Watch Now!

Download:  Not Available

BIO: Brad Schacht is a BI Consultant and Trainer for Pragmatic Works. His experience on the Microsoft BI platform includes DTS, SSIS, Reporting, and migrations and conversions. His background in creating custom solutions for clients and partners provides great experience for delivering real-world value through his courses. Brad uses this experience to make the topics real for those he’s working with and teaching. Brad also participates as a speaker at events such as SQL Saturday and is an active member of the Jacksonville SQL Server User’s..

Topic: #24-Looping in SSIS
In this session Brad will walk you through the loops available in SQL Server Integration Services. Topics to be covered include the ForLoop and the value it provides, as well as the most common uses for the ForEach Loop; such as looping over files. Setup and configuration will be discussed along with when a loop should be used. We will also discuss how to use these loops to dynamically name a file for archiving after it is done being used inside the package.

#23-SSRS R2 – Shared Datasets and Report Parts

Report Builder
Speaker: Patrick LeBlanc

View Recording: Watch Now!

Download:  Not Available

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: #23-SSRS R2 – Shared Datasets and Report Parts
SQL Server Reporting Services R2 introduced two new capabilities. Developers now have the ability to publish Data Sets and Report Parts (tables, charts, etc) as items that can be used by individuals building reports using Report Builder 3.0. In today’s session Patrick LeBlanc will show you how to create Shared Data Sets and Report Parts. He will then explain how to publish these items out to a Report Server. Using Report Builder 3.0, he will also show you how your end-users can use these items when building their own reports.

#25-Transact-SQL Development and Deployment

Report Builder
Speaker: Andy Leonard

View Recording: Watch Now!

Download: Download Now!

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: #25-Transact-SQL Development and Deployment
Join SQL Server MVP Andy Leonard for some snappy tips and tricks on Transact-SQL development and deployment! In this session, Andy makes a case for writing re-executable T-SQL and demonstrates a couple techniques. He then builds on re-executable code patterns to demonstrate using SqlCmd mode in SSMS for database deployment.

#27-Let's Get Dimensional

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: #27-Let's Get Dimensional
Learn the basics or dimensional modeling, the foundation for any good data warehouse, with Adam Jorgensen on SQLLunch. Adam will take us through why how dimensional modeling is different from your typical applications database, why it’s different, and some mistakes to avoid. We will review some existing models and take your questions on you modeling challenges. We’ll review common scenarios and discuss why they are the best approach.