30Nov

Things to make my life easier

Filed in Apple | Blackberry | Blogging | Google | Grooveshark | Microsoft | Netflix | Windows Home Server Leave a comment

I thought it was time to put together a little list of my favorite computer things i use to make my life easier.  No big deal just the things i use everyday no matter if I’m at work or at home. I find myself using these products all the time.

Hope you enjoy my list and post comments and share your thoughts

1) Evernote – I first found the app for my the iPad before i knew about the website. But it’s be came one of my favorites and there’s a desktop version and one for my blackberry too.

2) Grooveshark – This is one awesome little music service no need to download the music or playlist you can stream it from anywhere. They even have a app for blackberry’s too.

3) Click for more screenshotsiPad – Web browsing, video, music, and wide range of other things all in the palm of your hand.

  1. Flipboard – It’s like a magazine with my twitter and facebook feeds.
  2. Keynote – I can make amazing presentations on it very quickly and wow the hell out of people.
  3. RDP Lite – in case i get inspired to do some real work from it and it’s free.

4) Toggl – I love this program it helps me manage my Jaycees development task and hours.

5) Lifehacker – All around good reading and excellent tips

6) Google Doc’s – It’s like Microsoft Office but free and online.

7) Windows Home Server – Every need a file on your home pc while on the road? well this little thing can serve you up the files from anywhere anytime.

8 ) Google Chrome – it’s not just a another browser it’s one of the fastest ones out there and i like how fast it loads pages on my laptop and desktop.

02Feb

Business As Usual

Filed in Google | Jaycees/JCI | Ranting on Leave a comment

Today I’ll begin working the US Jaycees Site. My first task is to perform a Full DB backup just incase something goes wrong. This was going well  until I ran into my first problem i was unable to access the db server which is no big deal since i could get into the php admin panel.  It’s been so long since I’ve had to perform a manual backup in MYSQL. But that what they make Google for right? After getting the backup completed and burned to a CD i moved on to updated the directory and posting some new documents. While doing this  I came up with a interesting idea to keep track of my work though out the year. I’m using Google docs and created a form using the form feature to track my work which is pictured below. I really haven’t put much though into changing the site design and layout. I personally like it so lets see what people ask me to do. image

10Jun

How to find duplicate rows in SQL Server

Filed in Google | SQL | Work Leave a comment

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

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

TOP
Stop SOPA