2012-04-21

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

2012-04-20

TSQL - Database objects and columns list


select
      -- Object
      o.name as [Object]
      , o.crdate as ObjectCreationDate
      , o.refdate as ObjectReferenceDate
     
      -- Column
      , c.colid as ColumnID
            , c.name as [Column]
      , c.colorder as ColumnOrder
      , c.type as ColumnTypeID
            , t.name as ColumnType
      , c.xusertype as ColumnUserType
      , c.length as ColumnLength
            , t.allownulls as ColumnAllowsNulls
      , c.collation as ColumnCollation
from
      -- Objects
      sysobjects o
     
      -- Columns
      inner join
      syscolumns c
      on
      o.id = c.id
     
      -- Column Types
      inner join
      systypes t
      on
      c.xtype = t.xtype
where
      -- Only tables, views, triggers and functions
      o.xtype in ( 'U', 'V', 'TR', 'TF' )
;