Fraser Dowall

Rants and musings of a B.I. Professional

About

Proin accumsan urna in mi. Aenean elementum egestas tortor. Donec neque magna, auctor a, dapibus sit amet, facilisis sit amet, ligula..

Archive for December, 2008

Max Memory – VPC and Demos

Wednesday, December 31st, 2008

  Ever want to start up a VPC to do a demo and you have too many things running and want to maximize your memory. So you go into services, kill everything that you can find, close all your apps. and then you do your demo, but sometimes you kill the wrong things, or too [...]

Read the rest of this entry »

Autohotkey vs Caps Lock

Monday, December 29th, 2008

  I was hunting for a way to get rid of the issues that I was having with CAPS LOCK !! I hit the key without realizing all the time. As I try to move closer and closer to pounding out documents and code the frequency of caps lock abuse has increased. So my mission [...]

Read the rest of this entry »

Is the IPhone ready for business?

Wednesday, December 17th, 2008

  Is the IPhone ready for business? For those who know me I go through a lot of tech, and very fast. I’ve had, or tried out just about every phone technology out there. The 2 winners so far were 1) Symbian OS on a Sony Ericsson P990 2) Windows Mobile on an HTC I [...]

Read the rest of this entry »

Getting Things Done

Tuesday, December 16th, 2008

Many people ask me about technical skills and training. What I do not hear much of these days is requests for some of the more basic ‘SOFT’ skills that help everyone on a day to day basis. Everyone would like to think that they are efficient users of time, organization and email. The truth, however [...]

Read the rest of this entry »

Converting a date CYYMMDD to and from

Monday, December 15th, 2008

  I ran into a customer using the old Y2K Date that I hhadn’t seen for a while and thought that I would take a moment to blog how to convert to and from. TO :  CASE WHEN SUBSTRING(CAST(dKey_TimeByDay AS VARCHAR),1,1) = 2 THEN ’1′+ SUBSTRING(CAST(dKey_TimeByDay AS VARCHAR),3,6)  ELSE ’0′ + SUBSTRING(CAST(dKey_TimeByDay AS VARCHAR),3,6) END [...]

Read the rest of this entry »