Photo: Old Style Car - Painting

Another great photo. Saw this great old style car at the side of the road, pulled over and ended up talking to some great ppl.

Photo: Fishing The Docks

Latest photo/painting, "Fishing The Docks" - done at: Tobermory Ontario Canada.

Photo: Mapleton Farm

Photo take in Mapleton Ontario during the long weekend.

WebApp: ClippingMagic - Online Mask creation - made real easy !

Interesting application for removing/masking out part of an image: www.clippingmagic.com

Microsoft: XBox ONE - The next generation XBox

Microsoft has revealed the next XBox. Officially called the, "XBox ONE". The specs as follows:

8 Core CPU
8GB Memory
500GB HDD
Blu-Ray
802.11n
HDMI I/O
USB 3.0

... more details to come ...

SQL Trigger: Updating a, "Modification_Date" with a Trigger

Never found a clear example online of simply updating a database's modification date with when a row is changed so I thought I would post one:

 =======================

 CREATE TRIGGER [dbo].[TRG_{TABLE-NAME}_Update_ModificationDate] ON [dbo].[{TABLE-NAME}]

AFTER UPDATE AS

 DECLARE @{UNIQUE-COLUMNNAME} [uniqueidentifier]

 SELECT @{UNIQUE-COLUMNNAME} = i.{UNIQUE-COLUMNNAME} FROM inserted i

UPDATE {TABLE-NAME} SET Modification_Date = GETDATE()
   WHERE {UNIQUE-COLUMNNAME} = @{UNIQUE-COLUMNNAME};

========================

Legend:
 {TABLE-NAME} = Name of Table to create the SQL Server Trigger on.
 {UNIQUE-COLUMNNAME} = Name of Column in table above that uniquely identifies a row.

Zabeen Hirji - What a prick !

What a prick RBC’s chief human resource officer Zabeen Hirji is. How can you defend poor hiring practice when they claim that it is not hiring foreign workers to take over the jobs of current employees, as technically those who fill the 45 jobs will be employees of iGate, not RBC. Watch this CBC Video where she lies about how RBC is, "helping" their [former?] employees. Perhaps it's a case of hire your own ? This image says it all !