April 2010 SQL Lunches

#16-Using Compression on SQL Server 2008

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: #16-Using Compression on SQL Server 2008
In this SQLlunch, Kyle will go over the details of compression within SQL Server 2008. He will cover the different types of compression, how exactly compression works (what it is doing to your data that allows it to conserve space), how to calculate your estimated space savings, and then finally apply compression to an object in your database.

#13-Advanced Parameters in SSRS 2008

Report Builder
Speaker: Mike Davis

View Recording: Not Available

Download:  Not Available

BIO: Mike Davis is a Senior BI consultant and Trainer at Pragmatic Works. He was an author on the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups across the US, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

Topic: #13-Advanced Parameters in SSRS 2008
In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures and using parameters with custom code. Key takeaways: Learn how to use advanced parameter techniques in SSRS 2008 including stored procedure parameters cascading parameters and multi value parameters.

#17-Introduction to SSIS

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: #17-Introduction to SSIS
Ready to get started using SQL Server Integration Services (SSIS). Join Patrick LeBlanc, founder of the SQL Lunch in the session on how to use SSIS. Patrick will cover everything you need to get started with this powerful technology. You’ll learn how to utilize several key components of SSIS, while applying common business rules to your data.