August 2010 SQL Lunches

#26-Analysis Services Security

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: #26-Analysis Services Security
***This session will be 50-75 minutes**** Key takeaways: Learn several methods for securing your data in Analysis Services • Level: 400 • Length: 50-75 minutes In this session you will learn how you can use Roles to add security to your Analysis Services data. You will see how to add basic security as well as more advanced options like dynamic security.

#28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns

Report Builder
Speaker: Andy Leonard

View Recording: Watch Now!

Download:  Not Available

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: #28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns
This is part one of a three part series.
A brief introduction to the concept and usage of design patterns and a demonstration of the Counts Acquisition in ETL Instrumentation pattern.

#29-Policy-Based Management in a Nutshell

Report Builder
Speaker: Jorge Segarra

View Recording: Watch Now!

Download:  Not Available

BIO: I’m an MCTS (SQL Server 2005) currently working as a DBA in Jacksonville, Florida. In addition to being a member of the Tampa SQL Server, Tampa SQL Server Business Intelligence, and VMware user groups I am also a Hypervisor for the PASS Virtualization Virtual Chapter and chapter leader of the PASS Professional Development Virtual Chapter. I have also co-authored the book from Apress “SQL 2008 Pro Policy-Based Management“. Redgate Exceptional DBA of the Year 2010 Finalist.

Topic: #29-Policy-Based Management in a Nutshell
We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Servers!

#30-Troubleshooting SSIS Package Development

Report Builder
Speaker: Dustin Ryan

View Recording: Watch Now!

Download:  Not Available

BIO: Dustin Ryan is a Business Intelligence consultant and trainer for Pragmatic Works. Dustin’s areas of expertise include Reporting Services, Integration Services, and ASP.net. Dustin is an active member of the Jacksonville SQL Server User’s Group and has created BI and software solutions for clients such as Microsoft, Acosta, AMI, Rayonier, and Centurion Auto Logistics. Dustin also handles the graphic and web design for Pragmatic Works.

Topic: #30-Troubleshooting SSIS Package Development
SSIS package development can often be a time consuming and frustrating task for the inexperienced SSIS developer. Thankfully, BIDS has many tools to assist us as developers in troubleshooting our SSIS packages.. Using these tools (and some other tricks) can allow us to quickly navigate past development road blocks and effectively root out any problems our SSIS packages may have. In Dustin Ryan’s presentation, Troubleshooting SSIS Package Development, Dustin will provide an introduction on troubleshooting your package in the Control Flow and the Data Flow. At the end of this presentation, attendees should understand how to use tools within the BIDS environment to troubleshoot their own packages.