topic SQL worst practices - 3 part video presentation in Application Development and Automation Discussions

SQL worst practices - 3 part video presentation

Former Member — Wed, 07 Jan 2009 11:18:40 GMT

Hi ,

It is SQL worst practices - presented in 20 minutes by Stephane Faroult.

Note to all developers:

watch these - they are good, they are correct (they are ironic, anti-patterns, don't do them - do the opposite).

Some people have said they could not see the embedded videos (probably using a news aggregator/reader - not the source entry itself). Here are the links :

Part 1: http://www.youtube.com/watch?v=40Lnoyv-sXg

Part 2: http://www.youtube.com/watch?v=GbZgnAINjUw

Part 3: http://www.youtube.com/watch?v=y70FmugnhPU

bye

Re: SQL worst practices - 3 part video presentation

HermannGahm — Wed, 07 Jan 2009 19:10:41 GMT

Hi,

there is another one from the same guy... explaining different join algorithms

http://www.youtube.com/watch?v=SmDZaH855qE

Kind regards,

Hermann

Re: SQL worst practices - 3 part video presentation

Former Member — Thu, 08 Jan 2009 07:43:33 GMT

Hi Hermann,

yeah - i think what's needed in the forum is a BASIC Sql knowledge and that the developers are responsible for their slow running code IF they ignore all that basic stuff.

bye

Re: SQL worst practices - 3 part video presentation

Former Member — Thu, 08 Jan 2009 08:02:15 GMT

I recommend to read his book ( no, I get no charge for it )

Stephane Faroult: "The art of SQL"

O'Reilly Media, Inc. (March 1, 2006)

Language: English

ISBN-10: 0596008945

ISBN-13: 978-0596008949

http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1231401568&sr=8-1

it's basic stuff and experts likely reject to read such things,

but on my job we work in a big datawarehouse environment with a lot of developers (together they will have over 100 years expierience , I guess).

But sometimes it's unbelievable how they ignore (or just don't know about) the basics. This leads sometimes of asking me to do the traditional DBA's "Magic performance parameter dance".

So I had to start my SQL evangelisation against the sql heathens...hope I don't get crucified

bye