SQL worst practices

February 6th, 2008

If anything you do is somehow related to databases, you absolutely, definitely have to see these videos: 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 Go the links from Tom Kyte’s blog.

gee, a book review

January 29th, 2007

Finished Analytics&OLAP in SQL by Joe Celko today. A very “blog-style” book, some very good ideas, some repeats (read “Trees&Hierarchies in SQL” previously), sarcasm and a set of good examples. Not a starter-book, but a recommended reading for anyone interested in data analysis. “Tape-based” approach and Von Neumann logic still dominate IT. SQL is bad [...]