Please update your bookmarks to reflect the new location for the blog: http://danieljohnsonjr.com/main
If you use a feed or news reader, please add the RSS feed: http://feeds.feedburner.com/DanielJohnsonJr
Welcome to my online portfolio, the complement/substitute for my resume. The opinions included herein are my own and do not reflect those of any client or employer, past or present. Please check out the new site: http://danieljohnsonjr.com
- 401(k) report (7)
- accounting (1)
- administrivia (11)
- ADO (1)
- announcements (6)
- audio (1)
- batch files (1)
- benefits audit (2)
- blogging (8)
- branding (7)
- bridge application (17)
- business intelligence (7)
- cincinnati (6)
- client relations (4)
- community (1)
- competitive intelligence (2)
- conference (3)
- conversions (2)
- dashboard (3)
- data warehousing (1)
- design (4)
- documentation (2)
- financial reporting application (3)
- first post (1)
- get that job blog (2)
- global consumer products company (3)
- idea generation (2)
- integration manager (2)
- jazzmania productions (1)
- lessons learned (3)
- meetup (9)
- mentoring (3)
- microsoft great plains (5)
- music (2)
- nafta (1)
- networking (2)
- new media (22)
- payroll (6)
- peo (33)
- podcamp (3)
- podcampohio (2)
- podcasting (8)
- presentation (1)
- programming (31)
- public relations (1)
- public speaking (1)
- questions (1)
- requirements (4)
- search tool (3)
- social media networks (7)
- SQL (9)
- testing (1)
- training (1)
- troubleshooting (7)
- trucking (2)
- twitter (9)
- uml (1)
- VB.NET (2)
- VBA (1)
- wikis (1)
Monday, September 22, 2008
This blog has moved!
Posted by Daniel at 3:33 PM 0 comments
Topics: administrivia, announcements
Thursday, August 28, 2008
Awesome time at LinkedCincinnati LIVE last night
- Had a tremendous time meeting lots of new people at LinkedCincinnati LIVE last night! I do hope our connections will be mutually beneficial, and I look forward to keeping in touch.
More information aboutPlease check out the LinkedCincinnati LIVE Online Silent Auction.will be coming soon.- Next New Media Cincinnati meetup will be Saturday, September 20, 2008 from 2-4 PM at Buffalo Wild Wings in Norwood, Ohio. More information to be found at http://newmediacincinnati.com/ and http://newmediacincinnati.wetpaint.com/
- Follow me on Twitter: http://twitter.com/…ljohnsonjr
- Send DANIELJOHNSONJR to 41411 to get my contact information, if you didn't get it last night.
Mobile post sent by danieljohnsonjr using Utterz. Replies.
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr linkedcincinnati
Posted by Daniel at 8:29 AM 0 comments
Topics: cincinnati, meetup, networking
Wednesday, August 27, 2008
LinkedCincinnatiLIVE Tonight!
Tonight I and over 200 other folks from the Greater Cincinnati area will be meeting together for LinkedCincinnatiLIVE (more details below). I am so glad, too, that my schedule freed up at the last minute for me to do so. I hope to connect with as many of you as possible.
Here is a recent picture of me, in case you're looking to connect:
LinkedCincinnati LIVE - Details
If you have not signed up for LinkedCincinnatiLIVE tonight, August 27th, you need to do so right away! Over 200 attendees have pre-registered, and we’ve got some seriously incredible items up for grabs in the silent auction.
For those in the local recruiting community, we have a FULL ADMISSION ticket to SourceCon 2008 in Atlanta in just one week for auction, a FULL ACCESS ticket to ERE’s Fall Expo in Hollywood Beach, FL at the end of October, AND a ticket to RecruitFest coming up in Toronto on Sept. 19th. The RecruitFest ticket is worth $220, the SourceCon admission ticket at $1,195 and the ERE Fall Expo ticket at over $2,000. You’ll want to make sure to come to LinkedCincinnatiLIVE and put your bid in for one of these can’t-miss events!
In addition to these event tickets, we have some really cool things that will be on the auction tables, including:
- Design/promotional/marketing consulting services
- Recruiting services
- SEO consulting services
- DBA services
- Skin consultation services
- A B&B weekend package in WV
- A guided upland hunting trip
- Books written by some of our attendees
- A private flight tour from a local pilot
- …and much more!
Our auction items range in cost from around $10 all the way up to $3500 so there is something for everyone to check out. Business owners and managers, consider bidding on some of the consultative services for your company.
Don’t miss this opportunity to meet other local professionals in the Cincinnati area (and beyond – there are people from as far away as Florida attending!). Bring your business cards and get ready to mingle! Hope to see you there!
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr linkedcincinnati
Posted by Daniel at 8:58 AM 1 comments
Topics: cincinnati, meetup, networking
Wednesday, August 20, 2008
Special Date Functions in SQL, Part 1
For our internal dashboard work, we're looking at metrics for the previous month. While I could create a SQL Server stored procedure to pass these dates from a user form, I really want to create a SQL view that will show last month's information. That way, whenever the view is opened, it always shows data for last month.
I know in VB that there are FirstDayOfMonth and LastDayOfMonth functions, but I've been unable to find similar functions in SQL. In my research, I've found "Date and Time Manipulation in SQL Server 2000" helpful. I came up with this SQL:
It returns these results:
SELECT
CAST(CONVERT(CHAR(10), DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),101) AS smalldatetime) AS StartDate,
CAST(CONVERT(CHAR(10), DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),DATEADD(mm,1,GETDATE())),101) AS smalldatetime) AS EndDate,
CAST(CONVERT(CHAR(10), DATEADD(dd,-(DAY(DATEADD(mm,-1,GETDATE()))-1),DATEADD(mm,-1,GETDATE())),101) AS smalldatetime) AS PrevMonthStartDate,
CAST(CONVERT(CHAR(10), DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),GETDATE()),101) AS smalldatetime) AS PrevMonthEndDate
StartDate | EndDate | PrevMonthStartDate | PrevMonthEndDate |
---|---|---|---|
2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-07-01 00:00:00 | 2008-07-31 00:00:00 |
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr sql+server
Posted by Daniel at 3:00 PM 0 comments
Topics: business intelligence, dashboard, SQL
Tuesday, August 5, 2008
Thursday, July 31, 2008
Moving to WordPress!
Hi folks! I am making the move from Blogger to WordPress, so if things may get a bit wonky in the meantime.
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr
Posted by Daniel at 7:23 PM 2 comments
Topics: administrivia, announcements
Monday, July 28, 2008
New Media Cincinnati - August 2008 Meetup Information
At the request of several of the members, we are moving the location to be more central to the Cincinnati area.
New Media Cincinnati meetup:
When: Saturday, August 9, 2008 2:00-4:00 PM EDTThis 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.). The purpose of the group is to promote awareness of new and social media in area.
Where: Panera Bread Company, 3806 Paxton Avenue, Cincinnati, OH 45209 (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 (audio and video) and laptops.
** If you're unable to make it to this meeting but have some opinions, or if you have any specific announcements you'd like to make, please contact me.
If you have any questions about this event or the group in general, 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/
Wiki: http://newmediacincinnati.wetpaint.com
Facebook event: http://www.facebook.com/event.php?eid=21878733892
-----
Check out my other blogs:
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
Get That Job!
QuotesBlog
Twitter.com/danieljohnsonjr
Interesting Things I've Read
Are we LinkedIn?
Related tags: daniel+johnson+jr new+media+cincinnati cincinnati+meetup
Posted by Daniel at 11:38 AM 1 comments
Topics: announcements, meetup, new media
Tuesday, July 15, 2008
Business Intelligence and Data Warehousing TeleForum Notes
Today I participated in a NOREX member TeleForum on Business Intelligence (BI) and Data Warehousing (DW). I'm including my notes taken here:
- Started off by defining BI and DW. I like the Wikipedia definitions myself. Also discussed what Master Data Management is; i.e., managing data that has become aged and may or may not be needed as much as current data. (The company I currently work for doesn't really think of what I do as BI and DW, but developing Decision Support Systems (DSS) is really at the crux of what I do here.)
- Two polls on where participants are in implementing BI and DW in their organizations. Most are either currently using or evaluating, versus implementing.
- Discussed scope of data definition and data modeling that should be done before getting into BI/DW. One caller will be building theirs from scratch versus buying something that was developed for someone else in their industry. (I wonder if different BI solutions have been developed for different industries.) Data cleansing is so vital when doing modeling. (Amen to that!)
- Discussed risks in software selection and implementation. Licensing brought up as part of risk. Making sure that appropriate number of licenses (user vs site) important. How solution builds report cubes (pre-calculated or built at run-time) can affect performance and user experience. sBase(?) mentioned.
- Practical support from vendors also brought up as consideration. Everything works great at the demo, but on the implementation there could be issues. Ask for references. NOREX mentioned that's part of the service they provide for members.
- Discussed tools that are used, and pros and cons of each. One member mentioned Sybase IQ. Others are using Business Objects, SQL Server Reporting Services, and Oracle tools. Crystal Reports also mentioned.
- Someone asked for experience with the Obvient strategies tool. No one on the call mentioned having any experience.
- Any local government entities using data mining tools? No one on the call had any comments. Topic to be passed on to the government members outside the call.
- SQL Server 2005 Analysis Services - how is it being used, other considerations. Has a lot of capability and interacts well with Visual Studio. Another member, however, saw a demo at Microsoft- some problems with creating a cube and error messages hard to decipher.
- Discussed how to implement SQL Server Reporting Services through Sharepoint. (We use Windows Sharepoint Services as our company's intranet and are looking at how to do this.) No one on the call had any expertise to offer.
- Discussed whether anyone uses Excel 2007 as a BI client. Some of the new functionality of Excel lends itself to an entry-level BI implementation. Some accountants in one organization using Excel to manipulate data from their other BI system. No one taking advantage of the BI capability yet. Concerns raised about quality of data, security, and versions.
- Poll on whether anyone using SAS to access Star Schema data: dimensional modeling vs entity-relationship modeling. (Not really applicable to us in our organization.)
- Release management best practices from Dev and Test to Production environments sought. How to manage things that are not necessarily files that can be version-controlled? Really speaking about reports and dashboard components.
- One member mentioned his process is such that a developer will create a report and work from it at his desktop. Then when it's ready for deployment, he will publish it.
- Other members mentioned a more rigid change management structure with development, QA, and production environments. (I guess it depends on the specific tools and systems being used.)
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr
Posted by Daniel at 10:29 AM 0 comments
Topics: business intelligence, conference, data warehousing
Friday, July 11, 2008
My 15,000th Update!
I would consider myself - and many others would probably agree - a power user of Twitter. I update over there. A LOT. In fact, I recommend that those who start following me immediately turn off device notifications, unless they have an unlimited text plan.
Twitter by far is THE most useful tool in my social networking arsenal. I know for a fact that actual business has been conducted through my use of Twitter.
I started using it back in August 2006, so I have had ample time to grow and develop community. Imagine my surprise earlier when I saw something magical about to happen:
danieljohnsonjr Whoa. My next tweet will be my 15,000th. Send me an @ reply and I'll put you in it. You have 10-15 mins. Starting.... now. 17 minutes ago from webI initially thought I'd be able to string everyone who'd replied into a 140 characters or less message. I mean, what's the likelihood that many people would be paying attention at that precise moment. I must have forgotten what my previous post said:
danieljohnsonjr Okay, now, where are all you followers coming from? 20 minutes ago from webI checked and I have close to 2100 people following my updates. Some are dormant accounts or may have not updated in awhile, but still, that's a lot of potential people to see my 14,999th post.
So, since I couldn't fit everyone into a 140-character "tweet", I hope this suffices. Thank you so much for enriching my experience thus far. I sincerely hope I've been at least half as valuable to you as you have been to me. Here are the people who replied, in the order they came in:
- radiodaniel: @danieljohnsonjr I want in:-)
- doctoranonymous: Hi @danieljohnsonjr. Have a great weekend!
- jaymartinez: @danieljohnsonjr tweeeeet
- purpletrout: @danieljohnsonjr Congratulations Daniel!
- writer_mom_tn: @danieljohnsonjr heya! :)
- melgallant: @danieljohnsonjr congrats on the tweet record!
- chrbutler: @danieljohnsonjr Congrats on the 15,000th tweet!
- TeriLussier: @danieljohnsonjr nice tweet up! ;-)
- cossondra: @danieljohnsonjr put ME in there :-) we are such nerds arent we??
- audiojunky: @danieljohnsonjr haha congrats on the 15,000...thats a lot im reaching my 1,000 soon
- kate_the_great: @danieljohnsonjr OOH! Pick me! Pick me!!
- zaldor: @danieljohnsonjr 15000 tweets?! That's insane! Congrats! And here i'm not even at 5k!
- justinrains: @danieljohnsonjr Pick me!
- kflake: @danieljohnsonjr congrats on the 15,000th tweet!
editvdo me, too...me, too...me, too
and this message that came in while I was typing up this post:
akirk45239: @danieljohnsonjr I'm late. I'll go for the 15,001st. Congrats from Monfort HeightsThank you and everyone else I know from Twitter for making it a fun journey thus far. Now, onto that 15,001st update.
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr twitter social+networking
Posted by Daniel at 2:29 PM 1 comments
Topics: community, new media, social media networks, twitter
Thursday, July 3, 2008
Managing Multiple Online Identities - Podcamp Ohio Presentation
Here is the presentation I gave at Podcamp Ohio, entitled "Managing Multiple Online Identities", and the folks from Coefficient Media recorded the audio and have posted it to the Podcamp Ohio Podcast.
Thank you to everyone who attended the session! I feel like I learned at least as much from you as you may have learned from me.
The presentation has been getting some buzz from others in the blogosphere:
- PodCampOhio - Daniel Johnson Jr. - Managing Your Online Identities
- Introduction to Pod Camp...
- Managing Multiple Online Identities (Podcamp Ohio)
- So you think you can blog
- RobRutkowski: Attending Managing Multiple Online Identities presented by @danieljohnsonjr.
- sMoRTy71: @danieljohnsonjr is having everyone introduce themselves. Nice mix of people in this session.
- shannanb: @podcampohio Just met the man- @danieljohnsonjr He's presenting a session on managing online identities.
- theRamenNoodle: pod @danieljohnsonjr has a packed out house for his talk on managing multiple identities. I better go see what my other ones are doing.
- Argon52: My friend @danieljohnsonjr is looking hot during his talk right now! Boo yeah!
- sMoRTy71: http://twitpic.com/2w4m - @danieljohnsonjr just showed the Profilactic home page during his session.
- shannanb: @danieljohnsonjr presentation on managing multiple online identities. Great presentation. Learned a lot.
- tw3nty3ight: Great session from @danieljohnsonjr It was a good time!
- kilodelta: @danieljohnsonjr Good luck with your talk! Wish I could be there, but knowing you, there will be a recording!
- ays: really enjoyed @danieljohnsonjr preso!
Also, if I've missed your link and you'd like me to include it, please leave it in the comments. Thanks again!
[IMG] "Startin' the day with @DanielJohnsonJr" by AnnOhio
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr podcampohio social+media presentation public+speaking
Posted by Daniel at 9:14 PM 0 comments
Topics: podcamp, podcampohio, presentation, public speaking
Wednesday, July 2, 2008
New Media Cincinnati July 2008 Meetup/Picnic!
Who wants to come to a new media picnic/party? What happens at one of these events?
The Buehlers are opening up their home from 4:00 PM to whenever on Saturday, July 12, 2008 for the First Annual New Media Cincinnati Picnic
JTM Burgers and dogs will be provided along with all the condiments, some baked beans and a macaroni salad or two, just to make sure the picnicking basics are covered.
We will be outside, but John will have a couple of fair sized tents setup to keep the sunburn factor down. He will see if he can find a wireless access point and run it out the back door to improve wireless access.
John Buehler's (the 10MinuteLesson Guy) houseWHAT SHOULD YOU BRING?
6543 Jayfield Drive, Hamilton (Fairfield Township), OH 45011 (map)
- Bring a chair, or you'll find yourself sitting on the ground!
- Bring whatever you would like to drink - Adult beverages too! (Please drink responsibly ;-)
- Bring a dish to pass or a bag of chips if you get a chance - Don't go overboard, there's always too much food leftover at these things!
- Bring your family
- Bring a friend or two who are interested in new media
- Bring a tip/trick/website/other new media item you've recently learned about to share with the group
- If you recently attended Podcamp Ohio, come ready to share your thoughts on the experience with those who were not able to attend.
If you have specific questions about this particular event, please contact John Buehler at john [dot] buehler [at] 10minutelessons [dot] com
For questions or comments about the group in general, please contact:
Daniel Johnson, Jr.
(513) 373-4442
danieljohnsonjr [at] newmediacincinnati [dot] com
http://twitter.com/danieljohnsonjr
ABOUT NEW MEDIA CINCINNATI
New Media Cincinnati is an informal meetup group 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, micro-blogging, social networking, etc.). Members come together to network and share thoughts and tips on using new media.
Wiki: http://newmediacincinnati.wetpaint.com
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/
[IMG] "Sunday Picnic" by su-lin
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr podcampohio podcamp+ohio newmediacincy new+media+cincinnati meetup
Posted by Daniel at 5:43 AM 2 comments
Topics: meetup, new media, podcamp, podcampohio
Monday, June 30, 2008
Thursday, June 26, 2008
Preparing for PodCamp Ohio with the Jeff Pulver Method
This Saturday I and my family will be attending the very first PodCamp Ohio. This will be my first time at a PodCamp.
I was reminded by Chris Penn of Jeff Pulver's method for preparing for an upcoming conference.
JOIN the Community. I've been involved in promoting the event and am speaking in one of the sessions. I'll be there representing New Media Cincinnati, of course.
Set your GOALS. I am looking to connect with other bloggers, podcasters, and folks in social media and re-connect with folks in Cincinnati. I am especially looking to connect with people who have been successful in merging programming skils and new media technologies in their jobs, since that is where I'm heading.
Say HELLO. Hi there. There are several ways you can get in touch with me. Here are a few:
CHANGE your eMail Habits. I definitely won't be checking email much - if at all - during the event, but I'll try to stay in touch where I can. The best way to track me down is via telephone or a direct msg on Twitter. Call me. I'll catch up with emails when I get back home.
STUDY the Map of the conference. Google Maps says it will take us about 2 hours to get to PodCamp Ohio from our home. We'll probably allow 2.5. Gonna print out what I can to take with us.
Be AWARE of the Event Schedule. Be in CONTROL of your Schedule. ALLOW for serendipity. The session I'll be conducting is in the first time slot. Aside from that, I like that the event is occurring in one spot, which means that it will be easy to move around from session to session if I want. It also means that there will be opportunities for serendipity to happen.
Don't be SHY. Contrary to what I might convey online, in a crowd of people it still can be easy for me to be shy. I'll make an effort to meet and talk with as many folks as I can, understanding that a single conversation will still make a difference. I'm not going to be one of those guys who constantly scans the crowd for the next person to talk to.
BRING Business Cards. Taken care of. If you want a business card, come and meet me.
Understand some meetings will not HAPPEN. This is something I've sometimes struggled with whenever I attend meetings like this. I've sometimes hesitated even reaching out to others because there is so little time. Nevertheless, I hope to keep realistic expectations.
ENJOY yourself. Okay then. Our family is considering this a mini-vacation. Sort of.
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr podcampohio podcamp+ohio conference unconference
Posted by Daniel at 11:00 PM 0 comments
Topics: conference, new media, podcamp
Thursday, June 19, 2008
Is social networking bringing us closer together?
Jacob posted a great question on LinkedIn:
Social Networks, Bringing Us Together or Keeping Us Apart?Here's what I offered:
Good question, Jacob!What do you think? Are social networking tools bringing us together or keeping us apart?
I still believe that the telephone is one of the best social networking tools around, and, at least for me, there is a point when you want to take your online connections into the real world. Last year, I began creating opportunities to network away from the computer.
During the week, I meet with folks I've met through social media periodically for lunch. Last October I founded New Media Cincinnati, a meetup group for folks interested and passionate about new and social media to get together. We hold conversations in real life and online.
Social networks are the people; not the tools themselves. The tools exist just to facilitate the real-life connections.
[IMG] New Media Cincinnati - April Meetup by danieljohnsonjr.
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr jacob+morgan social+networking linkedin
Posted by Daniel at 9:02 AM 3 comments
Topics: new media, social media networks
Wednesday, June 11, 2008
Tuesday, June 10, 2008
Troubleshooting with SQL Profiler
One of the Payroll Specialists called us today, wondering if her session in Darwin was hung up and needed to be killed. Darwin, as I may have mentioned before, is a Microsoft Great Plains Dynamics product customized for the Professional Employer Organization (PEO) industry. We have SQL Server as the back-end.
The IT Manager asked me to put a trace on her session in SQL Profiler so that we could ascertain whether her session was indeed hung or not. As I saw the actions scrolling on the screen, I called the Payroll Specialist and told her whatever she was doing was still processing.
I began examining the items in the trace to see what was going on. For those that are unfamiliar, GP Dynamics hasn't named their tables, views, and stored procedures in a very intuitive way. Nevertheless, I have been able to deduce from their stored procedure naming convention the base tables involved.
In addition, this exercise has helped me learn and understand SQL programming better. I usually open the procedure as a script in a Create New SQL window. Inside these procedures that were being executed in the trace, I saw nothing more than a serious of SELECT statements. It looks as though Darwin (or really the code behind it) is getting information from the table in groups of 25 at a time.
This particular recordset has close to 5000 rows. Getting 25 rows at a time means that it will execute this stored procedure 200 times. If the program takes 5 seconds to execute each batch, then it will take about 17 minutes to go through the entire recordset. I guess it's no wonder that the process seems hung to the user.
I'm guessing that something is going on behind the scenes as Darwin is preparing and and posting a payroll. Unfortunately, I don't have access to the code behind it. This may be something we'll want to bring up with Thinkware, the vendor who provides this software to us.
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr microsoft+great+plains sql+server sql+profiler peo
Posted by Daniel at 3:51 PM 0 comments
Thursday, May 29, 2008
Successful online monitoring with Google Alerts and RSS
Are you using Google Alerts and RSS feeds to track your company's presence on the internet? How about competitors?
Since this blog reflects me personally, I choose to omit specific company names. As the disclaimer says, opinions and thoughts expressed here are my own and not of any employer, past or present.
A few months ago I set up some Google Alerts and RSS feeds to track mentions of the company as well as its other web properties, and the names of key management personnel. Also, at the management's request, I set up some additional alerts for another company against whom the company has taken legal action.
Most of the time I get false positives or results I'm already aware of. Yesterday, however, I saw an article (and several subsequent links to it via Google Alerts/RSS feeds) about that other company and forwarded it to the COO.
I received this email a few minutes ago (emphasis added by me):
Dan,Rich Palmer recently shared some good thoughts on Google Alerts, too:
Your article yesterday on [THE OTHER COMPANY] was great. I shared it with [THE OWNER OF OUR COMPANY] and there was information in that article that our attorney did not know about.
Thank you!
[NAME]
Chief Operating Officer
For more information, check out the NewPR Wiki: What Should Every Company Be Monitoring? page.
-----
Check out my other blogs:
Daniel Johnson, Jr.
Get That Job!
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
QuotesBlog
Twitter.com/danieljohnsonjr
Connect on LinkedIn
Interesting Things I've Read
Related tags: daniel+johnson+jr google+alerts rich+palmer pr public+relations
Posted by Daniel at 9:19 AM 1 comments
Topics: business intelligence, competitive intelligence, public relations
Tuesday, May 20, 2008
New Media Cincinnati - June Meetup!
When: Saturday, June 7, 2008 4:00-6:00 PM EDTThis 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 (audio and video) and laptops.
** I'd like for us to spend some time share some ideas on where we would like to go with the group. The usual free-for-all conversations will naturally follow.
** If you're unable to make it to this meeting but have some opinions, or if you have any specific announcements you'd like to make, please contact me.
If you have any questions about this event or the group in general, 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/event.php?eid=17902141371
-----
Check out my other blogs:
Journey Inside My Mind Blog
Journey Inside My Mind Podcast
Get That Job!
QuotesBlog
Twitter.com/danieljohnsonjr
Interesting Things I've Read
Are we LinkedIn?
Related tags: daniel+johnson+jr new+media+cincinnati cincinnati+meetup
Posted by Daniel at 9:33 AM 1 comments
Topics: announcements, cincinnati, meetup, new media
Friday, May 16, 2008
Utterz from the Road - An Epiphany
Mobile post sent by danieljohnsonjr using Utterz. Replies. mp3
Posted by Daniel at 9:16 AM 0 comments
Tuesday, May 13, 2008
Monday, May 12, 2008
Wikis and New Media Cincinnati?
I've been thinking about wikis lately, and these two videos have strengthened my interest in them:
Wikis in Plain English
WetPaint in Plain English
I've been thinking about the New Media Cincinnati community a lot lately, especially with respect to some things related to planning meetups. I've been getting a lot of suggestions via email (danieljohnsonjr at newmediacincinnati dot com), Twitter (@newmediacincy and @danieljohnsonjr), IM, Facebook discussion threads, etc. I keep wondering if using a wiki would be an easier and more efficient way.
So I asked the folks who follow me on Twitter, "Are you using wikis in your work/personal life? If so, how so?"
Here are some replies:
- claynewton @danieljohnsonjr I use wikis for work to manage deliverables and specs; in my personal life I use them to build knowledge w likeminded folks
- JeremyLuebke @danieljohnsonjr Recording of tech / design work fro websites
- davesnyder @danieljohnsonjr i use a wiki to store all of my optimization and social media strategies for my site. It is viewable by the company
- clq @danieljohnsonjr I have a personal wiki hosted on godaddy with notes, important usernames I hardly ever use, and anything else I think of.
- winemedineme @danieljohnsonjr my production department uses a wiki for templates.
- SuzyMiller @danieljohnsonjr Planning to use a wiki to develop sustainability policy for my small business.....
- writegirl @danieljohnsonjr I use wikis for both volunteer groups I'm involved in. It's better than exchanging 1000 emails back and forth.
- annezieger @danieljohnsonjr my company uses a wiki to share information not only among coroprates, but subsidiaries too
mjenkins We use a Wiki for the online staff at the Enquirer for storing and updating our production processes and best practices. It's helpful.
I asked if I could use her message in this post, and she replied:
mjenkins Sure, go right ahead. We are looking to expand the use of our Wiki across all departments (ads, HR, etc.) soon.
I also noticed some buzz on Twitter via Tweetscan related to wikis and shared that:
danieljohnsonjr Tweetscan twitter buzz about wikis: http://tinyurl.com/5koupw
After all these responses, I asked: "Related wiki question (thx for your help so far): which sites are you using to create/manage your wikis?" Here are a couple of the responses:
- clq @danieljohnsonjr Creating a wikimedia one on any server that supports databases is really easy. I use my own space on Godaddy, Works fine.
- sharemefg @danieljohnsonjr I have used tiddlyspot to manage my tiddlywiki hosting however since tiddlywiki has no server stuff could use googlepages
newmediacincy How might @newmediacincy use wikis?
danieljohnsonjr @newmediacincy Suggestions for meetup times/locations? about 1 hour ago from twhirl in reply to newmediacincy | ||
SteveGerl @newmediacincy: Contests where people have to post something, perhaps? about 1 hour ago from web in reply to newmediacincy |
Should we put together a wiki for New Media Cincinnati? Feel free to continue the conversation in the comments below.
-----
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 wikis twitter new+media+cincinnati
Posted by Daniel at 2:10 PM 0 comments
Topics: cincinnati, new media, twitter, wikis