The Baton Rouge SQL Server User Group will be hosting its first meeting of the new year. Our meeting place has changed to Louisiana State University in Patrick F. Taylor Hall. Both SQL Saturday's held in Baton Rouge were located here. If you haven't attended a meeting I recommend that you come out to this meeting. We have two great presentations and some really great giveaways. Wait, did I mention that I was speaking. That should definitely get you out. I will be also giving away a copy of our book, Knights Microsoft Business Intelligence 24 Hour Trainer . Still not convinced, well there is always the free Pizza and great Networking. The Baton Rouge .Net User Group will also be meeting that evening. So, if you are in the area come and hang out with us.
Topics: Introduction to SQL Replication – Transactional (Mark Verret) and Taming your SSIS Configuration Files (Patrick LeBlanc)
Location: LSU, Patrick F. Taylor Hall, Room 1118. Click here for directions.
Date and Time: 1/12/2011 5:45:00 PM
Sponsored By: Envoc
Agenda:
5:45 - 6:15 pm: Networking and Refreshments
6:15 - 7:00 pm: Introduction to Replication
7:00 - 7:45 pm: Taming your SSIS Configuration Files
7:45 - until: Open Forum for questions and Raffle
SQL Server User Group
Speaker: Mark Verret
Topic: Introduction to SQL Replication – Transactional
Description: An introduction to SQL Replication with a focus on Transactional Replication. What is SQL Replication and why would you want to use it? The presentation will involve a demonstration and discussion of usage in a production environment.
BIO: Mark Verret has been in the IT field for over 10 years. He is currently the System Administrator and DBA for the LSU Highway Safety Research Group. For the past 2 years he has taken on the DBA role involving SQL replication, warehousing, reporting, etc. Along with teaching an undergraduate business intelligence course, he has also presented at the Baton Rouge SQL user group and Baton Rouge and Dallas SQLSaturday.
Speaker: Patrick LeBlanc, SQL Server MVP
Topic: Taming Your SSIS Configuration Files
Description: 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.
BIO: Patrick LeBlanc, SQL Server MVP and author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events, including SQL Saturday’s, User Groups and the SQL Lunch.
Patrick Leblanc, SQL Server MVP, MCTS
Founder, www.SQLLunch.com
