SQLPam's Blog

October 24, 2011

Give Camp Tampa – 2011

Filed under: Community — sqlpam @ 4:13 pm

This past weekend I had a new experience.  Although I have frequently been involved in work for charities, I found a new opportunity.  I was able to use my technical skills for a deserving group. 

David Liebman organized the GiveCamp Tampa.  He worked with DeVry University to supply the location and a number of sponsors to provide food and swag for the participants.  He was able to coordinate with 2 groups for us to supply services.  The first effort was to build a web site for the Conrad schools out of Orlando.  They are a school that assists special needs kids.  The second effort was a BI Proof of concept project for the FL Children’s Services Council.  This group advocates on behalf of children across most of the larger counties in the state to provide assistance for kids and their families.

We split the group into teams. we had 4 developers and charity sponsor on each team.  The developers who knew .Net took on the web page.  They developed a site that the sponsor was extremely pleased with.  When finished – they trained her on how to maintain it.  They seemed to have the easy project – but I heard there was one grumble about not writing much code since they used Dot Nuke for the site.

I went with the BI team.  It was an ambitious project.  Just getting things set up to start work took all of Friday evening and most of Sat morning.  We then hit our stride and split the ETL up so that each of us created at least 2-3 SSIS packages to transport the data into the warehouse.  Jose Chinchilla then led the effort to build the cube.  We started on Shore Point and reports on Sunday morning.  As usual, the reports reveals issues with data and structures – but these were worked thru quickly.  The proof of concept was begun – but it needs more work.  The sponsor was very pleased to have such a great start of the project.

I learned a lot from the process.  There are so many ways to approach any task.  Pulling together a team of volunteers lets each see the approach their fellow volunteer takes and expands future options.  I will definitely look forward to next year’s Give Camp.

A big THANKS to all who participated in their local GiveCamps across the US and rest the world.  I hope it grows bigger next year to assist many other organizations.


October 2, 2011

Tally Code Camp – I was there but not really

Filed under: SQL Saturday — sqlpam @ 2:48 am

Today I had the pleasure of speaking at Tallahassee Code Camp – but I was unable to attend.  Huh?  I led the meeting via Go To Meeting.  It is probably my least favorite speaking mechanism – but it is fast becoming a blessing for those in more out of the way locations.  I have to say that today’s session was my favorite online session I have led to date.

We got a late start because there were issues with the sound in the room – but once we got started it glitch free – at least as far as the technology.  I made a few boo boos that were easily recovered – but Go To meeting and the related technology work flawlessly once we got going.

The big thing for me was that the audience actually actively interacted.  This is something I have missed in all of my previous presentations.  I was able to get a feel for the how the audience was reacting based on the questions that were being asked.  I would still prefer to be there in person – but this was a nice second choice.

I want to thank Maureen Jugenheimer for offering the remote opportunity to participate in an event I was not able to physically attend.  She made sure the technology worked and actively moderated the session.  I look forward to meeting her in another week or so at PASS Summit.

Create a free website or blog at WordPress.com.