Monthly Archives: November 2009

Some Basic Interview Advice

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

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

For SQL 2005+ [sourcecode language=”sql”] 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 … Continue reading

Posted in SQL Server | Leave a comment

SQL Server: Show all the PRIMARY KEYS for a TABLE

For SQL Server 2005 + [sourcecode language=”SQL”] 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 = … Continue reading

Posted in SQL Server | Leave a comment

Grumpy = Good

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

Posted in Uncategorized | Leave a comment

Interview Feedback

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 – … Continue reading

Posted in Recruitment, Work | Leave a comment