Blog - StewART Whaley
A Digital Nomad.
Wednesday, May 22, 2013
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
Tuesday, May 21, 2013
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 ...
8 Core CPU
8GB Memory
500GB HDD
Blu-Ray
802.11n
HDMI I/O
USB 3.0
... more details to come ...
Wednesday, May 15, 2013
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.
=======================
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.
Monday, April 8, 2013
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 !
Friday, March 8, 2013
Mac: Magic Mouse and Windows 7
Trying to get your Apple Magic Mouse working on Windows 7? This did it for me.
Labels:
Apple,
Magic Mouse,
mouse,
Windows,
Windows 7
Wednesday, February 20, 2013
Laptops stolen MacBook Pro and Samsung UltraBook NP540U3C
Well my laptop(s) were stolen last night at:
Cineplex Odeon Queensway Cinemas
[Islington & Queensway]
1025 The Queensway
Toronto, Ontario
M8Z 6C7
Canada
I would gladly pay a reward for information about the where abouts of these machine(s). The information on these machines (eg: personal photos, etc.) would mean nothing to other ppl but is valuable to me.
1) 13" MacBook Pro with French keyboard
Has a user called, "TAF" and "Stewart" a wallpaper of the Epic film. Screen mockup here.
2) Samsung UltraBook NP540U3C 13.3".
These were in a Kensington Laptop Bag.
There is numourous cables, accessories, battery charges, etc.
Along with these were suite cases of clothing and a new winter jacket.
Contact: stewart.whaley@gmail.com
Subscribe to:
Posts (Atom)