The first meeting of the Charleston PASS Chapter will take place Thursday night, September 17, starting at 6 PM. The first topic will be an intro to SSIS for 2005/2008. You can find more information and register on the web site:
http://charleston.sqlpass.org/
Midlands PASS was privileged to host SQL Server MVP Andy Leonard (Blog #1, Blog #2, his VSTS site, Twitter) tonight as he gave a presentation on change data capture in SQL Server 2008. I hope the group got a lot out of his presentation as he didn't just talk about how to do incremental loads in SQL Server 2008, but also briefly covered how you do it in SQL Server 2005, how you tweak SSIS in 2005 for faster performance and to get back correctly all the rows you need, and how you build structures within the relational engine databases to ensure you're only pulling what's changed and not everything and filtering after the fact. In other words, it wasn't just a new SQL 2008 technology presentation, but it also covered a core data warehousing concept not only in theory, but in practice, too.
After the meeting Andy stayed around to talk even though he's teaching a class tomorrow and then faces a long drive back up to Virginia and then a very early drive Saturday morning to make Richmond Code Camp. We spent a lot of time talking about how to build up the community, how to find a proper balance between work / life / community, and just life in general. It was really good to meet and talk with someone else from our technical community, especially one I respect so very much. I don't know how much Andy got out of the discussion, but he gave me some solid advice, was a sounding board on a couple of things that had been weighing on me, and was able to convey his life experiences in a few similar situations.
One of the things my father, a retired Marine "gunny" (short for Gunnery Sergeant, or E-7 in the rank structure) taught me before I pinned on shiny new second lieutenant bars was to learn from those around me who have experience. Specifically he told me to look out for and gain the respect of the senior enlisted and the staff non-commissioned officers (NCOs). He advised me that if I was smart I would value their opinion and knowledge because chances were that anything I was considering they had already thought about and had seen some "butter bar" go off and do and get in a world of trouble as a result. I tried to apply that lesson in my Air Force career and I credit the success I had as a company grade officer to the enlisted corps who looked out for me, gave me sound advice, and were in my corner when I needed it. Speaking with Andy reminded me a lot of that experience (as does any conversation I have with Andy Warren, and you know, both are former Army... hmmmm).
Thanks, Andy, for coming out to speak to our user group, for talking with the members afterwards, and for the talk we had even after that.
Speaker: SQL Server MVP Andy LeonardMidlands PASS Chapter - October 2, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled meeting on Thursday, October 2, 2008, to host SQL Server MVP Andy Leonard. Andy is a mentor with Solid Quality Mentors and an expert in application architecture, SQL Server development, and SQL Server Integration Services (SSIS) in particular. He will present on Incremental Loads, Change Data Capture, and SSIS 2008. The meeting will once again be held at Training Concepts off of Berryhill Road. We will begin our meet and greet time at 6:15 PM as usual and start the at 6:45 PM. Please feel free to forward this to anyone who you think would be interested in attending. If you haven't already done so and plan on attending, please RSVP (kbriankelley {at} acm {dot} org) as soon as possible so we can ensure we have enough space and food. If you have time to help with setup, please email me and we'll plug you in!Abstract:Change Data Capture is a new SQL Server 2008 feature. One benefit of CDC is data filtering for Incremental ETL in SSIS: only touching rows that are new, updated, or have been deleted! In this presentation I walk through enabling Change Data Capture in SQL Server 2008, then present an overview of an SSIS package that utilizes Change Data Capture to perform Incremental ETL. Bio:Andy Leonard is a Solid Quality Mentor, SQL Server database and Integration Services developer, SQL Server MVP, and engineer. He is a co-author of
The Midlands PASS chapter will hold our normally scheduled meeting on Thursday, October 2, 2008, to host SQL Server MVP Andy Leonard. Andy is a mentor with Solid Quality Mentors and an expert in application architecture, SQL Server development, and SQL Server Integration Services (SSIS) in particular. He will present on Incremental Loads, Change Data Capture, and SSIS 2008. The meeting will once again be held at Training Concepts off of Berryhill Road. We will begin our meet and greet time at 6:15 PM as usual and start the at 6:45 PM. Please feel free to forward this to anyone who you think would be interested in attending. If you haven’t already done so and plan on attending, please RSVP (kbriankelley {at} acm {dot} org) as soon as possible so we can ensure we have enough space and food. If you have time to help with setup, please email me and we’ll plug you in!I'll send out an agenda, contact phone numbers, and the building code next week. Abstract:Change Data Capture is a new SQL Server 2008 feature. One benefit of CDC is data filtering for Incremental ETL in SSIS: only touching rows that are new, updated, or have been deleted! In this presentation I walk through enabling Change Data Capture in SQL Server 2008, then present an overview of an SSIS package that utilizes Change Data Capture to perform Incremental ETL. Bio:Andy Leonard is a Solid Quality Mentor, SQL Server database and Integration Services developer, SQL Server MVP, and engineer. He is a co-author of
The Midlands PASS Chapter hosts:
SQL Server MVP John Welch
July 17, 2008 at Training Concepts
The Midlands PASS chapter will hold a special meeting on Thursday, July 17, 2008, to host SQL Server MVP John Welch. John will be giving a presentation on SQL Server Integration Services. The meeting will once again be held at Training Concepts off of Berryhill Road. We will begin our meet and greet time at 6:15 PM as usual and start the presentation between 6:30 and 6:45 PM. I will send out an agenda next week.
Please feel free to forward this to anyone who you think would be interested in attending. If you plan on attending, please RSVP as soon as possible so we can ensure we have enough space and food. If you have time to help with setup, please email me and we’ll plug you in!
Abstract:
One of the common issues encountered with SSIS is deploying configurations for multiple environments. During this session, 2 patterns for handling configurations in SSIS will be covered. a simple pattern that handles most cases, to a very flexible pattern that covers most complex scenarios. Learning and using these patterns will allow SSIS developers to more easily deploy packages between environments, and leverage a single point of configuration in each environment.
Bio:
John Welch is Chief Architect with Mariner, a consulting firm specializing in enterprise reporting & analytics, data warehousing and performance management solutions. John has been working with business intelligence and data warehousing technologies for 6 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community. John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, Software Development West (SD West), Software Management Conference (ASM/SM), and others. John has also been published in DM Review, SQL Server Professional, and XML Developer.
Last night the Midlands PASS Chapter had the pleasure of hosting SQL Server MVP Brian Knight. I was able to capture a few pictures from last night though they aren't the best quality.
Our next meeting is scheduled for July 10 and we are hosting John Welch, SQL Server MVP, who will be speaking on managing SSIS between different environments.
