January 2010 SQL Lunches

#7-Top Tablix Tips

Report Builder
Speaker: Jessica Moss

View Recording: Watch Now!

Download: Download Now!

BIO: Jessica M. Moss, an architect with Ironworks Consulting and a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and authored technical content for multiple magazines, websites, and the book "Microsoft SQL Server 2008 Integration Services Problem-Design-Solution". Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences. You can read about her work on her blog, http://www.jessicammoss.com.

Topic: #7-Top Tablix Tips
SQL Server Reporting Services 2008 introduces the tablix, a combination of a table and a crosstab report. This lesson shows how to set up the tablix, the properties you can set to get the most out of the tablix, and other usage tips.

#8-SSRS Data Driven Subscriptions

Report Builder
Speaker: Devin Knight

View Recording: Watch Now!

Download: Download Now!

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: #8-SSRS Data Driven Subscriptions
In this session, you’ll learn how to take advantage of a great feature in Reporting Services called Data Driven Subscriptions. All gotcha settings will be uncovered so you can have your reports run unattended and delivered to either a windows file share or email.

#9-Scripting in SSIS

Report Builder
Speaker: Brian Knight

View Recording: Watch Now!

Download: Download Now!

BIO: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the founder of Pragmatic Works and co-founder of SQLServerCentral.com, JumpstartTV.com, and is on the Principal Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for many industry magazines and sites. He has co-authored and authored more than 9 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps.

Topic: #9-Scripting in SSIS
SSIS is powerful with its many components but one of the most powerful components you can use is the Scripting Task and Component. The two scripting components allow you to do things you could never do in SSIS. In this session, Brian Knight will show how to use scripting in SSIS to solve many common scenarios that a BI developer experiences.