Tag: Remember

Categories
Photo

Customer Service from ValleySchwag

Customer Service from ValleySchwag

Its one thing to keep in touch with your clients. To develop a high degree of transparency into your company, and is internals. You can take it further and let your customers know when things don’t go well ahead of time. Letting them know what to expect and how you are trying to fix it. You can monitor your email, and blog for feedback. And to take the temperature of how your clients feel about you. These are all things that help you understand the environment you are working in, and how well you are doing. RubyRedLabs, more specifically ValleySchwag takes this aspect very seriously, so seriously in fact they make a point of continually responding to the comments of there customers.

What impresses me is a letter I received in the mail this weekend. Earlier in the week, I posted on the ValleySchwag blog "Although I would have loved a RubyRedLabs sticker. O’ well maybe next time. ;-)". I was not expecting to get a hand written letter from Amy. WOW! Do you know how long its been since I’v received a hand written letter form some one I was not intimate with? (I don’t think its ever happened).

So, I will take this as a lessen, and make a point to begin writing letters to clients. With luck, I will be able to affect some of my clients in the same way.

Thank you Amy @ Valleyschwag

Posted by Al Pritchard on 2006-09-05 23:58:05

Tagged: , rubyredlabs , remember , customer , service

Categories
Photo

Customer Service from ValleySchwag

Customer Service from ValleySchwag

Its one thing to keep in touch with your clients. To develop a high degree of transparency into your company, and is internals. You can take it further and let your customers know when things don’t go well ahead of time. Letting them know what to expect and how you are trying to fix it. You can monitor your email, and blog for feedback. And to take the temperature of how your clients feel about you. These are all things that help you understand the environment you are working in, and how well you are doing. RubyRedLabs, more specifically ValleySchwag takes this aspect very seriously, so seriously in fact they make a point of continually responding to the comments of there customers.

What impresses me is a letter I received in the mail this weekend. Earlier in the week, I posted on the ValleySchwag blog "Although I would have loved a RubyRedLabs sticker. O’ well maybe next time. ;-)". I was not expecting to get a hand written letter from Amy. WOW! Do you know how long its been since I’v received a hand written letter form some one I was not intimate with? (I don’t think its ever happened).

So, I will take this as a lessen, and make a point to begin writing letters to clients. With luck, I will be able to affect some of my clients in the same way.

Thank you Amy @ Valleyschwag

Posted by Al Pritchard on 2006-09-05 23:59:12

Tagged: , rubyredlabs , remember , customer , service

Categories
Software

SFWGHO – A Way to Remember the Order of Commands in SQL

The Problem – SFWGHO

When writing T-SQL, Microsoft’s take on the SQL database language, the commands have to come in a certain order. This is:

– SELECT (selecting data)

– FROM (stating which table to get data from)

– WHERE (any filtering conditions)

– GROUP BY (specifying any aggregation to perform)

– HAVING (any filtering to perform on aggregated data)

– ORDER BY (which order to display the final rows in)

It is vital that you put these commands in the right order, otherwise you’ll get a syntax error. The acronym for the commands is SFWGHO, so it’s really just a question of finding a way to remember this series of letters.

Solutions

When he first met this problem, the author of this article trawled the Internet for acronyms. I found one site which was running a competition, with one entrant:

Slippery Fish Will Garnish Hungry Orcas

Surely there must be better acronyms than that! A little reflection came up with the following ideas:

Six Fat Wives Gross Husbands Out

Sweaty Feet Will Give Horrible Odours

Out of these, the second seems better (it’s certainly in better taste!). So here is our recommendation for how to remember the order of commands in SQL:

SWEATY or SELECT

FEET or FROM

WILL or WHERE

GIVE or GROUP BY

HORRIBLE or HAVING

ODOURS or ORDER BY

So now there’s no excuse for getting the order of SQL commands wrong, we just need to find a way to remember to put commas in the right place all the time…



Source by Andy J Brown