Latest Publications

A few good posts for MySQL and Postgres

Thought I would share a few links that I read this morning. I don’t do a lot of link posts but these three came off my RSS, one after the other, and all three are worth sharing.

The first is Will Oracle kill MySQL? Come on people! I can’t believe people are still stuck on this FUD. Ronald gives some good reasons why that is not likely. The only thing this kind of FUD really does is drive people to Postgres (and that postgres derivative that starts with an E and ends with a DB). ;-) I’m glad Ronald was able to set the record straight.

Click to continue reading “A few good posts for MySQL and Postgres”

Agility and Analysis

As developers, analysts, adminstrators, etc, I think most of us tend towards perfectionism. We want to do the job right and we want to do the job right the first time around.
Agility means being able to move forward with less than perfect information. Sometimes it means moving forward with information that is known to incomplete or even potentially inaccurate.
So what does that mean for analysis? Analysis, by definition, is the separation of individual components from the whole. The goal being, at least in my universe of activities, to be the understanding of a business proccess’s basic feature set and the relationships between those features.

Click to continue reading “Agility and Analysis”

Twitter Weekly Updates for 2010-07-13

  • Got my OCP card in the mail today. http://twitpic.com/230ilr #
  • DB Geek says: Twitter Weekly Updates for 2010-07-06:

    Blogged "ODTUG Kaleidoscope 2010 – The Journey So Far" htt… http://bit.ly/bVYwF2 #

  • Cloud Comments: Comment on A quick overview of PuTTY and SSH for AWS Newbies by Installing a headless GeoServer on… http://bit.ly/d1jO66 #
  • Interesting. Oracle Adds Support for Open-source R (the language) http://bit.ly/bpA7mh #
  • I slept right through the bi 11g webcast. Didn't even notice it was AM until now. Bummer. #
  • Blog Talk: Comment by Chris Barnhart on EDB Tip #4 Database Links in EDB http://bit.ly/9iyGHq #
  • Blog Talk: Comment by Lewis Cunningham on EDB Tip #4 Database Links in EDB http://bit.ly/aSEngt #
  • Interesting (dated) stat: oracle ebs 11i used hints on .3% of its 270000 queries.

Click to continue reading “Twitter Weekly Updates for 2010-07-13″

Twitter Weekly Updates for 2010-07-06

Click to continue reading “Twitter Weekly Updates for 2010-07-06″

Twitter Weekly Updates for 2010-06-29

  • Blog Talk: Comment by Christopher Hamilton on Yahoo Sucks! Google wins. http://bit.ly/cb7OVe #
  • @datachick I always thought waterboarding sounded like fun. Like dragging you around behind a boat on board. Wheeee! in reply to datachick #
  • DB Geek says: Twitter Weekly Updates for 2010-06-22:

    Blogged "Stupid Proc Tricks -The Weird and Wonderful Overl… http://bit.ly/bdSH3i #

  • Blog Talk: Comment by jonesr on Yahoo Sucks! Google wins. http://bit.ly/daOfcG #
  • Oracle's iRecruitment.com gives me an error on the 3rd page. It's slow too. #
  • Blog Talk: Comment by Lewis Cunningham on Yahoo Sucks! Google wins. http://bit.ly/byaoKO #
  • Having the surrogate key vs natural key discussion. Again. Ever get tired of doing the same thing over and over?

Click to continue reading “Twitter Weekly Updates for 2010-06-29″

Twitter Weekly Updates for 2010-06-22

  • Blogged "Stupid Proc Tricks -The Weird and Wonderful Overload" http://it.toolbox.com/trd/46/2/39311/3 #
  • My 2 year old turned off the refrigerator and unscrewed the light bulb. I fear what he will do when he discovers the screw driver. #
  • DB Geek says: Stupid Proc Tricks -The Weird and Wonderful Overload: <!–
    google_ad_client = "pub-4372398370642959"… http://bit.ly/bPVMI2 #
  • Blog Talk: Comment by harishkumar on Learn Oracle – What is Oracle? http://bit.ly/8ZSrvx #
  • Blog Talk: Comment by "Jeffrey Kemp" on Stupid Proc Tricks -The Weird and Wonderful Overload http://bit.ly/dp1Qsi #
  • Blog Talk: Comment by "Jeffrey Kemp" on Stupid Proc Tricks -The Weird and Wonderful Overload http://bit.ly/dp1Qsi #
  • Blog Talk: Comment by Nini on Oracle and XML In Action – A Real World Example http://bit.ly/dlZBXL #
  • A dilbert example of "trust, but verify" http://bit.ly/cSD4Sq #
  • @pioro Congrats on the acehood!

