January 2011 SQL Lunches

#45-Tips & Tricks for dynamic Reporting Services Reports

Report Builder
Speaker: Pam Shaw

View Recording: Watch Now!

Download:  Not Available

BIO: Pam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa.

Topic: #45-Tips & Tricks for dynamic Reporting Services Reports
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.

#35-Building your first PerformancePoint Dashboard in SharePoint 2010

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: #35-Building your first PerformancePoint Dashboard in SharePoint 2010
Many of you have seen the coolness that is PerformancePoint in SharePoint 2010. Come get hands on with Adam as we go through the ins and outs of creating your first dashboard. See some of the cool visualizations you can use and how they work together to create a cool user experience.

#46-SQL Azure – Cloud Database Coolness

Report Builder
Speaker: Scott Klein

View Recording: Watch Now!

Download:  Not Available

BIO: Scott Klein is a Microsoft Technical Evangelist focusing on Windows Azure SQL Database (AKA SQL Azure) and related cloud-ready data services. His entire career has been built around SQL Server. Prior to Microsoft he was a SQL Server MVP for several years, then followed that up by being one of the first 4 SQL Azure MVPs. Scott is the author of over ½ dozen books by both WROX and APress, including Pro SQL Azure. He can be found talking about WASD at events large and small all across the US wherever he can get people to listen.

Topic: #46-SQL Azure – Cloud Database Coolness
This session will first provide a very quick introduction into SQL Azure to those who are new to SQL Azure, but then dive into lessons we have learned from our projects, and things you can expect and should know when working with SQL Azure. We will discuss deployment practices, what to know from the application side, and how to get the best out of SQL Azure.

#48-SSIS Tips&Tricks (Advanced SSIS)

Report Builder
Speaker: Josef Richberg

View Recording: Not Available

Download:  Not Available

BIO: A SQL practitioner for over 17 years specializing in performance & tuning. I currently work for Harpercollins Publishers designing, enhancing, and improving, the sql experience for many of the data warehouse applications. I have been heavily involved in designing and implementing SSIS packages. I am the RedGate '2009 Exceptional DBA' awards winner

Topic: #48-SSIS Tips&Tricks (Advanced SSIS)
Learn some of the quirks and capabilities of SSIS. Learn about the pitfall of "parallel path choicing". Use the Script Component as a data source (to solve complex sourcing issues) and as a data destination (to get around the identity column conundrum). See how use Script Tasks to build directory scanners for efficient file import techniques. We'll also go over some the tunable properties of the Data Flow object.