Search

OakieTags

Who's online

There are currently 0 users and 39 guests online.

Recent comments

Affiliations

Uncategorized

Outer Joins : which side does the (+) go on

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.

Managing database dependent development

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

Pure Storage and Delphix

chocolate_peanutbutter

Joint webinar:

Super Charge Database Deployments

 

 

pure_storage  delphix_logo_color

NYC, NYOUG and Delphix on March 12 & 13

 

NYC_thomashawk

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.

Web ASH : W-ASH

I’m excited about the ease of creating rich user applications  that are web enabled  given the state of technology now. JavaScript and JQuery have gone from being disdained as “not a very serious” language to moving towards the limelight of front and center.

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

Oracle Developer Day Perth

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.

Lineage of the 100-400 slide PPT

 

5727330912_ca5a5a7760graphic 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?

RMOUG Training Days 2014

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 […]

Full free day of performance class at Oracle Corp

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!

Register here

Here is the write-up from NoCOUG on the day: