Tuesday, 29 May 2012

Some Search Engine goodness

No Country Restriction
No doubt you are aware that Google.com redirects you to your country specific site for example google.ie , google.co.nz, or google.co.uk for region specific results.
If you have a need to check rankings or non region specific search results - bookmark  http://www.google.com/ncr , the alternative address for Google that will not redirect you.

This comes in handy for those who care about their site traffic or if you are one of those 'SEO consultants /nerds'  You can do this via settings too of course.

While on the subject of search...
Wanna escape tailored results?
Wanna get results without being tracked or bubbled?
Then get yourself over to DuckDuckGo friend for their internet search goodness.The search comparisons are interesting to say the least , amazing to see how much we are tracked.

"Duck Duck Go is a search engine based in Valley Forge, Pennsylvania that uses information from crowd-sourced sites (like Wikipedia) with the aim of augmenting traditional results and improving relevance."

Searching based on what friends do and say.
Try your searches in Google Plus / Google Plus Local , lets say your an academic and have lots of socialistic mates in your circles ...bang in your search terms in g+ and see what those people are saying on that topic . 

Handy if you cant form an opinion yourself , are interested in specific trends or  you just need to find a decent cup of coffee.

Wednesday, 23 May 2012

Gmail, rocking the UX

They've thought of everything, "..please find attached our response to your RFP..."

Sunday, 13 May 2012

Questionable UX of the SSIS expression builder

SSIS allows you to integrate quickly.
Microsoft obviously put huge effort into adapters for various sources and destinations - and it pretty straight forward stuff.
However some of the "small stuff" ,totally unnecessarily, becomes rocket science.
I needed to have a variable that evaluates to current date less one *calendar* month in format yyyy-mm-dd"

The,workable,end result I came up with is 408 characters for "today less a month".

Rule and expression builders should be massively simple for an end user to work with - otherwise don't bother adding them to a product.

'Expression builder' more like spaghetti builder, C# scripts all the way from now on!

(DT_STR,4,1252)DATEPART( "yyyy" , DATEADD("DD",DATEDIFF("DD",(DT_DATE)"1/2/1900",GetDate()),(DT_DATE)"1/1/1900")) +"-"+
RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , DATEADD("month",0,DATEADD("DD",DATEDIFF("DD",(DT_DATE)"1/2/1900",GetDate()),(DT_DATE)"1/1/1900") ) ), 2) + "-"+
RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , DATEADD("DD",DATEDIFF("DD",(DT_DATE)"1/2/1900",GetDate()),(DT_DATE)"1/1/1900") ), 2)