Blog a Day May - Productivity

Published 01 May 11 05:19 PM | MartinCroft


I have decided after unsuccessfully not blogging once this year to blog each day in May. The simple premise is that I have got to blog at least once ( can't see me doing it more than once but who knows) daily and be of useful content, maybe the first one can be excused till I get back into the swing of things.

In an attempt to get more productive I have come across several useful tools. Drop box  you can sign up for a free account and get 2Gb of free space, this allows you to add to every machine you use a folder that keeps all items in that folder in sync across all machines/ phones and in the cloud. So if I drop in a SQL script, word document its sync'd between all my machines and also I can access through my Android phone, also other smart phones are available!. If you get 8 friends to sign up (its free) you can get another 250Mg per friend up to another 8Gb, now it becomes useful unless its blocked through work!

There is an action management system called Get things Done GTD  which the basic principle of The Getting Things Done method rests on the principle that a person needs to move tasks out of the mind by recording them externally. That way, the mind is freed from the job of remembering everything that needs to be done, and can concentrate on actually performing those tasks. You set next physical actions which is where Springpad comes in, this can be accessed through the web or an Android App and possibly the other one as well !.

One thing I have seen all over the show was delicious but never actually look into what it is Delicious , well Its a pretty cool tool for recording bookmarks and finding new and interesting resources. You can add tags to make finding bookmarks easier. You can add to the browser tool bar and click on "Bookmark on delicious " as your about to leave the office and pick it up again at home.  Another useful one is ( Android only) is Chrome to Phone install it into Chrome and with a single click whatever webpage is on display its sent directly to your phone great as your dashing for the train.

Anyway I should at least post something SQL related so here it is. 

Retrieve the nth smallest or greatest number in a table

DECLARE @item TABLE (ItemID INT IDENTITY(1,1), n int )

--Some randomish numbers

INSERT INTO @item (n) Values (1),(2),(4),(8),(56),(128),(256)

--(n -1) will return the nth smallest number

--changing the < to > can get the largest nth number

SELECT n FROM @item a WHERE (5 - 1)

= (select count(*) from @item b where b.itemid < a.itemid)

I am sure i'll be a  dab hand at this by the end of May, but I have so much fun with with this first post, chrome does not handle the formatting, and ie9 kept crashing as I was trying to paste in the SQL code and the formatting was horrendous, then I tried Firefox and I eventually managed it. 


No Comments