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?
I made my way again this year to one of the best, if not the best, user group conferences, the Rocky Mountain Oracle User Group Training Days, held in Denver Colorado on the 6th and 7th of February. Huge kudos to Kellyn Pot’Vin and the rest of the organizing team (see her review here) for […]
This Thursday, Feb 20, I will be giving a full day of free Oracle performance classes. Remember the serve the best lunch ever at the Oracle conference center . It’s top class!
Here is the write-up from NoCOUG on the day: