Search results matching tags 'SSIS', 'Developer Community', and 'Code Camp'

Presenting at Roanoke Code Camp Saturday!

andyleonard — Mon, 07 Mar 2011 17:00:00 GMT

Introduction

I am honored to once again be selected to present at Roanoke Code Camp!

An Introductory Topic

One of my presentations is titled "I See a Control Flow Tab. Now What?" It's a Level 100 talk for those wishing to learn how to build their very first SSIS package.
This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

Designing an SSIS Framework

I'm also presenting a Level 400 talk about designing an SSIS Framework.
In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

Conclusion

If you're going to be near Roanoke Virginia Saturday 12 Mar, register! I hope to see you Saturday!

:{>

Richmond Code Camp X Recap

andyleonard — Sun, 10 Oct 2010 03:29:00 GMT

Introduction

The tenth Richmond Code Camp was held today at the J. Sargeant Reynolds Community College campus on Parham Road.

It. was. awesome!

With 40 sessions and over 400 registered, this #RichCC was arguably the best one yet! There's a lot that goes into planning an event of this magnitude. I commend the Code Camp Leadership Team for their hard work, but the team possesses a quality that will ensure many more Richmond Code Camps to come: absence of ego.

Ch-Ch-Ch-Changes...

There's a bad joke about a widow who visits the funeral home before services begin. She's astonished to find the suit she provided for her late husband on the cadaver in the next coffin. Aghast, she notifies the undertaker who assures her the matter will be addressed. As she steps out of the room she hears the undertaker yell into the back room "Lou! Swap the heads on two and three!"

Over the past five years, we've "swapped heads" a few times on the leadership team. I'm honestly not sure who led the first Richmond Code Camp, my turn came up around #2 or #3. After a few turns, it pased onto another, then another. Areas of responsibility also rotate. I remember Fran La Vigne (Blog | @Tableteer) and I sitting in a Panera Bread in Short Pump Virginia selecting speakers for that first event.

There's no penalty for stepping up or down on our team. Life happens, people move, get more and less busy, change jobs, and just have other plans. Why punish people for that? Especially in a volunteer organization? The on-point person doesn't try to "edge out" previous leaders. That's because we're all pretty secure individuals. It's a great group to be part of, and I love every member of our team.

Presentations

As usual I didn't get to watch an entire presentation (except my own). I caught a lot of Jessica Moss's (Blog | @JessicaMMoss) talk on Data Warehousing. As always when I hear Jessica present (or speak), I learned new stuff. Jessica is a great speaker and Richmond is fortunate to have her as part of our community.

I had to duck out to set up lunch (which was late for the first time ever in Richmond Code Camp history!). While waiting for the Pizza Dude to arrive, I had a great chat with "Robin's Mean Husband" (apologies for the inside joke in a public blog...).

I presented after lunch. No one fell asleep (yay!). I did my talk called Building Your First SSIS Package and, just like in the same presentation for SQL Saturday #46 in Raleigh NC a few weeks earlier, the keyboard stopped working in the middle of my demo. I finished using only the mouse - again - but it's definitely time to place a service call to Dell.

The coolest thing about community events is the cool people. I skipped the next session to talk with Joel Cochran (Blog | @JoelCochran) , Frank La Vigne (Blog | @Tableteer), Kevin Hazzard (Blog | @KevinHazzard), and G. Andrew Duthie (Blog | @DevHammer), TBDDEOTP (The Best Durn Developer Evangelist On The Planet). It was great to catch up with everyone and just geek out a little.

For the last session of the day, I snuck into Joel Cochran's talk on Blend. Joel loves building solutions with Blend and it shows. I was in there for 15 minutes and I picked up a ton of tricks. Joel is also my star SSIS pupil. We spent a Saturday in July working together on database design and SSIS mentoring. He has taken that ball and run with it!

Conclusion

For some reason, I thought it would be fun to drive to and from Boston to deliver From Zero To SSIS in cooperation with Boston SQL Training last week. The drive up was rainy bu ok. The drive back wasn't. It took me three hours to go the first 100 miles. No fun at all. Watching the Arrival Time inch forward on my Garmin all that time was no fun. I left Boston around 3:00 PM and arrived in Richmond about 12 hours later, grabbed four hours of sleep, and then rolled out for Code Camp!

Despite a rough start to the day for me personally, Richmond Code Camp X was a huge success!

:{>

Speaking at Roanoke Code Camp Tomorrow!

andyleonard — Fri, 06 Mar 2009 11:50:00 GMT

I am honored to again be presenting at Roanoke Code Camp tomorrow, 7 Mar 2009!

I'll be talking about Incremental Loads, a presentation very close to my first blog post at SqlBlog.com: SSIS Design Pattern: Incremental Loads.

I'm also honored to be co-presenting with Jessica Moss, MVP. We will be reprising our PASS Summit 2008 presentation on SSIS Scripting. We demonstrate scripting techniques using a class (and later a custom SSIS task) that interfaces with the Twitter API.

If you're going to be in the Roanoke, VA neighborhood tomorrow, stop by and say Hi!

:{> Andy

Speaking at Raleigh Code Camp tomorrow!

andyleonard — Fri, 14 Nov 2008 11:00:00 GMT

Code Camp RDU Fall 2008 is tomorrow (15 Nov 2008)! If you're going to be in the Raleigh area tomorrow and are interested in anything related to Microsoft technology, register and check out the sessions. I always have a blast in Raleigh!

I will be presenting my popular session: Incremental Loads, Change Data Capture, and SSIS 2008. Hope to see you there!

:{> Andy

Speaking in Raleigh and Philadelphia This Week

andyleonard — Sun, 06 Jan 2008 22:58:00 GMT

Now that our 5-month old son - Riley Cooper - is on the mend, I am hitting the speaking trail again!

09 Jan 2008: I'm presenting Testing The Database to the Triangle .Net User Group (TRINUG) Wednesday evening in Research Triangle Park, NC (location details).

12 Jan 2008: I'm presenting Incremental Loads With SSIS - by far my most popular SSIS Design Pattern post - at the Philadelphia Code Camp 2008.1.

If you read this blog and are attending, please introduce yourself!

:{> Andy