Uncategorized

SQL SERVER DATABASE LAST RESTORED DATE


use msdb;
select
h.destination_database_name RestoredTo,
h.restore_date RestoreDate,
b.database_name RestoredFrom,
f.physical_name SourceFile,
b.backup_start_date BackupDate
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

Tags: , , ,

Monday, October 4th, 2010 Uncategorized No Comments

Never ever give up……

Vijval never gives up

My son Vijval, just having some fun in London….

Tags:

Tuesday, March 23rd, 2010 Uncategorized No Comments

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”

Tags: ,

Thursday, February 4th, 2010 Uncategorized No Comments

Command to copy Directory structure (no files, just structure)

XCOPY 

/T /E “C:\SourceCode” “C:\Temp\SourceCode\”

Tags:

Thursday, February 4th, 2010 Uncategorized No Comments

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)

Tags:

Wednesday, January 28th, 2009 Uncategorized No Comments

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

Tuesday, July 15th, 2008 Uncategorized No Comments

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

Sunday, July 13th, 2008 Uncategorized No Comments

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!!

Wednesday, May 7th, 2008 Uncategorized No Comments

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.

Sunday, November 11th, 2007 Uncategorized No Comments