After a Tanel Poder pointed out to me that someone had blogged my article verbatim, which I don’t really care about, but they had copied the article verbatim without crediting me, which I do care about, I decided I’d just re-blog this. The article is best formatted at link:http://tinyurl.com/ybyjazq
Bobby Durrett just put together a great little post on “outer joins : where do I put the (+)“.
I also have hard time remembering, and below is my cheat sheet using graphics.
If English and French both have a unique key on the “ordinal_id” then it’s basically one-to-one relationship
We add an arrow in the middle of the line to denote “outer join”. The arrow points from the table that drives the join, ie all the rows in the table pointed from are returned even if a match isn’t found in the table pointed to.
Application developers frequently experiment to achieve higher quality builds, they try things out, make mistakes and find fixes. Database design can be like that too, but rapidly changing the schema in traditional shared environment tends to break the application.
In this webinar, Kyle Hailey will explore how different types of cloning technology work and their benefits and limitations. The webinar will also demonstrate how you can setup and coordinate risk-free database experiments using Delphix and Red Gate’s Oracle tools.
Kyle Hailey and James Murtagh
photo by Thomas Hawk
Interested in talking face to face about Delphix in NYC? Drop me a line. I’ll be in NYC on March 12th and 13th and look forward to meeting folks who are excited to learn more about Delphix.
Here is a small example.
Download the following file: W-ASH (web enabled ASH, file is wash.tar.gz )
Source is also on github at https://github.com/khailey/wash
Go to your apache web server root, in my case on redhat Linux is
Well…it was a great day with over 100 people attending.
I had the standard fail of trying to show people 200 things that I think are important, in a time allowing only for 50 things, but better to be overfed than starving :-)
Links to the slides are below. Thanks everyone for coming – hope you had a great day.
graphic by Frits Ahlefeldt-Laurvig
There is the Mandel approach to power points in presentations where one is suppose to spend 3 minutes per slide, thus a 60 minute presentation is 20 slides or less.
How about going the other way, showing 3 or more slides per minute?