Monthly Archives: November 2009

Short Story Titles

Posted on November 6, 2009 by Kramii

Eight ideas for short story titles from the man behind WriteInvite: Loyalty Cards The Shopping Channel Ideal Travelling Companion Bakewell Tarts Vitamin Pills JB’s Nappies Cardigans Crocodile Tears  

Posted in Writing | Leave a comment

Some Basic Interview Advice

Posted on November 6, 2009 by Kramii

Notes from a recent training session (rather a basic one - but fundamentals are easily forgotten in stressful situations) : Advance Preparation Keep a copy of the job advert and specification. Keep a copy of your application form / CV Research … Continue reading →

Posted in Uncategorized | Leave a comment

The Fold

Posted on November 5, 2009 by Kramii

There has been a long running debate amongst web designers as to whether or nor “the fold” matters, or even exists. Here are my thoughts: Of *course* users know how to scroll. Just like they know how to unfold physical … Continue reading →

Posted in Web Design | Leave a comment

SQL Server: Show all the FOREIGN KEYS that reference a TABLE

Posted on November 5, 2009 by Kramii

For SQL 2005+ DECLARE     @tableName nvarchar(MAX) SET     @tableName = 'tableName' — (1) SELECT DISTINCT      ccu.table_name,      ccu.constraint_name FROM      INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc INNER JOIN      INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc           ON rc.unique_constraint_name = tc.constraint_name INNER JOIN      INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu           ON … Continue reading →

Posted in SQL Server | Leave a comment

SQL Server: Show all the PRIMARY KEYS for a TABLE

Posted on November 5, 2009 by Kramii

For SQL Server 2005 + DECLARE @tableName nvarchar(MAX) SET @tableName = 'tableName' — (1) SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME, kcu.ORDINAL_POSITION FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu ON tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME WHERE tc.CONSTRAINT_TYPE = 'PRIMARY KEY' AND tc.TABLE_NAME = @tableName OR … Continue reading →

Posted in SQL Server | Leave a comment

Grumpy = Good

Posted on November 5, 2009 by Kramii

Humph. Apparently, feeling grumpy is good for you. So, that’s ruined that, then.  

Posted in Uncategorized | Leave a comment

Interview Feedback

Posted on November 4, 2009 by Kramii

Having secured my demotion I asked some of the interview pannel to provide feedback on my presentation / interview. Persentation Strategy and Style A risky strategy, but it worked – ND Liked it – ND Personally enjoyed it – MD … Continue reading →

Posted in Recruitment, Work | Leave a comment