Phil Factor

Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 40 years of experience with database-intensive applications. Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career. See also :

Follow on

20 January 2006
20 January 2006

Getting Stuff Into SQL Server

0
0
Often, Newbies to SQL Server are left feeling puzzled by the difficulty of ‘Getting stuff in and out’ of data tables. At first it does seem daunting, and I have to admit that I’m still a bit vague on some aspects myself. How, (or why) would one get image data in or out of a … Read more
0
0
13 January 2006
13 January 2006

A SQL Limerick

0
1
It wasn’t my idea at all. However someone set me the challenge of writing executable code that rhymed and scanned in the form of a limerick. Obviously, the easy trick is to just to write the limerick, assign it to a string and then do text substitution on that striing to convert it into SQL … Read more
0
1
04 January 2006
04 January 2006

Unreadable code

0
0
Producing unreadable Transact SQL is something of an art form. We all know that the best Transact SQL Style is to make everything elegant and obvious, with explanatory identifiers, liberal comments and deft formatting. It doesn’t always happen, for a number of reasons. One of the more subtle effects of acute caffein poisoning is to … Read more
0
0