This is one of the posts where I describe the more technical aspects of a project I've been working on. The contents here are meant mainly to trigger my own memory when needed in the future.
The HR department has requested a census report so that the company can shop around for benefits with other vendors. In typical fashion, the information needs to be laid out in such a way that none of the "canned" reports from the business system will suffice.
I know where to get the demographic information (employee ID, client ID, city, state, zip, salary, etc.), but this is the first time I've had to track down information such as premium rates, employer contribution, employee contribution, and coverage tier.
I sat with the HR director to find out where she's able to see this information. Back at my desk, I launched a SQL Server Profiler Trace, filtering to my login ID and session ID. Then I navigated to those same screens to help identify which objects in SQL Server I need to look at.
From there I've been able to target the specific tables I need for my SQL scripts.
-----
Check out my other blogs:
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
Get That Job!
QuotesBlog
Twitter.com/danieljohnsonjr
Related tags: daniel+johnson+jr
Monday, February 18, 2008
Finding Tables for Employee Census Report
New Media Cincinnati Meetup, March 2008
New Media Cincinnati meetup:
When: March 15, 2008 4:30-6:30 PM ESTThis is an informal meetup for people in the Greater Cincinnati, Northern Kentucky, and Dayton areas involved with or who have an interest in new media (podcasting, video podcasting, blogging, Facebook, Twitter, social networking, etc.).
Where: Panera Bread Company, 405 East Kemper Road, Springdale, OH 45246 (map)
Everyone is welcome to come.
For more information on the store, please visit their local website: http://www.panera-centralohio.com/
The restaurant management has reserved the meeting room for us and politely requests that the group collectively spend at least $25 while we're there. I don't think this will be a problem.
The store has free wi-fi, so feel free to bring your recording equipment and laptops.
This time around, some new media friends from Columbus and maybe elsewhere in Ohio will be meeting with us! We'll be talking about Podcamp Ohio, which will be in Columbus on June 28, 2008. Check out http://podcampohio.com for more info about Podcamp Ohio.
If you have any questions about this event, please contact:
Daniel Johnson, Jr.
(513) 373-4442
danieljohnsonjr [at] newmediacincinnati [dot] com
http://twitter.com/danieljohnsonjr
Facebook Group: http://www.newmediacincinnati.com
Google Calendar: http://tinyurl.com/2caxxp
Twitter: http://twitter.com/newmediacincy
Jaiku: http://jaiku.com/channel/newmediacincy
Flickr: http://www.flickr.com/groups/newmediacincy/
Facebook event: http://www.facebook.com/editevent.php?info&eid=9088451526
-----
Check out my other blogs:
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
Get That Job!
QuotesBlog
Twitter.com/danieljohnsonjr
Related tags: daniel+johnson+jr new+media+cincinnati
Wednesday, February 13, 2008
Open-ended questions about my blogging approach
While driving into work this morning, I began thinking about how I'm using this blog and blogging in general. I came up with some open-ended questions for myself, none of which I'm able yet to answer.
- What ways can I merge my social media/new media passion with my job as a SQL developer into a career?
- What purpose do I really want this particular blog, to which I've assigned my name, to have?
- Should I separate the new media stuff on this blog from the technical stuff?
- How easy is it for someone looking at my resume to to really see what I'm about? Are folks finding the content I want them to find over here?
- Why do I have and maintain so many blogs? Would it be worthwhile to consolidate and/or "shut down" one or more of them?
- Is Blogger the tool I want to continue to use for my online presence, or is it worthwhile to move it to another blogging platform?
- How can I best communicate the technical aspects of my work in a way that is easy for someone to understand? Do I do this for myself mainly, or do I do this to inform others, too?
-----
Check out my other blogs:
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
Get That Job! - announcing the new project How I Got My Job!
QuotesBlog
Twitter.com/danieljohnsonjr
Related tags: daniel+johnson+jr
Subscribe to:
Posts (Atom)
