ms sql

In SQL Server 2008, to see all available db backups:

select * from msdb.dbo.backupset

This is an easy way to get all rows from a SQL table into a string:

select stuff((
                  select ', ' + a_column
                      from [name_of_table]
                      order by table_id
                      for xml path('')
                  ), 1, 1, '')