Click to continue reading “Twitter Weekly Updates for 2010-06-22″

Yahoo, you are dead to me.

Yea, I know. Quite the dramatic title. Work with me for a sec.

I’m pissed. Really pissed. Advance warning: I will rant now.

I forget the exact year but in the early 90s (I think 1993 or 94), I signed up for a novel service. Online email. Remember this is the early 90s. I was an early adopter even back then.

The internet was mostly character based and mostly used by universities, some larger companies and government. People using the internet were using email, usenet and ftp (and some crazies were using veronica, jughead, archie and gopher).

Click to continue reading “Yahoo, you are dead to me.”

We’ve had problems with that!

So what can I say? One of the phrases I hate most is “We’ve had problems with that.” I have seen that, or some form of that, question used as an excuse to not try new features, to not use best practices, keep a head in the sand, stick to Oracle7 features, etc.

As an example, in my early days with data modeling, I once created a new schema. It wasn’t a very big schema; probably 10 tables or less. I spent a lot of time doing the analysis to make sure I got the data structures correct. The ERD was sent around and got approval from everyone.

Click to continue reading “We’ve had problems with that!”

Twitter Updates for 2010-06-15

  • Blogged "Stupid Proc Tricks -The Weird and Wonderful Overload" http://it.toolbox.com/trd/46/2/39311/3 #
  • My 2 year old turned off the refrigerator and unscrewed the light bulb. I fear what he will do when he discovers the screw driver. #
  • DB Geek says: Stupid Proc Tricks -The Weird and Wonderful Overload: <!–
    google_ad_client = "pub-4372398370642959"… http://bit.ly/bPVMI2 #

Powered by Twitter Tools

Stupid Proc Tricks -The Weird and Wonderful Overload

When overloading a procedure or function it is the calling parameters that make the difference. The return type does not make a difference as far as the ability to overload. Generally, when talking about overloaded procedures, you will hear or read something like “You must change at least one of the parameter data types to overload it.” But that’s not really true.

Click to continue reading “Stupid Proc Tricks -The Weird and Wonderful Overload”

Twitter Weekly Updates for 2010-06-07

Click to continue reading “Twitter Weekly Updates for 2010-06-07″

Twitter Weekly Updates for 2010-05-31

Click to continue reading “Twitter Weekly Updates for 2010-05-31″

Twitter Weekly Updates for 2010-05-24

  • DB Geek says: Twitter Weekly Updates for 2010-05-17: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/aXWadD #
  • Blog Comments: Comment on uCertify Oracle Certification Software Review by LewisC: Just a year late but Congrats o… http://bit.ly/d3E1Mf #
  • Blogged "PHP for PL/SQL Developers: Include Files, Connecting to Oracle and Selecting Data" http://it.toolbox.com/trd/46/2/38739/3 #
  • Updated my PHP for PL/SQL Developers post with links to all the posts so far: http://bit.ly/php_ora #
  • RT @orana Suncoast Oracle Users Group, May 27, 2010 http://ff.im/-ktELE The OLTP DBA’s Guide to Delivering a Dimensional Model. #
  • @datachick I got my email about voting today too. Guess I'll go get it done.

Click to continue reading “Twitter Weekly Updates for 2010-05-24″

Twitter Weekly Updates for 2010-05-17

Click to continue reading “Twitter Weekly Updates for 2010-05-17″

Twitter Weekly Updates for 2010-05-09

Powered by Twitter Tools

Twitter Weekly Updates for 2010-05-02

Powered by Twitter Tools

Twitter Weekly Updates for 2010-04-25

Powered by Twitter Tools

Twitter Weekly Updates for 2010-04-18

  • DB Geek says: Twitter Weekly Updates for 2010-04-11: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/blFgRo #
  • Blogged "Why projects fail. Reason #113" http://it.toolbox.com/trd/46/2/37942/3 #
  • Trying out the officalt blackberry twitter client. Soso #
  • Twitter for bb makes my red light blink when ANYone I follow tweets. That means my red light never stops. Annoying. #

Powered by Twitter Tools

