from dbo.RestoreHistory h
inner join dbo.BackupSet b
on h.backup_set_id = b.backup_set_id
inner join dbo.BackupFile f
on f.backup_set_id = b.backup_set_id
order by RestoreDate desc
My son Vijval, just having some fun in London….
TFS Baseless merge(where the branches to merge are not directly related)
TF MERGE /baseless “C:\TFSMERGE\1-Development\Release 7.0\CM” “C:\TFSMERGE\1-Development\Release 8.0\CM” /recursive
Delete a Project in TFS
tfsdeleteproject /server:lon-mp-cm01 “DocManagement”
is scheduled for April 22, 23, 24. Four tracks – SQL Server/.NET/SharePoint/Business Intelligence
check it out at http://www.vconferenceonline.com/shows/spring09/sql/
you can use VIP code VCTAF503033-0 to get £10 discount! (inaddition to any earlybird discounts)
this is how I queried Oracle DB to get information about Foreign keys.
C.TABLE_NAME PARENT_TABLE,C.COLUMN_NAME PARENT_COLUMN,
A.TABLE_NAME CHILD_TABLE,B.COLUMN_NAME CHILD_COLUMN
FROM USER_CONSTRAINTS A
INNER JOIN USER_CONS_COLUMNS B
INNER JOIN USER_CONS_COLUMNS C
ORDER BY C.TABLE_NAME
If you are a VBA programmer, here is a very useful power point add-in from Microsoft that lets you rename the shapes
Download from here:
…in case you were wondering, nothing! just a normal working day in the city and the crowds gathered to grab a ?quick? lunch hour pint at the Sterling bar!!
Today is Remembrance Day (Poppy Day), the day when World War I ended in 1918!!, so I thought it’d be a good time to visit Imperial War Museum at Duxford. Really great place for a day out, if you enjoy a bit of history and watching aircrafts, fighter jets and other military equipment. You can get into the Concorde’s (G-AXDN) cockpit, take a picture next to an F16 fighter jet etc.
It has one of the finest collections of tanks, military vehicles and naval exhibits in the world, served as an airfield in the First World War and played a vital role in the Second World War as an RAF fighter station and later as an American fighter base.