Uncategorized
Couple of useful TFS commands(Team Foundation Server)
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”
Command to copy Directory structure (no files, just structure)
Spring ‘09 SQL Server vConference
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)
Query Referential Integrity Constraints information from ORACLE db
this is how I queried Oracle DB to get information about Foreign keys.
SELECT A.CONSTRAINT_NAME,
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
ON A.CONSTRAINT_NAME=B.CONSTRAINT_NAME
INNER JOIN USER_CONS_COLUMNS C
ON A.R_CONSTRAINT_NAME=C.CONSTRAINT_NAME
WHERE A.CONSTRAINT_TYPE=’R’
ORDER BY C.TABLE_NAME
PowerPoint Add-in to Rename Shapes on Slides
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:
http://support.microsoft.com/kb/282937
What’s so special about this day at 30 ST MARY AXE (Gherkin, Swiss-Re tower)?
…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!!
Imperial War Museum, Duxford
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.
