@tonyrogerson some people use (SMALL)DATETIME as a key, e.g. for reporting, so GETDATE()/SYSUTCDATE() etc. #sqlfaq #sqlhelp

Looking at methods to generate a surrogate key value - IDENTITY, NEWID, NEWSEQUENTIALID, diy, hashing (SHA1 ??) - any more?#sqlfaq #sqlhelp

Feels like I'm writing a book on surrogate keys, Part 1 blogged http://bit.ly/bRbFjX (Rules for surrogate keys, problems they solve) #sqlfaq

Is anyone hiring at the moment? Looking for a London-based BI focused role

@philcr I'd really like to see Surface with a 2008 R2 demo on it taking full advantage of the kit - that would be cool! #sqlfaq