Twitter Weekly Updates for 2010-04-11

  • DB Geek says: Twitter Weekly Updates for 2010-04-04: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/9P2t5N #
  • @craigmullins just reads your march dbta column. Good stuff. Agree with osdb move from easy to complex comment. in reply to craigmullins #
  • Cloud Comments: Comment on Defining Cloud Computing: Part 6 – IaaS by Basant Singh: Rackspace is also a leading Ia… http://bit.ly/9z9LD8 #
  • Cloud Comments: Comment on About by Neha Sharma: Hi,
    I am very impressed with your blog which has some amazing pos… http://bit.ly/9pbAVM #
  • Cloud Comments: Comment on A quick overview of PuTTY and SSH for AWS Newbies by Daminda: Hi bro,
    Thank you for thi… http://bit.ly/8Yflzh #
  • Michael Stonebraker?s take on NoSQL. Good read.

Click to continue reading “Twitter Weekly Updates for 2010-04-11″

Twitter Weekly Updates for 2010-04-04

  • DB Geek says: Twitter Weekly Updates for 2010-03-28: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/aAGEHw #
  • DB Geek says: Twitter Weekly Updates for 2010-03-21: Got a reply email from a recruiter. Started off with"sorry fo… http://bit.ly/9xkyD6 #
  • back from the cruise. Mixed emotions. ;-) #
  • Muhahahahaha. RT @fmanjoo: Teabonics. Flickr set of misspelled Tea Party signs. This made my morning. http://bit.ly/dy9DR3 #
  • This is hilarious – RethinkDB is switching over to Lisp http://bit.ly/9bx2l7 #
  • Oracle ace director and java champion teleconference just getting started. Please mute your phones people. #
  • @chriscmuir viki is recording it now. in reply to chriscmuir #
  • 100ish ace directors, 300ish aces, 110ish java champions. Cool. My first knowledge of java champions.

Click to continue reading “Twitter Weekly Updates for 2010-04-04″

Twitter Weekly Updates for 2010-03-28

  • Blogged "Give Evil a Break" http://it.toolbox.com/trd/46/2/37597/3 #
  • Sitting in a sprint planning meeting. Screw pigs and chickens. I wanna be a scrumlord! #
  • Coughing. Breathing rough. Chest hurts. What does pneumonia feel like? I don't have fever or nausea. #
  • @datachick heh. Xml fixes everything. Like the cloud. Xml cloud = nerdvanna! in reply to datachick #
  • ?Friendship, love, health, energy, enthusiasm, and joy are the things that make life worth living and exploring.? ? Denise Austin #
  • @fmanjoo I'm going with entropy. ;-) in reply to fmanjoo #
  • @peglegpug I got the perfect pullup. Works great. Pull ups turned out to be much harder than I remembered.

Click to continue reading “Twitter Weekly Updates for 2010-03-28″

Twitter Weekly Updates for 2010-03-21

  • Got a reply email from a recruiter. Started off with"sorry for the delay in responding." My message was from 2007. ;-) #
  • Cool! Watch instantly! RT @Techmeme: Netflix announced for Windows Phone 7 Series (Chris Ziegler/Engadget) http://techme.me/=IVb #
  • DB Geek says: Twitter Weekly Updates for 2010-03-14: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/awLyuk #
  • Blogged "Anti-Standards" http://it.toolbox.com/trd/46/2/37481/3 #
  • From Dr Dobbs. Hilarious! Larry Ellison on chatroulette talking about cloud computing. http://bit.ly/aO0dhU #
  • Dilbert speaking in words even management can understand. http://dilbert.com/strips/comic/2010-03-17/ #
  • I decided I want to become a certified scrumbastard. Then someone pointed out that it is scrummaster. Well then, nevermind. #
  • ODTUG Kaleidoscope 2010 early bird registration ends Mar 24.

Click to continue reading “Twitter Weekly Updates for 2010-03-21″

Twitter Weekly Updates for 2010-03-14

  • DB Geek says: Twitter Weekly Updates for 2010-03-07: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/9OCh9C #
  • My son asked me what I do at work. The best I could come up with was, "I struggle to keep myself amused". #
  • @dtseiler I like win7. Runs great. I've had no issues on 3 different comps. I also run vbox. I have 1 home prem and 2 ultimates. in reply to dtseiler #
  • Blog Comments: Comment on Twitter Weekly Updates for 2009-03-22 by Dakiwid: Ordinary citizens aerosol for your pai… http://bit.ly/cy1BH2 #
  • Blogged "March 1-7 is National Procrastination Week" http://it.toolbox.com/trd/46/2/37361/3 #
  • Decided to try chatroulette. Met a nice guy from nigeria. Works for a bank.

Click to continue reading “Twitter Weekly Updates for 2010-03-14″

