Very interesting article Herve, though I found it tweaking my curiosity from another angle.

Spent a few days leisurely trying to coerce VB(6) into creating a 'special' extended stored proc DLL...

Good to see a book about this, a topic that's been around some time, but never formalised. Not aware of any formal methodology for safely changing code once it's in...

Why did I go down the DBA route? I'd been programming for 20 years, 10 commercially, and decided I needed a change, but wanted to stay in IT and...

Steve,

Completely agree with your comment that "The only place where I have seen them useful is in allowing developers to create their own tables for testing." Had a hell...

DBAs have a far higher chance of writing decent, set based SQL. Most developers don't get past simple selects and inserts, and prefer to process a row at a...

If you can't explain how it works, there's probably a better, simpler, clearer solution which you should adopt instead.

Jon Reade

Write code so clearly that you can still understand it in a year.

That way, someone else will.

Jon Reade

..you have to tell recruitment agents "No, MICROSOFT Sql Server, not SYBASE"...

Jon Reade

...you get *really* worked up about the indents in Query Analyser not displaying properly when you double click on a stored proc in Enterprise Manager.

Jon Reade

You stop the Visual Basic programmers from creating stored procs under dbo because it's less grief to manually check every one first than to implicitly trust their idea of well...

Here we go - good old British compromise.

I believe that both Steve and Andy are right. Why? Well, when it comes to the crunch, if it's you vs someone without...