Database Security, Audit, Privacy and Support Blog

LewisC's An Expert's Guide To Oracle Technology

My head seems to be in the clouds these da

LewisC's An Expert's Guide To Oracle Technology

I've been working with EnterpriseDB's cloud offering recently and started looking around at what other databases are doing in the cloud.

Amazon's SimpleDB

Amazon is the 500 pound gorilla. The market leader in cloud computing also offers a very simple database called, appropriately, <a href="http%3A%2F%2Fwww.amazon.com%

Hi all. This will be a short one. I'm on a plane on the way to New Jersey. I just recently started using Opera-mini and wanted to see if I could post. I couldn't with the default blackberry browser. It appears to be working. Now I can blog from anywhere! My wife will love that. ;-). She already hates it. She hates twitter too. Opera-mini is a nice little browser. Excellent support for most of the pages I frequent. Take care, LewisC

LewisC's An Expert's Guide To Oracle Technology

I was recently in Boston to sit on a panel to discuss cloud computing. There were two panels and several keynotes. Take a look <a href="http://www.xconomy.com/boston/2008/06/19/google-microsoft-akamai-join-powerhouse-speaker-lineup-for-xconomys-june-24-cloud-computing-forum

LewisC's An Expert's Guide To Oracle Technology

If you haven't listened yet, make sure to listen to Oracle RAC experts Philip Newlan and Scott Jesse talk about RAC and Grid. Some topics that you'll hear:

<h3 style="MARGIN: 14pt

LewisC's An Expert's Guide To Oracle Technology

I'm going to be in Boston on Tuesday to sit on a panel about Cloud Computing. I don't have a lot of info to share right now but I plan to do so after the event. This is an exciting opportunity to speak about <a href="http://www.enterprisedb.com/about/news_events/press_relea

LewisC's An Expert's Guide To Oracle Technology

This is not a technical entry. This is a story about bad luck, bad drivers, bad traffic, and a head-on collision.

Bad Luck

My wife, my sons and I were preparing to leave New Orleans after the recent trip for the <a href="http://blogs.ittoolbox.com/oracle/guide/archives/the-road-to-odtug-v2

LewisC's An Expert's Guide To Oracle Technology

Well, we're here at ODTUG Kaleidoscope 2008 in New Orleans. Sunday was a mini-day for me as it involved recovering from 2 days in a car with with an infant, a 5 year old and a tired wife. ;-) It also involved fresh boiled crawfish, etouffee, gumbo and jambalaya. I did make it to a session though but it was a session for presenters and ambassadors.

Monday was a better day for te

LewisC's Random Thoughts

I was unzipping a set of files from a zip file in Vista Ultimate 64 using the built-in unzip. The individual files were not very big, 17.8MB but there were a lot of them, > 3000. The file system is NTFS. The funny thing is that the amount of time shown below is not the largest number it showed.

<img src="http://s3.amazonaws.com/sc

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

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

EnterpriseDB News at Blogspot

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

Q&A about RAC and Grid with the RAC Experts

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?

Take a survey

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