Facebook - How to add a share button

As of June 2012, you can use a simple link that follows this form. 

Of course, the link can be added to your page as simple text or be offered through a graphical icon.

http://www.facebook.com/sharer/sharer.php?v=4&src=bm&u=http%3A%2F%2FDOMAIN.COM&t=TITLE

 

Teradata - All tables and column names list

This works both on tables and on views:

select

      *

from

      DBC.columns

where

      DatabaseName = 'DATABASE_NAME_HERE'

      and TableName like '%TABLE_NAME_HERE%'

      and ColumnName like '%COLUMN_NAME_HERE%'

;

HELP COLUMN DATABASE_NAME_HERE.TABLE_NAME_HERE.*;

Linux - Chown

This one command I use often to re-gain ownership of files I have added to my system through secondary hard drives.

 sudo chown -R newuser:newgroup .

TSQL - Dates formatting

Anubhav Goyal has done a great job on this...
http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/

Ubuntu - How to open a folder with root permissions

sudo nautilus

Teradata - Connection environmental variables

select database, session, account;

Sound Juicer - Increasing mp3 ripping quality

Complex interface, but once you get to the profile edit screen, just replace the mp3 profile with the following line if you want to encode using a 320 kbit/s quality.  Keep the rate to 44100 if you are ripping a CD, since that is the sample rate at which CDs are created (more would be overkill).

audio/x-raw-int,rate=44100,channels=2 ! lame name=enc mode=0 vbr=0 bitrate=320 ! id3v2mux

Sound Juicer is a free music ripper software product for Linux.
Only rip music you have the legal right to.

To learn more about compression and the mp3 architecture check Wikipedia, they have a great primer on it... http://en.wikipedia.org/wiki/MP3