LewisC's An Expert's Guide To Oracle Technology
It was the best of times, it was the worst of times. I'm reusing that stolen line from my post in 2005, The Road to ODTUG. That was the last time ODTUG Kaleidoscope was in New Orleans, just a few months before Katrina hit.
I somewhat complained about $2.
LewisC's An Expert's Guide To Oracle Technology
So, when does something become a fact of daily life rather than bleeding edge? I guess the New York Times is probably not that point, more like National Enquirer. Anyway, you know something is primed and ready to blow when the New York Time covers it. That's why I as happy to see Database Support, General, Oracle
LewisC's An Expert's Guide To Oracle Technology
There's a new Postgres site in town: PostgresRocks. You can download Postgres here but the best feature is that documentation for a bunch of common Postgres support tools is available on the documentation page. The doc
Today's post is one of the most important in the history of database blogging: the 100th entry of Log Buffer! Ok, maybe it's not that important but it's still a big deal. Once a week for 100 weeks is a life time in web years. If it was a dog, why it would be like, I don't know, 15 years old? I think I might name my next dog log buffer. But with an underscore.
Of course, the 1
LewisC's An Expert's Guide To Oracle Technology
Oracle has a social community called Oracle Mix. Not only is it a social site, you get to talk to Oracle and help Oracle make decisions. Membership to mix is free and is tied to your OTN ID.
Oracle has opened up a few sessions at Oracle OpenWorld and is allowing Mix users to vote on
LewisC's An Expert's Guide To Oracle Technology
This book, Physical Database Design, is sub-titled "The Database Professional's Guide To Exploiting Indexes, Views, Storage, and More". Not only is it a wordy sub-title, it's a deep read. This book is not a beginner's book. If you are an experienced database professional, I pretty mu
LewisC's An Expert's Guide To Oracle Technology
Looks like I have a new boss. Actually, it looks like my boss's boss has a new boss. ;-)
I'd like to personally welcome Ed Boyajian to EnterpriseDB. Looks like he has quite a bit of experience with OSS and monetizing software solutions. He's been an executive at <a href="http://www.redhat.com/
LewisC's An Expert's Guide To Oracle Technology
The datastore in Postgres (which is what Advanced Server is based on) is quite a bit different than the way Oracle stores data. Gone are the usual logical storage components. Data blocks, extents and segments just don't exist in a Postgres database. Actually, segments do exist when a table gets bigger than 1GB but that's a story for a different entry.
Postgres stores data as f
This isn't related to my blogging. I use Zoundry Raven for blogging and am very happy with it. I am asking about HTML editors for a regular web site that I am working on.
I used Arachnophilia for a long time as my HTML editor. It's a robust editor, but it really is that, an editor. It's starting to feel a bit long in the tooth for me. I've decided to move on to a more CSS oriented WYSIWYG
LewisC's An Expert's Guide To Oracle Technology
Sun just announced MySQL Workbench, a new database design tool for MySQL developers and DBAs. I'm a data modeling tool junkie. I like to play with any I can get my hands on. I've used almost every modeling tool that's been built. My all time favorite is probably <a href="ht
Chris Keene, the CEO for Wavemaker just blogged that combining Wavemaker and EnterpriseDB just got easier. Wavemaker has a new version that has out of the box support for both Postgres and EnterpriseDB.
I wrote a couple of weeks ago about <a href="http://blogs.ittoolbox.com/oracle/guide/archives/wavemaker-training-day-1-2
LewisC's An Expert's Guide To Oracle Technology
I recently got the opportunity to sit down and talk to two RAC gurus and learn what RAC is and how it relates to Oracle's Grid technology. Listen to
LewisC's An Expert's Guide To Oracle Technology
According to an article at Computerworld, Yahoo is running a 2 PB (not GB, not TB, PB - Petabyte) database that processes 24 billion events a day. Let's put that in perspective. 24 billion events is 24,
LewisC's An Expert's Guide To Oracle Technology
An ITToolbox user recently asked a question on the EnterpriseDB discussion group, Oracle equilant UTL_I18N.STRING_TO_RAW IN ENTERPRISEDB.
Basic
LewisC's An Expert's Guide To Oracle Technology
ODTUG Kaleidoscope 2008 is in my favorite city, New Orleans, from June 15-19. I won't be getting there until either late Saturday or some time Sunday. Once again, I'm driving with my family. Once I'm there, I have plenty of extra-curricular activities planned (like visiting my mom, going to the aquarium and zoo, taking the boys on the st
LewisC's An Expert's Guide To Oracle Technology
This ain't no Flickr! Every blogger needs a place to host screen shots. Flickr is the best place for photos (IMHO) but they ask that all the images you post be photos (not that they're rabid about that). But now there's SCRNSHOTS.com. Unlimited screen shot uploads. You can tag them for easy searching. The photo b
LewisC's An Expert's Guide To Oracle Technology
By request, this entry will discuss some issues surrounding DML triggers. Triggers are a nifty feature. When you need them, they are very useful. They can also make maintenance and debugging an absolute nightmare.
API vs Trigger Approaches
I am an API style program
LewisC's An Expert's Guide To Oracle Technology
Have you heard of Plaxo? I've been a member for a while though I'm not a heavy user. Plaxo is sort of a social networking address book. It's a decent little site.
Have you heard of Comcast? They're sort of the <a href="http://www.google.com/search?q=comcast+evil&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en
LewisC's An Expert's Guide To Oracle Technology
In December 2006, I wrote an entry called Oracle Streams Configuration: Change Data Capture. That entry turned out to be very popular. It's had a lot of comments. I've also had a few questions. One of the questions is how someone could capture both the new and old valu
LewisC's An Expert's Guide To Oracle Technology
Do you know which open source feature is the most important? Do you know which open source database rocks and which one sucks? Is MySQL better than Postgres? Is Ingres worth considering? How does Firebird compare? Have you used, or have you considered using, an open source database?
LewisC's An Expert's Guide To Oracle Technology
I mentioned the other day that I was playing with a new GUI builder from an EnterpriseDB partner, Wavemaker. Wavemaker, in addition to providing the software, provides some training that is downloadable fr
LewisC's An Expert's Guide To Oracle Technology
Today I will be writing about triggers. One of the questions I get fairly often is "what is the difference between a function, a procedure and a trigger?" I already wrote about functions and procedures in <a href="http://blogs.ittoolbox.com/oracle/guide/archives/learn-plsql-procedures-and-functions-13
LewisC's An Expert's Guide To Oracle Technology
Welcome to newbie Monday. Today's topic is choosing your database. Choosing a database for your business has some commonalities with choosing a database as a new developer or DBA. There are also differences though. Here are a few guidelines to getting started. This is not a complete guide but it is meant as a starting place.
If you are already an Oracle shop, or DB2 shop, or w
LewisC's An Expert's Guide To Oracle Technology
The latest release of the EnterpriseDB database, Postgres Plus Advanced Server (AS) 8.3, includes additional Oracle compatibility features. Two of those new features are DBMS_PIPE and DBMS_ALERT. Old Oracle hands will recognize those two packages that are used for interprocess communication. This post is a quick tutorial on using these two features. If you've used them in Oracle, you
LewisC's An Expert's Guide To Oracle Technology
I just realized my 3 year anniversary on ITToolbox past me by on 3/18/08. I think I noticed and was going to post something about it but then I guess something else caught my attention. This post is #531. I have made 11084 posts of some sort or another. In a way it seems like I've been doing this a lot longer and in another way it seems like I just started.
I don't know how ma
LewisC's An Expert's Guide To Oracle Technology
Wavemaker is an Open Source GUI builder that is based on Spring, Hibernate and the Dojo toolkit. The company that produces the software, Wavemaker Software, is a new partner with EnterpriseDB. With that in mind, I decided to start playing with the tool to see how easy it is to use and how far it can go.
To
The publisher of my book, EnterpriseDB: The Definitive Reference, recently made the book available on the web in PDF format. You can also download
LewisC's An Expert's Guide To Oracle Technology
ITToolbox.com has introduced a new community for EnterpriseDB users. It's an email group for asking questions and posting comments. I've joined the group and will be keeping an eye for messages. It wouldn't surprise me if others at EnterpriseDB also keep an eye on the forum.
You can get there by going to <a href="http://database.ittoolbox.com/groups/technical-functional/enterp
LewisC's An Expert's Guide To Oracle Technology
My previous list of tips seems to be popular so I thought I would add a few more database specific tips. I'm keeping this list database agnostic. These 10 should apply to any database you might want to learn.
LewisC's An Expert's Guide To Oracle Technology
I think the concept of cloud computing and cloud storage has been bandied about long enough that most people get it and they get the business case. I'm not sure people get the use for databases in the cloud.
If you are completely unfamiliar with the term "cloud computing", check out the Wikipedia cloud entry. As you ca
Recent Comments