May 2010 SQL Lunches

#19-Analysis Services Performance Tuning

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: #19-Analysis Services Performance Tuning
In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.

#21-Configuring, Deploying and Scheduling SSIS Packages

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: #21-Configuring, Deploying and Scheduling SSIS Packages
Now that you have created your SSIS packages it’s time to add some configuration files that will ease your deployments. Wait how do you deploy one or two or three SSIS packages? Uh oh, now that they are deployed how do you schedule them? Well join Patrick LeBlanc in his discussion on how to Configure, Deploy and Schedule your SSIS packages.

#18-SQL Server and PowerShell Working w/Databases

Report Builder
Speaker: Max Trinidad

View Recording: Watch Now!

Download:  Not Available

BIO: Max Trinidad is a native of Puerto Rico and has been working with computers since 1979. He has worked with Dbase III/IV, Clipper, RPG, OS/400, OCL/JCL/CL, HTLM and most current MS development technologies. Work for many years as a Senior IT/Developer has provided support for Windows Servers 2003/2008, SQL Servers Applications, Microsoft Virtualization Technologies, and IBM iSeries building Visual Studio solutions. In 2009 and 2010 got his Microsoft MVP award in Powershell.

Topic: #18-SQL Server and PowerShell Working w/Databases
Looking into using SQLPS.exe how to work with databases on multiple SQL Servers. See How-To Configure your PowerShell profile to make your scripting environment more productive. This session will have a lot of samples".