October 2010 SQL Lunches

#39-SSIS: Taming your Configuration Files

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: #39-SSIS: Taming your Configuration Files
Typically, you develop SSIS packages on your laptop, desktop or some client machine and then deploy them to a server. In most cases these environments are completely different. They may have different machine names, folders, connection strings, etc… To assist in easing the pain of deploying your SSIS packages, SSIS includes a range of options that help you when building your data integration solutions. These options include: Property expressions, SET options of DTEXec, and my favorite Package Configurations. In this session I will attempt to demystify the usage of Configurations files in your SSIS package with a particular focus on Child and Master package solutions.

#32-SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging 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: #32-SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns
This is part three 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.

#40-Mirroring: The Bear Necessities

Report Builder
Speaker: Ryan Adams

View Recording: Watch Now!

Download: Download Now!

BIO: Ryan is a highly skilled Microsoft oriented administrator and has worked for a Fortune 100 company for 12 years. In his time there he has supported everything from desktop to server. Most recently he has served as a senior Active Directory Architect and Identity Management (MIIS, ILM, FIM) Consultant. He is the sole SQL Server DBA for his group, supporting both vendor databases and custom databases. His primary focus is database design and performance, but also works with SSRS report development, and SSIS ETL. He enjoys being involved in the SQL community and serves on the board of directors for the North Texas SQL Server User Group. He is well versed in many core Microsoft technologies, has implemented and supported them both nationally and internationally for a company of 250k+ users, and holds the following certifications: MCP MCSA MCSE MCDBA - SQL 2000 MCTS - SQL 2005 MCITP - SQL 2005

Topic: #40-Mirroring: The Bear Necessities
Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.

#36-Overview of Common DAX Expressions

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: #36-Overview of Common DAX Expressions
DAX (Data Access Expressions is the new language to perform powerful analysis in power pivot. Come get hands on with Adam and this new technology and see how it can outperform your old Excel functions and take your analysis to the next level.