Twitter Weekly Updates for 2010-03-07

  • DB Geek says: Twitter Weekly Updates for 2010-02-28: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/a8JhKJ #
  • Blogged "On Everquest, Emulators and MySQL" http://it.toolbox.com/trd/46/2/37207/3 #
  • Blogged "Would you like a free pass to ODTUG Kaelidoscope 2010? How about a hotel upgrade?" http://it.toolbox.com/trd/46/2/37247/3 #
  • Blogged "The NoSQL That Must Not Be Named!" http://it.toolbox.com/trd/46/2/37249/3 #
  • Wtf. Ice on the car windows again. In march. I live in the freaking tundra. What's next? Wooly mammoths? #
  • got an email from AARP. just about crapped myself. turns out it was just spam. I thought I had REALLY overslept. #
  • MySQL Comments: My current employer doesn't use Erwin so I can't t…: My current employer doesn't use Erwin so I …

Click to continue reading “Twitter Weekly Updates for 2010-03-07″

Twitter Weekly Updates for 2010-02-28

Powered by Twitter Tools

Twitter Weekly Updates for 2010-02-21

Powered by Twitter Tools

Twitter Weekly Updates for 2010-02-14

  • DB Geek says: Twitter Weekly Updates for 2010-02-07: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/barDm4 #
  • Who dat say dey gonna beat dem Saints? Who dat? Who dat? #
  • In a way, Manning couldn't lose. He played for hs team but his city won anyway. #
  • Blog Comments: Comment on JSON In (and out) of Oracle – JSON Data Type by anonymous: XML and JSON don’t convert ba… http://bit.ly/9VgZcQ #
  • Cloud Comments: Comment on Using and Managing AWS – Part 4: Choosing a Tool by Andy: Please consider adding CloudB… http://bit.ly/bvhPRW #

Powered by Twitter Tools

Twitter Weekly Updates for 2010-02-07

  • DB Geek says: Twitter Weekly Updates for 2010-01-31: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/cJsK50 #
  • Blog Comments: Comment on Twitter Weekly Updates for 2009-06-07 by over the counter nail fungus treatment: over th… http://bit.ly/criJK5 #
  • Blog Talk: Comment by upendra on Oracle Streams Configuration: Change Data Capture http://bit.ly/cnzP3x #
  • Blog Talk: Comment by Mkoneru on Learn PL/SQL: Procedures and Functions http://bit.ly/9XRGdV #
  • Blog Talk: Comment by Lin Brann on Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks http://bit.ly/bCEYOa #
  • Blogged "Computer Grayskull, aka Computer Lab in a Box" http://it.toolbox.com/trd/46/2/36664/3 #
  • About to start my presentation on fine grained access control.

Click to continue reading “Twitter Weekly Updates for 2010-02-07″

Twitter Weekly Updates for 2010-01-31

  • DB Geek says: Twitter Weekly Updates for 2010-01-24: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/8ukSuT #
  • Blogged "Full day *Sunday* training sessions for ApEx, SOA/BPM, Hyperion/Essbase and Web…" http://it.toolbox.com/trd/46/2/36577/3 #
  • Work now blocks facebook, twitter, my blog, and anything with "mail" or "forum" anywhere in the url. Annoying. I love my blackberry. #
  • @datachick yeah, kind of silly really. in reply to datachick #
  • @jpiwowar Geaux Saints! Nola gonna shut down for that game. If the saints win, nola will shut for the week. in reply to jpiwowar #
  • @jkuramot not overshadowed in any conversation I follow. Favre on the ground.

Click to continue reading “Twitter Weekly Updates for 2010-01-31″

Twitter Weekly Updates for 2010-01-24

  • DB Geek says: Twitter Weekly Updates for 2010-01-17: <!–
    google_ad_client = "pub-4372398370642959";
    /* 468×60, cr… http://bit.ly/7pvjs9 #
  • ODTUG interviewed me: http://bit.ly/7O89vR #
  • Filed under better late than never – just got my newhire laptop bag – only 380 days after I started. Nice bag. ;-) #
  • RT @TheOnion: In Focus: Nations Liberals Suffering From Outrage Fatigue http://onion.com/7rHrzr #
  • Going to exadata seminar today. Google maps gave me waaaaaay wrong directions. Fortunately, I could tell and got good directions. #
  • @lonnekedikmans what if you change something? Should it autosave? Lose original or do versioning? How many versions? in reply to lonnekedikmans #
  • Agenda for exadata seminar.

Click to continue reading “Twitter Weekly Updates for 2010-01-24″

 
WordPress Loves AJAX