Archive for June, 2008

Schaumburg Junior Chamber Website Redesign

When The Schaumburg Junior Chamber aka Jaycees needed a new website to replace their old html based site which had not being updated in over 4 years. I turned to a Joomla based solution. Hosted on a Godaddy server I was able to configure and deploy the site within 3 hours. The Schaumburg Jaycees is a leadership development and networking group for adults between the age of 18 and 40 in Schaumburg, Illinois

    Components Used In the site: 
    DOCman – This component allows for the chapter board to post documents for the members to image
    download such as recent newsletters and forms.
    JEvents – This component allows for the chapter board post events to the chapter calendar so
    that the members can keep up to date as to what is happening with in the chapter.
    JoomlaStats – This component allows for the chapter board and myself to monitor web traffic to the
    site. 

Check out the groups website at http://www.schaumburgjaycees.org

How to find duplicate rows in SQL Server

I ran into this problem the other day at work with duplicate rows while trying to merge data from two separate tables into the same table. I couldn’t remember so I just ran a quick search using Google and came across the solution on a Microsoft knowledge base page.

-------------------------------------------------------
The first step is to identify which rows have duplicate primary key
values:
SELECT col1, col2, count(*)FROM t1GROUP BY col1, col2HAVING count(*) > 1
This will return one row for each set of duplicate PK values
in the table. The last column in this result is the number of
duplicates for the particular PK value.

col1               col2

1                   1                   2

—————————————————————

IBM Thinkpad T20 Versus Mount Dew Episode II

Last November I spilled a 20 OZ bottle of Coke into my trustee T20 work laptop and today I did it again. Last time I bought a new keyboard off of EBay for like 10 bucks and replaced it. This image time since I’ve done this before I quickly shut off my laptop. Took out my screwdriver and disassembled my laptop removing my keyboard and rushing to bathroom and running water over it for like three minutes. After that I ran it under the dryer for what seemed like forever. Still not satisfied if it was still wet I used one of the air compressors in our office to blow out any remaining droplets of water. Then a quick reassembly and bam I’m back to work. by the way if anyone needs a keyboard for their T-20 I’ve got any extra one.

Technical Specs for my work laptop:

  • image Brand: IBM
  • Model: T20
  • Processor: 700 MHz Intel Pentium III
  • Memory: 256 MB
  • Hard Drive: 40 GB
  • Display: 14in 
  • OS: Windows XP Pro

Using ShareMaster Gadgets On Unbuntu Shares

I’ve been thinking about building a Windows Home Server but each time I come up with a reason I’m able to cancel it out with another reason why my Unbuntu server is good enough.  imageThe other I was looking around at different WHS website and I came across this really cool Windows Vista Sidebar gadget on homeserverhacks.com that allows for you save via drag and drop and directly access your directories. I though it was really cool and I wanted to build my own version that would allow to save to Unbuntu shares. So I downloaded loaded it up and I then I realized that it allows for you connect directly to the server. imageTheir for you can specify your servers name and Username and you’ll be able to save and access your files too. Just like people with Windows Home Server can do. 

Microsoft Writer

Today I came across another Microsoft product that can help you perform online task faster. This application called Microsoft Writer Live is a desktop blog-publishing application. It allows for you to post to you blog just from using a Word like interface and application. According to the Microsoft website it supports Windows Live Spaces, Blogger, LiveJournal, TypePad, WordPress, Community_Server, PBlogs.gr, JournalHome, the MetaWeblog API, the Moveable Type API, and all blogs that support RSD (Really Simple Discoverability) and if it’s not list here you can most likely download it on the website. For information about this application you can find it at the following link. One last comment on this product, I’m actually using it right now to submit this posting to this site right now.